text: 
  
  -------------------------------------------------------------------------------
  --  task def escalation
  -------------------------------------------------------------------------------
  -- notification, reassignment, operation
  CREATE TABLE TASK_DEF_ESCALATION(
  	ID BIGINT NOT NULL,
  	TYPE VARCHAR(50),
  	STATUS VARCHAR(50),
  	ESCALATION_CONDITION VARCHAR(200),
  	VALUE VARCHAR(200),
  	DEADLINE_ID BIGINT,
          CONSTRAINT PK_TASK_DEF_ESCALATION PRIMARY KEY(ID),
          CONSTRAINT FK_TASK_DEF_ESCALATION_DEADLINE FOREIGN KEY(DEADLINE_ID) REFERENCES TASK_DEF_DEADLINE(ID)
  ) ENGINE=INNODB CHARSET=UTF8;
  
  
  
  
  
  
  
  
  
  
  