ap_approval_form_flow.sql 617 B

12345678910
  1. CREATE TABLE ap_approval_form_flow(
  2. AAFF_ID varchar(20) NOT NULL COMMENT '编号',
  3. AAFF_FORM_ID varchar(20) NOT NULL COMMENT 'ap_approval_form.id',
  4. AAFF_APPROVAL_USER varchar(20) NOT NULL COMMENT '审批人',
  5. AAFF_APPROVAL_TIME varchar(14) NOT NULL COMMENT '审批时间',
  6. AAFF_ROLE_ID varchar(20) NOT NULL COMMENT '角色id',
  7. AAFF_REMARK varchar(20) NOT NULL COMMENT '审批意见',
  8. AAFF_STATE varchar(1) NOT NULL COMMENT '是否通过 0:不通过 1:通过',
  9. PRIMARY KEY (AAFF_ID)
  10. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='审批流水表';