text: 
  
  -------------------------------------------------------------------------------
  --  pim remind
  -------------------------------------------------------------------------------
  CREATE TABLE PIM_REMIND(
          ID BIGINT NOT NULL,
  	TYPE VARCHAR(50),
  	REPEAT_TYPE VARCHAR(64),
  	REPEAT_PEROID INT,
  	PRIORITY INT,
  	REMIND_TIME VARCHAR(50),
  	DESCRIPTION VARCHAR(200),
  	CREATE_TIME DATETIME,
  	STATUS VARCHAR(50),
  	USER_ID VARCHAR(64),
  	REF VARCHAR(200),
          CONSTRAINT PK_PIM_REMIND PRIMARY KEY(ID)
  );
  
  COMMENT ON TABLE PIM_REMIND IS '提醒';
  COMMENT ON COLUMN PIM_REMIND.ID IS '主键';
  COMMENT ON COLUMN PIM_REMIND.TYPE IS '重复类型，一次，每天，每周';
  COMMENT ON COLUMN PIM_REMIND.REPEAT_TYPE IS '是否重复提醒';
  COMMENT ON COLUMN PIM_REMIND.REPEAT_PEROID IS '提醒间隔';
  COMMENT ON COLUMN PIM_REMIND.PRIORITY IS '优先级';
  COMMENT ON COLUMN PIM_REMIND.REMIND_TIME IS '提醒时间';
  COMMENT ON COLUMN PIM_REMIND.DESCRIPTION IS '备注';
  COMMENT ON COLUMN PIM_REMIND.CREATE_TIME IS '创建时间';
  COMMENT ON COLUMN PIM_REMIND.STATUS IS '状态';
  COMMENT ON COLUMN PIM_REMIND.USER_ID IS '用户';
  COMMENT ON COLUMN PIM_REMIND.REF IS '外部引用';
  
  