|
发表于 2021-12-30 09:53:17
|
显示全部楼层
--待办任务(JE_CORE_TASK) 表结构的创建语句
CREATE TABLE JE_CORE_TASK (
TASK_COMMENT text,
TASK_CONTENT text,
TASK_CURRENTTASK VARCHAR(400),
TASK_DOFN VARCHAR(255),
TASK_DOROUNDUSERIDS text,
TASK_DOUSER text,
TASK_DOUSERID text,
TASK_END VARCHAR(4),
TASK_FLOWINFO text,
TASK_FLOWUSER VARCHAR(100),
TASK_FLOWUSERID VARCHAR(1000),
TASK_FL_CODE VARCHAR(30),
TASK_FL_NAME VARCHAR(50),
TASK_FUNCCODE VARCHAR(255),
TASK_NAME VARCHAR(255),
TASK_PKVALUE VARCHAR(255),
TASK_PROCESSNAME VARCHAR(255),
TASK_READUSER text,
TASK_ROUNDINFO text,
TASK_ROUNDUSERIDS text,
TASK_SHOWFN VARCHAR(255),
TASK_STAR VARCHAR(4),
TASK_STARTUSER VARCHAR(100),
TASK_STARTUSERID VARCHAR(50),
TASK_TABLECODE VARCHAR(255),
TASK_TASKTIME VARCHAR(1000),
TASK_TASKTYPE_CODE VARCHAR(50),
TASK_TASKTYPE_NAME VARCHAR(50),
TASK_USERIDS text,
TASK_USERNAMES text,
TASK_VIEWTABLECODE VARCHAR(255),
JE_CORE_TASK_ID VARCHAR(50) not null,
SY_AUDFLAG VARCHAR(20),
SY_CREATEORG VARCHAR(50),
SY_CREATEORGID VARCHAR(50),
SY_CREATEORGNAME VARCHAR(50),
SY_CREATETIME VARCHAR(20),
SY_CREATEUSER VARCHAR(50),
SY_CREATEUSERID VARCHAR(50),
SY_CREATEUSERNAME VARCHAR(50),
SY_JTGSID VARCHAR(50),
SY_JTGSMC VARCHAR(50),
SY_ORDERINDEX int(20),
SY_PDID VARCHAR(255),
SY_PIID VARCHAR(255),
SY_STATUS VARCHAR(4)
);
alter table JE_CORE_TASK comment '待办任务';
alter table JE_CORE_TASK modify column TASK_COMMENT text comment '意见';
alter table JE_CORE_TASK modify column TASK_CONTENT text comment '内容';
alter table JE_CORE_TASK modify column TASK_CURRENTTASK VARCHAR(400) comment '当前任务';
alter table JE_CORE_TASK modify column TASK_DOFN VARCHAR(255) comment '办理回调函数';
alter table JE_CORE_TASK modify column TASK_DOROUNDUSERIDS text comment '审阅人员';
alter table JE_CORE_TASK modify column TASK_DOUSER text comment '已办人员';
alter table JE_CORE_TASK modify column TASK_DOUSERID text comment '已办人员ID';
alter table JE_CORE_TASK modify column TASK_END VARCHAR(4) comment '结束';
alter table JE_CORE_TASK modify column TASK_FLOWINFO text comment '指派信息';
alter table JE_CORE_TASK modify column TASK_FLOWUSER VARCHAR(100) comment '指派人';
alter table JE_CORE_TASK modify column TASK_FLOWUSERID VARCHAR(1000) comment '指派人ID';
alter table JE_CORE_TASK modify column TASK_FL_CODE VARCHAR(30) comment '待办分类CODE';
alter table JE_CORE_TASK modify column TASK_FL_NAME VARCHAR(50) comment '待办分类';
alter table JE_CORE_TASK modify column TASK_FUNCCODE VARCHAR(255) comment '功能编码';
alter table JE_CORE_TASK modify column TASK_NAME VARCHAR(255) comment '名称';
alter table JE_CORE_TASK modify column TASK_PKVALUE VARCHAR(255) comment '业务主键';
alter table JE_CORE_TASK modify column TASK_PROCESSNAME VARCHAR(255) comment '流程名称';
alter table JE_CORE_TASK modify column TASK_READUSER text comment '已读人员';
alter table JE_CORE_TASK modify column TASK_ROUNDINFO text comment '传阅信息';
alter table JE_CORE_TASK modify column TASK_ROUNDUSERIDS text comment '待阅人员';
alter table JE_CORE_TASK modify column TASK_SHOWFN VARCHAR(255) comment '回调函数';
alter table JE_CORE_TASK modify column TASK_STAR VARCHAR(4) comment '标记';
alter table JE_CORE_TASK modify column TASK_STARTUSER VARCHAR(100) comment '启动人';
alter table JE_CORE_TASK modify column TASK_STARTUSERID VARCHAR(50) comment '启动人ID';
alter table JE_CORE_TASK modify column TASK_TABLECODE VARCHAR(255) comment '表编码';
alter table JE_CORE_TASK modify column TASK_TASKTIME VARCHAR(1000) comment '接受时间';
alter table JE_CORE_TASK modify column TASK_TASKTYPE_CODE VARCHAR(50) comment '待办类型';
alter table JE_CORE_TASK modify column TASK_TASKTYPE_NAME VARCHAR(50) comment '待办类型_NAME';
alter table JE_CORE_TASK modify column TASK_USERIDS text comment '待办人员ID';
alter table JE_CORE_TASK modify column TASK_USERNAMES text comment '待办人员';
alter table JE_CORE_TASK modify column TASK_VIEWTABLECODE VARCHAR(255) comment '视图表名';
alter table JE_CORE_TASK modify column JE_CORE_TASK_ID VARCHAR(50) comment '主键ID';
alter table JE_CORE_TASK modify column SY_AUDFLAG VARCHAR(20) comment '审核标记';
alter table JE_CORE_TASK modify column SY_CREATEORG VARCHAR(50) comment '登记部门编码';
alter table JE_CORE_TASK modify column SY_CREATEORGID VARCHAR(50) comment '登记部门主键';
alter table JE_CORE_TASK modify column SY_CREATEORGNAME VARCHAR(50) comment '登记部门';
alter table JE_CORE_TASK modify column SY_CREATETIME VARCHAR(20) comment '登记时间';
alter table JE_CORE_TASK modify column SY_CREATEUSER VARCHAR(50) comment '登记人编码';
alter table JE_CORE_TASK modify column SY_CREATEUSERID VARCHAR(50) comment '登记人主键';
alter table JE_CORE_TASK modify column SY_CREATEUSERNAME VARCHAR(50) comment '登记人';
alter table JE_CORE_TASK modify column SY_JTGSID VARCHAR(50) comment '集团公司ID';
alter table JE_CORE_TASK modify column SY_JTGSMC VARCHAR(50) comment '集团公司名称';
alter table JE_CORE_TASK modify column SY_ORDERINDEX int comment '排序字段';
alter table JE_CORE_TASK modify column SY_PDID VARCHAR(255) comment '流程定义ID';
alter table JE_CORE_TASK modify column SY_PIID VARCHAR(255) comment '流程实例ID';
alter table JE_CORE_TASK modify column SY_STATUS VARCHAR(4) comment '数据状态';
alter table JE_CORE_TASK
add primary key (JE_CORE_TASK_ID);
ALTER TABLE JE_CORE_TASK ADD INDEX JE_1603721672730_ORDER (SY_ORDERINDEX);
|
|