create sequence ACT_EVT_LOG_SEQ ; create sequence ACT_HI_TASK_EVT_LOG_SEQ ; create sequence GEN_BASE_CLASS_SEQ ; create sequence GEN_DATASOURCE_SEQ ; create sequence GEN_FIELD_TYPE_SEQ ; create sequence GEN_PROJECT_MODIFY_SEQ ; create sequence GEN_TABLE_FIELD_SEQ ; create sequence GEN_TABLE_SEQ ; create sequence GEN_TEST_STUDENT_SEQ ; create sequence XXL_JOB_GROUP_SEQ ; create sequence XXL_JOB_INFO_SEQ ; create sequence XXL_JOB_LOG_REPORT_SEQ ; create sequence XXL_JOB_LOG_SEQ ; create sequence XXL_JOB_LOGGLUE_SEQ ; create sequence XXL_JOB_REGISTRY_SEQ ; create sequence XXL_JOB_USER_SEQ ; create table XXL_JOB_USER ( ID NUMBER(11) not null constraint SYS_C009499 primary key constraint SYS_C0014870 check ("ID" IS NOT NULL) constraint SYS_C00152312 check ("ID" IS NOT NULL) constraint SYS_C009495 check ("ID" IS NOT NULL), USERNAME VARCHAR2(50) not null constraint SYS_C0014871 check ("USERNAME" IS NOT NULL) constraint SYS_C00152313 check ("USERNAME" IS NOT NULL) constraint SYS_C009496 check ("USERNAME" IS NOT NULL), PASSWORD VARCHAR2(50) not null constraint SYS_C0014872 check ("PASSWORD" IS NOT NULL) constraint SYS_C00152314 check ("PASSWORD" IS NOT NULL) constraint SYS_C009497 check ("PASSWORD" IS NOT NULL), ROLE NUMBER(4) not null constraint SYS_C0014873 check ("ROLE" IS NOT NULL) constraint SYS_C00152315 check ("ROLE" IS NOT NULL) constraint SYS_C009498 check ("ROLE" IS NOT NULL), PERMISSION VARCHAR2(255) ) ; comment on table XXL_JOB_USER is '系统用户表' ; comment on column XXL_JOB_USER.USERNAME is '账号' ; comment on column XXL_JOB_USER.PASSWORD is '密码' ; comment on column XXL_JOB_USER.ROLE is '角色：0-普通用户、1-管理员' ; comment on column XXL_JOB_USER.PERMISSION is '权限：执行器ID列表，多个逗号分割' ; create table XXL_JOB_REGISTRY ( ID NUMBER(11) not null constraint SYS_C009494 primary key constraint SYS_C0014866 check ("ID" IS NOT NULL) constraint SYS_C00152302 check ("ID" IS NOT NULL) constraint SYS_C009490 check ("ID" IS NOT NULL), REGISTRY_GROUP VARCHAR2(50) not null constraint SYS_C0014867 check ("REGISTRY_GROUP" IS NOT NULL) constraint SYS_C00152303 check ("REGISTRY_GROUP" IS NOT NULL) constraint SYS_C009491 check ("REGISTRY_GROUP" IS NOT NULL), REGISTRY_KEY VARCHAR2(255) not null constraint SYS_C0014868 check ("REGISTRY_KEY" IS NOT NULL) constraint SYS_C00152304 check ("REGISTRY_KEY" IS NOT NULL) constraint SYS_C009492 check ("REGISTRY_KEY" IS NOT NULL), REGISTRY_VALUE VARCHAR2(255) not null constraint SYS_C0014869 check ("REGISTRY_VALUE" IS NOT NULL) constraint SYS_C00152305 check ("REGISTRY_VALUE" IS NOT NULL) constraint SYS_C009493 check ("REGISTRY_VALUE" IS NOT NULL), UPDATE_TIME TIMESTAMP(6) ) ; comment on table XXL_JOB_REGISTRY is '执行器注册表' ; create table XXL_JOB_LOGGLUE ( ID NUMBER(11) not null constraint SYS_C009484 primary key constraint SYS_C0014863 check ("ID" IS NOT NULL) constraint SYS_C00152298 check ("ID" IS NOT NULL) constraint SYS_C009481 check ("ID" IS NOT NULL), JOB_ID NUMBER(11) not null constraint SYS_C0014864 check ("JOB_ID" IS NOT NULL) constraint SYS_C00152299 check ("JOB_ID" IS NOT NULL) constraint SYS_C009482 check ("JOB_ID" IS NOT NULL), GLUE_TYPE VARCHAR2(50), GLUE_SOURCE CLOB, GLUE_REMARK VARCHAR2(128) not null constraint SYS_C0014865 check ("GLUE_REMARK" IS NOT NULL) constraint SYS_C00152300 check ("GLUE_REMARK" IS NOT NULL) constraint SYS_C009483 check ("GLUE_REMARK" IS NOT NULL), ADD_TIME TIMESTAMP(6), UPDATE_TIME TIMESTAMP(6) ) ; comment on table XXL_JOB_LOGGLUE is '任务GLUE日志' ; comment on column XXL_JOB_LOGGLUE.JOB_ID is '任务，主键ID' ; comment on column XXL_JOB_LOGGLUE.GLUE_TYPE is 'GLUE类型' ; comment on column XXL_JOB_LOGGLUE.GLUE_SOURCE is 'GLUE源代码' ; comment on column XXL_JOB_LOGGLUE.GLUE_REMARK is 'GLUE备注' ; create table XXL_JOB_LOG_REPORT ( ID NUMBER(11) not null constraint SYS_C009489 primary key constraint SYS_C0014859 check ("ID" IS NOT NULL) constraint SYS_C00152293 check ("ID" IS NOT NULL) constraint SYS_C009485 check ("ID" IS NOT NULL), TRIGGER_DAY TIMESTAMP(6), RUNNING_COUNT NUMBER(11) default '0' not null constraint SYS_C0014860 check ("RUNNING_COUNT" IS NOT NULL) constraint SYS_C00152294 check ("RUNNING_COUNT" IS NOT NULL) constraint SYS_C009486 check ("RUNNING_COUNT" IS NOT NULL), SUC_COUNT NUMBER(11) default '0' not null constraint SYS_C0014861 check ("SUC_COUNT" IS NOT NULL) constraint SYS_C00152295 check ("SUC_COUNT" IS NOT NULL) constraint SYS_C009487 check ("SUC_COUNT" IS NOT NULL), FAIL_COUNT NUMBER(11) default '0' not null constraint SYS_C0014862 check ("FAIL_COUNT" IS NOT NULL) constraint SYS_C00152296 check ("FAIL_COUNT" IS NOT NULL) constraint SYS_C009488 check ("FAIL_COUNT" IS NOT NULL), UPDATE_TIME TIMESTAMP(6) ) ; comment on table XXL_JOB_LOG_REPORT is '调度日志报表' ; comment on column XXL_JOB_LOG_REPORT.TRIGGER_DAY is '调度-时间' ; comment on column XXL_JOB_LOG_REPORT.RUNNING_COUNT is '运行中-日志数量' ; comment on column XXL_JOB_LOG_REPORT.SUC_COUNT is '执行成功-日志数量' ; comment on column XXL_JOB_LOG_REPORT.FAIL_COUNT is '执行失败-日志数量' ; create table XXL_JOB_LOG ( ID NUMBER(20) not null constraint SYS_C0010318 primary key constraint SYS_C0010304 check ("ID" IS NOT NULL) constraint SYS_C0014852 check ("ID" IS NOT NULL) constraint SYS_C00152285 check ("ID" IS NOT NULL), JOB_GROUP NUMBER(11) not null constraint SYS_C0010305 check ("JOB_GROUP" IS NOT NULL) constraint SYS_C0014853 check ("JOB_GROUP" IS NOT NULL) constraint SYS_C00152286 check ("JOB_GROUP" IS NOT NULL), JOB_ID NUMBER(11) not null constraint SYS_C0010306 check ("JOB_ID" IS NOT NULL) constraint SYS_C0014854 check ("JOB_ID" IS NOT NULL) constraint SYS_C00152287 check ("JOB_ID" IS NOT NULL), EXECUTOR_ADDRESS VARCHAR2(255), EXECUTOR_HANDLER VARCHAR2(255), EXECUTOR_PARAM VARCHAR2(512), EXECUTOR_SHARDING_PARAM VARCHAR2(20), EXECUTOR_FAIL_RETRY_COUNT NUMBER(11) default '0' not null constraint SYS_C0010307 check ("EXECUTOR_FAIL_RETRY_COUNT" IS NOT NULL) constraint SYS_C0014855 check ("EXECUTOR_FAIL_RETRY_COUNT" IS NOT NULL) constraint SYS_C00152288 check ("EXECUTOR_FAIL_RETRY_COUNT" IS NOT NULL), TRIGGER_TIME TIMESTAMP(6), TRIGGER_CODE NUMBER(11) not null constraint SYS_C0010308 check ("TRIGGER_CODE" IS NOT NULL) constraint SYS_C0014856 check ("TRIGGER_CODE" IS NOT NULL) constraint SYS_C00152289 check ("TRIGGER_CODE" IS NOT NULL), TRIGGER_MSG CLOB, HANDLE_TIME TIMESTAMP(6), HANDLE_CODE NUMBER(11) not null constraint SYS_C0010309 check ("HANDLE_CODE" IS NOT NULL) constraint SYS_C0014857 check ("HANDLE_CODE" IS NOT NULL) constraint SYS_C00152290 check ("HANDLE_CODE" IS NOT NULL), HANDLE_MSG CLOB, ALARM_STATUS NUMBER(4) default '0' not null constraint SYS_C0010310 check ("ALARM_STATUS" IS NOT NULL) constraint SYS_C0014858 check ("ALARM_STATUS" IS NOT NULL) constraint SYS_C00152291 check ("ALARM_STATUS" IS NOT NULL) ) ; comment on table XXL_JOB_LOG is '调度日志表' ; comment on column XXL_JOB_LOG.JOB_GROUP is '执行器主键ID' ; comment on column XXL_JOB_LOG.JOB_ID is '任务，主键ID' ; comment on column XXL_JOB_LOG.EXECUTOR_ADDRESS is '执行器地址，本次执行的地址' ; comment on column XXL_JOB_LOG.EXECUTOR_HANDLER is '执行器任务handler' ; comment on column XXL_JOB_LOG.EXECUTOR_PARAM is '执行器任务参数' ; comment on column XXL_JOB_LOG.EXECUTOR_SHARDING_PARAM is '执行器任务分片参数，格式如 1;2' ; comment on column XXL_JOB_LOG.EXECUTOR_FAIL_RETRY_COUNT is '失败重试次数' ; comment on column XXL_JOB_LOG.TRIGGER_TIME is '调度-时间' ; comment on column XXL_JOB_LOG.TRIGGER_CODE is '调度-结果' ; comment on column XXL_JOB_LOG.TRIGGER_MSG is '调度-日志' ; comment on column XXL_JOB_LOG.HANDLE_TIME is '执行-时间' ; comment on column XXL_JOB_LOG.HANDLE_CODE is '执行-状态' ; comment on column XXL_JOB_LOG.HANDLE_MSG is '执行-日志' ; comment on column XXL_JOB_LOG.ALARM_STATUS is '告警状态：0-默认、1-无需告警、2-告警成功、3-告警失败' ; create table XXL_JOB_LOCK ( LOCK_NAME VARCHAR2(50) not null constraint SYS_C009472 primary key constraint SYS_C0014851 check ("LOCK_NAME" IS NOT NULL) constraint SYS_C00152317 check ("LOCK_NAME" IS NOT NULL) constraint SYS_C009471 check ("LOCK_NAME" IS NOT NULL) ) ; comment on table XXL_JOB_LOCK is '任务调度锁表' ; comment on column XXL_JOB_LOCK.LOCK_NAME is '锁名称' ; create table XXL_JOB_INFO ( ID NUMBER(11) not null constraint SYS_C009470 primary key constraint SYS_C0014839 check ("ID" IS NOT NULL) constraint SYS_C00152273 check ("ID" IS NOT NULL) constraint SYS_C009458 check ("ID" IS NOT NULL), JOB_GROUP NUMBER(11) not null constraint SYS_C0014840 check ("JOB_GROUP" IS NOT NULL) constraint SYS_C00152274 check ("JOB_GROUP" IS NOT NULL) constraint SYS_C009459 check ("JOB_GROUP" IS NOT NULL), JOB_DESC VARCHAR2(255) not null constraint SYS_C0014841 check ("JOB_DESC" IS NOT NULL) constraint SYS_C00152275 check ("JOB_DESC" IS NOT NULL) constraint SYS_C009460 check ("JOB_DESC" IS NOT NULL), ADD_TIME TIMESTAMP(6), UPDATE_TIME TIMESTAMP(6), AUTHOR VARCHAR2(64), ALARM_EMAIL VARCHAR2(255), SCHEDULE_TYPE VARCHAR2(50) default 'NONE' not null constraint SYS_C0014842 check ("SCHEDULE_TYPE" IS NOT NULL) constraint SYS_C00152276 check ("SCHEDULE_TYPE" IS NOT NULL) constraint SYS_C009461 check ("SCHEDULE_TYPE" IS NOT NULL), SCHEDULE_CONF VARCHAR2(128), MISFIRE_STRATEGY VARCHAR2(50) default 'DO_NOTHING' not null constraint SYS_C0014843 check ("MISFIRE_STRATEGY" IS NOT NULL) constraint SYS_C00152277 check ("MISFIRE_STRATEGY" IS NOT NULL) constraint SYS_C009462 check ("MISFIRE_STRATEGY" IS NOT NULL), EXECUTOR_ROUTE_STRATEGY VARCHAR2(50), EXECUTOR_HANDLER VARCHAR2(255), EXECUTOR_PARAM VARCHAR2(512), EXECUTOR_BLOCK_STRATEGY VARCHAR2(50), EXECUTOR_TIMEOUT NUMBER(11) default '0' not null constraint SYS_C0014844 check ("EXECUTOR_TIMEOUT" IS NOT NULL) constraint SYS_C00152278 check ("EXECUTOR_TIMEOUT" IS NOT NULL) constraint SYS_C009463 check ("EXECUTOR_TIMEOUT" IS NOT NULL), EXECUTOR_FAIL_RETRY_COUNT NUMBER(11) default '0' not null constraint SYS_C0014845 check ("EXECUTOR_FAIL_RETRY_COUNT" IS NOT NULL) constraint SYS_C00152279 check ("EXECUTOR_FAIL_RETRY_COUNT" IS NOT NULL) constraint SYS_C009464 check ("EXECUTOR_FAIL_RETRY_COUNT" IS NOT NULL), GLUE_TYPE VARCHAR2(50) not null constraint SYS_C0014846 check ("GLUE_TYPE" IS NOT NULL) constraint SYS_C00152280 check ("GLUE_TYPE" IS NOT NULL) constraint SYS_C009465 check ("GLUE_TYPE" IS NOT NULL), GLUE_SOURCE CLOB, GLUE_REMARK VARCHAR2(128), GLUE_UPDATETIME TIMESTAMP(6), CHILD_JOBID VARCHAR2(255), TRIGGER_STATUS NUMBER(4) default '0' not null constraint SYS_C0014847 check ("TRIGGER_STATUS" IS NOT NULL) constraint SYS_C00152281 check ("TRIGGER_STATUS" IS NOT NULL) constraint SYS_C009466 check ("TRIGGER_STATUS" IS NOT NULL), TRIGGER_LAST_TIME NUMBER(13) default '0' not null constraint SYS_C0014848 check ("TRIGGER_LAST_TIME" IS NOT NULL) constraint SYS_C00152282 check ("TRIGGER_LAST_TIME" IS NOT NULL) constraint SYS_C009467 check ("TRIGGER_LAST_TIME" IS NOT NULL), TRIGGER_NEXT_TIME NUMBER(13) default '0' not null constraint SYS_C0014849 check ("TRIGGER_NEXT_TIME" IS NOT NULL) constraint SYS_C00152283 check ("TRIGGER_NEXT_TIME" IS NOT NULL) constraint SYS_C009468 check ("TRIGGER_NEXT_TIME" IS NOT NULL), JOB_CRON VARCHAR2(128) not null constraint SYS_C0014850 check ("JOB_CRON" IS NOT NULL) constraint SYS_C00152321 check ("JOB_CRON" IS NOT NULL) constraint SYS_C009469 check ("JOB_CRON" IS NOT NULL) ) ; comment on table XXL_JOB_INFO is '调度扩展信息表' ; comment on column XXL_JOB_INFO.JOB_GROUP is '执行器主键ID' ; comment on column XXL_JOB_INFO.AUTHOR is '作者' ; comment on column XXL_JOB_INFO.ALARM_EMAIL is '报警邮件' ; comment on column XXL_JOB_INFO.SCHEDULE_TYPE is '调度类型' ; comment on column XXL_JOB_INFO.SCHEDULE_CONF is '调度配置，值含义取决于调度类型' ; comment on column XXL_JOB_INFO.MISFIRE_STRATEGY is '调度过期策略' ; comment on column XXL_JOB_INFO.EXECUTOR_ROUTE_STRATEGY is '执行器路由策略' ; comment on column XXL_JOB_INFO.EXECUTOR_HANDLER is '执行器任务handler' ; comment on column XXL_JOB_INFO.EXECUTOR_PARAM is '执行器任务参数' ; comment on column XXL_JOB_INFO.EXECUTOR_BLOCK_STRATEGY is '阻塞处理策略' ; comment on column XXL_JOB_INFO.EXECUTOR_TIMEOUT is '任务执行超时时间，单位秒' ; comment on column XXL_JOB_INFO.EXECUTOR_FAIL_RETRY_COUNT is '失败重试次数' ; comment on column XXL_JOB_INFO.GLUE_TYPE is 'GLUE类型' ; comment on column XXL_JOB_INFO.GLUE_SOURCE is 'GLUE源代码' ; comment on column XXL_JOB_INFO.GLUE_REMARK is 'GLUE备注' ; comment on column XXL_JOB_INFO.GLUE_UPDATETIME is 'GLUE更新时间' ; comment on column XXL_JOB_INFO.CHILD_JOBID is '子任务ID，多个逗号分隔' ; comment on column XXL_JOB_INFO.TRIGGER_STATUS is '调度状态：0-停止，1-运行' ; comment on column XXL_JOB_INFO.TRIGGER_LAST_TIME is '上次调度时间' ; comment on column XXL_JOB_INFO.TRIGGER_NEXT_TIME is '下次调度时间' ; comment on column XXL_JOB_INFO.JOB_CRON is '任务执行CRON' ; create table XXL_JOB_GROUP ( ID NUMBER(11) not null constraint SYS_C009457 primary key constraint SYS_C0014835 check ("ID" IS NOT NULL) constraint SYS_C00152322 check ("ID" IS NOT NULL) constraint SYS_C009453 check ("ID" IS NOT NULL), APP_NAME VARCHAR2(64) not null constraint SYS_C0014836 check ("APP_NAME" IS NOT NULL) constraint SYS_C00152323 check ("APP_NAME" IS NOT NULL) constraint SYS_C009454 check ("APP_NAME" IS NOT NULL), TITLE VARCHAR2(30) not null constraint SYS_C0014837 check ("TITLE" IS NOT NULL) constraint SYS_C00152324 check ("TITLE" IS NOT NULL) constraint SYS_C009455 check ("TITLE" IS NOT NULL), ADDRESS_TYPE NUMBER(4) default '0' not null constraint SYS_C0014838 check ("ADDRESS_TYPE" IS NOT NULL) constraint SYS_C00152325 check ("ADDRESS_TYPE" IS NOT NULL) constraint SYS_C009456 check ("ADDRESS_TYPE" IS NOT NULL), ADDRESS_LIST VARCHAR2(100), UPDATE_TIME TIMESTAMP(6), SORT NUMBER(4) ) ; comment on table XXL_JOB_GROUP is '执行器信息表' ; comment on column XXL_JOB_GROUP.APP_NAME is '执行器AppName' ; comment on column XXL_JOB_GROUP.TITLE is '执行器名称' ; comment on column XXL_JOB_GROUP.ADDRESS_TYPE is '执行器地址类型：0=自动注册、1=手动录入' ; comment on column XXL_JOB_GROUP.ADDRESS_LIST is '执行器地址列表，多地址逗号分隔' ; create table TB_SYNC_USER_HISTORY ( ID VARCHAR2(50) not null constraint SYS_C009382 unique constraint SYS_C0014819 check ("ID" IS NOT NULL) constraint SYS_C00166531 check ("ID" IS NOT NULL) constraint SYS_C009381 check ("ID" IS NOT NULL), APP_ID VARCHAR2(50), APP_CODE VARCHAR2(100), APP_NAME VARCHAR2(100), SYNC_TIME TIMESTAMP(6), REMARK VARCHAR2(100), APP_ADMIN VARCHAR2(100) ) ; comment on table TB_SYNC_USER_HISTORY is '应用同步用户记录表' ; comment on column TB_SYNC_USER_HISTORY.APP_ID is '应用id' ; comment on column TB_SYNC_USER_HISTORY.APP_CODE is '应用英文名' ; comment on column TB_SYNC_USER_HISTORY.APP_NAME is '应用中文名' ; comment on column TB_SYNC_USER_HISTORY.SYNC_TIME is '同步时间' ; comment on column TB_SYNC_USER_HISTORY.REMARK is '备注' ; comment on column TB_SYNC_USER_HISTORY.APP_ADMIN is '应用管理员' ; create table TB_DATASOURCE_CONF ( ID NUMBER(20) not null constraint SYS_C009325 primary key constraint SYS_C0014778 check ("ID" IS NOT NULL) constraint SYS_C00155912 check ("ID" IS NOT NULL) constraint SYS_C0020267 check ("ID" IS NOT NULL) constraint SYS_C009323 check ("ID" IS NOT NULL), SERVICE_TYPE VARCHAR2(30), SERVICE_ID VARCHAR2(64), DEFAULT_SERVICE_ID VARCHAR2(64), CONFIG_NAME VARCHAR2(50), CONFIG_DESC VARCHAR2(255), SOURCE_TYPE NUMBER(1), SORT_NO NUMBER(11), APP_ENV VARCHAR2(500), REC_CREATOR VARCHAR2(50), REC_CREATE_TIME DATE, REC_REVISOR VARCHAR2(50), REC_REVISE_TIME DATE, ARCHIVE_FLAG NUMBER(11), CREATE_USER VARCHAR2(50), CREATE_DEPT VARCHAR2(50), CREATE_TIME DATE, UPDATE_USER VARCHAR2(50), UPDATE_TIME DATE, STATUS NUMBER(1), IS_DELETED NUMBER(1) not null constraint SYS_C0014779 check ("IS_DELETED" IS NOT NULL) constraint SYS_C00155913 check ("IS_DELETED" IS NOT NULL) constraint SYS_C0020270 check ("IS_DELETED" IS NOT NULL) constraint SYS_C009324 check ("IS_DELETED" IS NOT NULL) ) ; comment on column TB_DATASOURCE_CONF.ID is '配置标识' ; comment on column TB_DATASOURCE_CONF.SERVICE_TYPE is '服务类型' ; comment on column TB_DATASOURCE_CONF.SERVICE_ID is '服务标识' ; comment on column TB_DATASOURCE_CONF.DEFAULT_SERVICE_ID is '默认服务标识' ; comment on column TB_DATASOURCE_CONF.CONFIG_NAME is '配置名称' ; comment on column TB_DATASOURCE_CONF.CONFIG_DESC is '配置描述' ; comment on column TB_DATASOURCE_CONF.SOURCE_TYPE is '来源类型1：信息资源2：数典' ; comment on column TB_DATASOURCE_CONF.SORT_NO is '排序字段' ; comment on column TB_DATASOURCE_CONF.APP_ENV is '应用环境' ; comment on column TB_DATASOURCE_CONF.REC_CREATOR is '记录创建人' ; comment on column TB_DATASOURCE_CONF.REC_CREATE_TIME is '记录创建时间' ; comment on column TB_DATASOURCE_CONF.REC_REVISOR is '记录修改人' ; comment on column TB_DATASOURCE_CONF.REC_REVISE_TIME is '记录修改时间' ; comment on column TB_DATASOURCE_CONF.ARCHIVE_FLAG is '归档标识' ; create table TB_CONFIG_ADMIN ( ID VARCHAR2(50), CONFIG_NAME VARCHAR2(100), CONFIG_TYPE NUMBER, CONFIG_DESC VARCHAR2(100), SERVICE_TYPE VARCHAR2(100), CONFIG_CONTENT VARCHAR2(100), STEP_NAME VARCHAR2(100), CONFIG_STATE NUMBER, CREATE_NAME VARCHAR2(50) not null constraint SYS_C0014777 check ("CREATE_NAME" IS NOT NULL) constraint SYS_C00157491 check ("CREATE_NAME" IS NOT NULL) constraint SYS_C009322 check ("CREATE_NAME" IS NOT NULL), CREATE_TIME DATE, UPDATE_NAME VARCHAR2(50), UPDATE_TIME DATE ) ; comment on table TB_CONFIG_ADMIN is '配置管理表' ; comment on column TB_CONFIG_ADMIN.ID is 'id' ; comment on column TB_CONFIG_ADMIN.CONFIG_NAME is '配置名称' ; comment on column TB_CONFIG_ADMIN.CONFIG_TYPE is '配置类型:普通类型0,开关类型1' ; comment on column TB_CONFIG_ADMIN.CONFIG_DESC is '配置描述' ; comment on column TB_CONFIG_ADMIN.SERVICE_TYPE is '服务类型' ; comment on column TB_CONFIG_ADMIN.CONFIG_CONTENT is '配置内容' ; comment on column TB_CONFIG_ADMIN.STEP_NAME is '步骤名称' ; comment on column TB_CONFIG_ADMIN.CONFIG_STATE is '配置状态:0正常1删除' ; comment on column TB_CONFIG_ADMIN.CREATE_NAME is '记录创建人' ; comment on column TB_CONFIG_ADMIN.CREATE_TIME is '记录创建时间' ; comment on column TB_CONFIG_ADMIN.UPDATE_NAME is '记录修改人' ; comment on column TB_CONFIG_ADMIN.UPDATE_TIME is '记录修改时间' ; create table TB_AUTHENTICATION_RECORD ( ID NUMBER(20) not null constraint SYS_C009321 primary key constraint SYS_C0014771 check ("ID" IS NOT NULL) constraint SYS_C00149962 check ("ID" IS NOT NULL) constraint SYS_C009315 check ("ID" IS NOT NULL), APPLY_APP_USER VARCHAR2(20) not null constraint SYS_C0014772 check ("APPLY_APP_USER" IS NOT NULL) constraint SYS_C00149966 check ("APPLY_APP_USER" IS NOT NULL) constraint SYS_C009316 check ("APPLY_APP_USER" IS NOT NULL), APPLY_APP_ID NUMBER(20) not null constraint SYS_C0014773 check ("APPLY_APP_ID" IS NOT NULL) constraint SYS_C00149967 check ("APPLY_APP_ID" IS NOT NULL) constraint SYS_C009317 check ("APPLY_APP_ID" IS NOT NULL), APPLY_TIME DATE not null constraint SYS_C0014774 check ("APPLY_TIME" IS NOT NULL) constraint SYS_C00149968 check ("APPLY_TIME" IS NOT NULL) constraint SYS_C009318 check ("APPLY_TIME" IS NOT NULL), SERVICE_ID NUMBER(20) not null constraint SYS_C0014775 check ("SERVICE_ID" IS NOT NULL) constraint SYS_C00149969 check ("SERVICE_ID" IS NOT NULL) constraint SYS_C009319 check ("SERVICE_ID" IS NOT NULL), AUDIT_USER VARCHAR2(20), AUDIT_TIME DATE, AUDIT_OPINION NVARCHAR2(500), STATUS NUMBER(1) default 0 not null constraint SYS_C0014776 check ("STATUS" IS NOT NULL) constraint SYS_C00149970 check ("STATUS" IS NOT NULL) constraint SYS_C009320 check ("STATUS" IS NOT NULL), CREATE_TIME DATE, UPDATE_TIME DATE, IS_DELETED NUMBER(1) default 0, APPLY_REASON VARCHAR2(255), FOLDER_ID NUMBER, IS_PASS NUMBER(1) ) ; comment on table TB_AUTHENTICATION_RECORD is '鉴权记录表' ; comment on column TB_AUTHENTICATION_RECORD.ID is '主键' ; comment on column TB_AUTHENTICATION_RECORD.APPLY_APP_USER is '申请人' ; comment on column TB_AUTHENTICATION_RECORD.APPLY_APP_ID is '申请方应用id' ; comment on column TB_AUTHENTICATION_RECORD.APPLY_TIME is '申请时间' ; comment on column TB_AUTHENTICATION_RECORD.SERVICE_ID is '服务id' ; comment on column TB_AUTHENTICATION_RECORD.AUDIT_USER is '审批人' ; comment on column TB_AUTHENTICATION_RECORD.AUDIT_TIME is '审批时间' ; comment on column TB_AUTHENTICATION_RECORD.AUDIT_OPINION is '审批意见' ; comment on column TB_AUTHENTICATION_RECORD.STATUS is '是否审批(0 未审批,1 已审批)' ; comment on column TB_AUTHENTICATION_RECORD.CREATE_TIME is '创建时间' ; comment on column TB_AUTHENTICATION_RECORD.UPDATE_TIME is '修改时间' ; comment on column TB_AUTHENTICATION_RECORD.IS_DELETED is '逻辑删除：0-未删除；1-已删除' ; comment on column TB_AUTHENTICATION_RECORD.APPLY_REASON is '申请原因' ; comment on column TB_AUTHENTICATION_RECORD.FOLDER_ID is '文件夹id' ; comment on column TB_AUTHENTICATION_RECORD.IS_PASS is '是否通过(0 通过 1 拒绝 )' ; create table T_WORKFLOW_TIMEOUT_NOTICE ( ID NUMBER(20) not null constraint T_WORKFLOW_TIMEOUT_NOTICE_PK primary key constraint SYS_C0013559 check ("ID" IS NOT NULL) constraint SYS_C0014747 check ("ID" IS NOT NULL), PROCESS_INSTANCE_ID VARCHAR2(100), TASK_ID VARCHAR2(100), DURATION NUMBER(20), CREATE_TIME TIMESTAMP(6), NOTICE_TIME TIMESTAMP(6), NOTICE_USER VARCHAR2(5000), TENANT_ID NVARCHAR2(255), NOTICE_COUNT NUMBER default 0 not null constraint SYS_C0013614 check ("NOTICE_COUNT" IS NOT NULL) constraint SYS_C0014748 check ("NOTICE_COUNT" IS NOT NULL) ) ; comment on table T_WORKFLOW_TIMEOUT_NOTICE is '工作流超时提醒表' ; comment on column T_WORKFLOW_TIMEOUT_NOTICE.PROCESS_INSTANCE_ID is '流程实例id' ; comment on column T_WORKFLOW_TIMEOUT_NOTICE.TASK_ID is '任务id' ; comment on column T_WORKFLOW_TIMEOUT_NOTICE.DURATION is '过多久提醒（毫秒）' ; comment on column T_WORKFLOW_TIMEOUT_NOTICE.CREATE_TIME is '创建时间' ; comment on column T_WORKFLOW_TIMEOUT_NOTICE.NOTICE_TIME is '提醒触发时间点' ; comment on column T_WORKFLOW_TIMEOUT_NOTICE.NOTICE_USER is '通知人，存用户id，多个逗号分割' ; comment on column T_WORKFLOW_TIMEOUT_NOTICE.NOTICE_COUNT is '已发送通知次数' ; create table T_WF_PROCESS_PUBLISH ( ID NUMBER(20) not null constraint SYS_C0010820 primary key constraint SYS_C0010819 check ("ID" IS NOT NULL) constraint SYS_C0014746 check ("ID" IS NOT NULL), APPLY_TYPE VARCHAR2(200), SYSTEM_NAME VARCHAR2(200), PROCESS_INS_ID VARCHAR2(64), PROCESS_DEF_ID VARCHAR2(64), STATUS NUMBER(11), CURRENT_NODE VARCHAR2(64), CREATE_USER NUMBER(20), IS_DELETED VARCHAR2(200), CREATE_TIME DATE ) ; comment on table T_WF_PROCESS_PUBLISH is '应用发布申请管理' ; comment on column T_WF_PROCESS_PUBLISH.ID is 'ID' ; comment on column T_WF_PROCESS_PUBLISH.APPLY_TYPE is '类型' ; comment on column T_WF_PROCESS_PUBLISH.SYSTEM_NAME is '应用发布标题' ; comment on column T_WF_PROCESS_PUBLISH.PROCESS_INS_ID is '流程实例ID' ; comment on column T_WF_PROCESS_PUBLISH.PROCESS_DEF_ID is '流程定义id' ; comment on column T_WF_PROCESS_PUBLISH.STATUS is '状态' ; comment on column T_WF_PROCESS_PUBLISH.CURRENT_NODE is '当前节点' ; comment on column T_WF_PROCESS_PUBLISH.CREATE_USER is '创建人' ; comment on column T_WF_PROCESS_PUBLISH.IS_DELETED is '是否已删除' ; comment on column T_WF_PROCESS_PUBLISH.CREATE_TIME is '创建时间' ; create table T_UNIFIES_TODO ( ID NUMBER(20) not null constraint SYS_C0013969 primary key constraint SYS_C0013968 check ("ID" IS NOT NULL) constraint SYS_C0014744 check ("ID" IS NOT NULL), TITLE VARCHAR2(255), START_TIME DATE, START_NAME VARCHAR2(20), EXAMINE_NAME VARCHAR2(20), TYPE NUMBER(1), IS_SKIP NUMBER(1), SKIP_URL VARCHAR2(255), TODO_START NUMBER(1), FLOWABLE_ID VARCHAR2(255), TASK_ID VARCHAR2(100), TASK_NAME VARCHAR2(50), TODO_TAG VARCHAR2(100), APP_SOURCE VARCHAR2(50), END_DATE DATE, APPROVERS VARCHAR2(1000), PRIORITY NUMBER(1), EXAMINE_TIME DATE, START_USER VARCHAR2(20), SERIAL_NUMBER VARCHAR2(100) ) ; comment on column T_UNIFIES_TODO.ID is '主键' ; comment on column T_UNIFIES_TODO.TITLE is '待办标题' ; comment on column T_UNIFIES_TODO.START_TIME is '发起时间' ; comment on column T_UNIFIES_TODO.START_NAME is '发起人工号' ; comment on column T_UNIFIES_TODO.EXAMINE_NAME is '授理人工号' ; comment on column T_UNIFIES_TODO.TYPE is '待办类型(0:应用登记审核，1:项目登记审核,2:服务上架审批3第三方应用)' ; comment on column T_UNIFIES_TODO.IS_SKIP is '是否需要跳转0:false,1:true' ; comment on column T_UNIFIES_TODO.SKIP_URL is '跳转链接' ; comment on column T_UNIFIES_TODO.TODO_START is '待办状态1已办，2未办，3撤销' ; comment on column T_UNIFIES_TODO.FLOWABLE_ID is '工作流id' ; comment on column T_UNIFIES_TODO.TASK_ID is '任务id' ; comment on column T_UNIFIES_TODO.TASK_NAME is '节点名称' ; comment on column T_UNIFIES_TODO.TODO_TAG is '待办标识' ; comment on column T_UNIFIES_TODO.APP_SOURCE is '来源应用' ; comment on column T_UNIFIES_TODO.END_DATE is '办结期限' ; comment on column T_UNIFIES_TODO.APPROVERS is '审批人工号列表' ; comment on column T_UNIFIES_TODO.PRIORITY is '优先级1高，2中，3低' ; comment on column T_UNIFIES_TODO.EXAMINE_TIME is '办理时间' ; comment on column T_UNIFIES_TODO.START_USER is '发起人姓名' ; comment on column T_UNIFIES_TODO.SERIAL_NUMBER is '流水号' ; create table T_TOP_MENU ( ID NUMBER(20) not null constraint SYS_C009442 primary key constraint SYS_C00150020 check ("ID" IS NOT NULL) constraint SYS_C009441 check ("ID" IS NOT NULL), CODE NVARCHAR2(255), NAME NVARCHAR2(255), SOURCE NVARCHAR2(255), SORT NUMBER(11), IS_DEFAULT NUMBER(11) default 0, CREATE_USER NUMBER(20), CREATE_DEPT NUMBER(20), CREATE_TIME DATE, UPDATE_USER NUMBER(20), UPDATE_TIME DATE, STATUS NUMBER(11), IS_DELETED NUMBER(11) default 0 ) ; comment on table T_TOP_MENU is '顶部菜单表' ; comment on column T_TOP_MENU.ID is '主键' ; comment on column T_TOP_MENU.CODE is '顶部菜单编号' ; comment on column T_TOP_MENU.NAME is '顶部菜单名' ; comment on column T_TOP_MENU.SOURCE is '顶部菜单资源' ; comment on column T_TOP_MENU.SORT is '顶部菜单排序' ; comment on column T_TOP_MENU.IS_DEFAULT is '默认菜单' ; comment on column T_TOP_MENU.CREATE_USER is '创建人' ; comment on column T_TOP_MENU.CREATE_DEPT is '创建部门' ; comment on column T_TOP_MENU.CREATE_TIME is '创建时间' ; comment on column T_TOP_MENU.UPDATE_USER is '修改人' ; comment on column T_TOP_MENU.UPDATE_TIME is '修改时间' ; comment on column T_TOP_MENU.STATUS is '状态' ; comment on column T_TOP_MENU.IS_DELETED is '是否已删除' ; create table T_TENANT ( ID NUMBER(19) not null constraint SYS_C0013364 primary key constraint SYS_C0013362 check ("ID" IS NOT NULL) constraint SYS_C0014741 check ("ID" IS NOT NULL) constraint SYS_C008755 check ("ID" IS NOT NULL) constraint SYS_C008763 check ("ID" IS NOT NULL), TENANT_ID VARCHAR2(12 char) default '000000', TENANT_NAME VARCHAR2(50 char) not null constraint SYS_C0013363 check ("TENANT_NAME" IS NOT NULL) constraint SYS_C0014742 check ("TENANT_NAME" IS NOT NULL) constraint SYS_C008756 check ("TENANT_NAME" IS NOT NULL) constraint SYS_C008764 check ("TENANT_NAME" IS NOT NULL), DOMAIN_URL VARCHAR2(255 char), BACKGROUND_URL VARCHAR2(1000 char), LINKMAN VARCHAR2(20 char), CONTACT_NUMBER VARCHAR2(20 char), ADDRESS VARCHAR2(255 char), ACCOUNT_NUMBER NUMBER default -1, EXPIRE_TIME TIMESTAMP(6), PACKAGE_ID NUMBER(19), DATASOURCE_ID NUMBER(19), LICENSE_KEY VARCHAR2(1000 char), CREATE_USER NUMBER(19), CREATE_DEPT NUMBER(19), CREATE_TIME TIMESTAMP(6), UPDATE_USER NUMBER(19), UPDATE_TIME TIMESTAMP(6), STATUS NUMBER, IS_DELETED NUMBER default 0 ) ; comment on table T_TENANT is '租户表' ; comment on column T_TENANT.ID is '主键' ; comment on column T_TENANT.TENANT_ID is '租户ID' ; comment on column T_TENANT.TENANT_NAME is '租户名称' ; comment on column T_TENANT.DOMAIN_URL is '域名地址' ; comment on column T_TENANT.BACKGROUND_URL is '系统背景' ; comment on column T_TENANT.LINKMAN is '联系人' ; comment on column T_TENANT.CONTACT_NUMBER is '联系电话' ; comment on column T_TENANT.ADDRESS is '联系地址' ; comment on column T_TENANT.ACCOUNT_NUMBER is '账号额度' ; comment on column T_TENANT.EXPIRE_TIME is '过期时间' ; comment on column T_TENANT.PACKAGE_ID is '产品包ID' ; comment on column T_TENANT.DATASOURCE_ID is '数据源ID' ; comment on column T_TENANT.LICENSE_KEY is '授权码' ; comment on column T_TENANT.CREATE_USER is '创建人' ; comment on column T_TENANT.CREATE_DEPT is '创建部门' ; comment on column T_TENANT.CREATE_TIME is '创建时间' ; comment on column T_TENANT.UPDATE_USER is '修改人' ; comment on column T_TENANT.UPDATE_TIME is '修改时间' ; comment on column T_TENANT.STATUS is '状态' ; comment on column T_TENANT.IS_DELETED is '是否已删除' ; create table T_TAG ( ID NUMBER(20) not null constraint SYS_C009440 primary key constraint SYS_C0014740 check ("ID" IS NOT NULL) constraint SYS_C00155538 check ("ID" IS NOT NULL) constraint SYS_C009439 check ("ID" IS NOT NULL), PARENT_ID NUMBER(20), TAG_NAME NVARCHAR2(100), CUR_NODE NVARCHAR2(100), TAG_DESC NVARCHAR2(200), TAG_GRAIN NUMBER, IS_ACTIVE NUMBER, UPDATED_AT DATE, CREATED_AT DATE, ROOT_ID NUMBER(20), IS_DELETED NUMBER(1) default 0 ) ; comment on table T_TAG is '标签表' ; comment on column T_TAG.ID is 'id' ; comment on column T_TAG.PARENT_ID is '父级id' ; comment on column T_TAG.TAG_NAME is '标签名称' ; comment on column T_TAG.CUR_NODE is '编码-等级' ; comment on column T_TAG.TAG_DESC is '标签描述' ; comment on column T_TAG.TAG_GRAIN is '等级' ; comment on column T_TAG.IS_ACTIVE is '状态：0-正常，1-禁用' ; comment on column T_TAG.UPDATED_AT is '更新时间' ; comment on column T_TAG.CREATED_AT is '创建时间' ; comment on column T_TAG.ROOT_ID is '根节点id' ; comment on column T_TAG.IS_DELETED is '逻辑删除：0-未删除；1-已删除' ; create table T_SYSTEM_SUGGESTION ( FILE_URL VARCHAR2(500), CONTACT_NUMBER NUMBER, STATUS NUMBER default 0, ID VARCHAR2(255) not null constraint SYS_C0010865 check ("ID" IS NOT NULL) constraint SYS_C0014736 check ("ID" IS NOT NULL), CREATE_TIME VARCHAR2(255), SUGGESTION NCLOB ) ; comment on table T_SYSTEM_SUGGESTION is '系统建议表' ; comment on column T_SYSTEM_SUGGESTION.FILE_URL is '文件路径' ; comment on column T_SYSTEM_SUGGESTION.CONTACT_NUMBER is '联系电话' ; comment on column T_SYSTEM_SUGGESTION.STATUS is '处理状态0未处理;1已处理' ; comment on column T_SYSTEM_SUGGESTION.CREATE_TIME is '创建时间' ; comment on column T_SYSTEM_SUGGESTION.SUGGESTION is '问题及建议' ; create table T_SYS_USER ( ID NUMBER not null constraint SYS_C00158424 check ("ID" IS NOT NULL) constraint SYS_C009437 check ("ID" IS NOT NULL), DEPT_ID NUMBER(20), USERNAME NVARCHAR2(100), PASSWORD NVARCHAR2(100), NAME NVARCHAR2(100), MOBILE NVARCHAR2(100), EMAIL NVARCHAR2(100), AVATAR NVARCHAR2(200), ADDRESS NVARCHAR2(200), STATE NUMBER(11) not null constraint SYS_C00158425 check ("STATE" IS NOT NULL) constraint SYS_C009438 check ("STATE" IS NOT NULL), TYPE NUMBER(11), CODE NVARCHAR2(100), COMPANY NVARCHAR2(100), PROVINCE NVARCHAR2(100), CITY NVARCHAR2(100), EXT_TYPE NVARCHAR2(100), EXT_DEPT NVARCHAR2(100), EXT_CODE NVARCHAR2(100), EXT_CODE_HS NVARCHAR2(100), EXT_CODE_GH NVARCHAR2(100), EXT_CODE_GJ NVARCHAR2(100), EXT_CODE_GK NVARCHAR2(100), EXT_DDBB NVARCHAR2(100), UPDATED_AT DATE, CREATED_AT DATE, PASSWORD_WRONG_TIMES NUMBER(11), LAST_LOGIN_DATE DATE, EXT_UNIT_ID NUMBER(11), EXT_MEMO NCLOB, JOB NVARCHAR2(40), IS_QDPORT_USER VARCHAR2(10) default '99' not null, LAST_UPDATE_PWD_DATE DATE ) ; comment on table T_SYS_USER is '系统管理-用户表' ; comment on column T_SYS_USER.ID is 'id' ; comment on column T_SYS_USER.DEPT_ID is '所属部门表id' ; comment on column T_SYS_USER.USERNAME is '用户名' ; comment on column T_SYS_USER.PASSWORD is '密码' ; comment on column T_SYS_USER.NAME is '姓名' ; comment on column T_SYS_USER.MOBILE is '手机号' ; comment on column T_SYS_USER.EMAIL is '邮箱' ; comment on column T_SYS_USER.AVATAR is '头像地址' ; comment on column T_SYS_USER.ADDRESS is '地址' ; comment on column T_SYS_USER.STATE is '状态：0-正常，1-禁用' ; comment on column T_SYS_USER.TYPE is '用户类型' ; comment on column T_SYS_USER.CODE is '用户代码' ; comment on column T_SYS_USER.COMPANY is '用户单位' ; comment on column T_SYS_USER.PROVINCE is '省份' ; comment on column T_SYS_USER.CITY is '城市' ; comment on column T_SYS_USER.EXT_TYPE is '用户类型（cz 场站,cd 车队,mt 码头,pt 平台,ys演示,zh综合）' ; comment on column T_SYS_USER.EXT_DEPT is '业务部门(申报员证书编号)' ; comment on column T_SYS_USER.EXT_CODE is '特殊代码' ; comment on column T_SYS_USER.EXT_CODE_HS is '海事特殊代码' ; comment on column T_SYS_USER.EXT_CODE_GH is '港航特殊代码' ; comment on column T_SYS_USER.EXT_CODE_GJ is '国检特殊代码' ; comment on column T_SYS_USER.EXT_CODE_GK is '港口特殊代码' ; comment on column T_SYS_USER.EXT_DDBB is '四班调度班别' ; comment on column T_SYS_USER.UPDATED_AT is '更新时间' ; comment on column T_SYS_USER.CREATED_AT is '创建时间' ; comment on column T_SYS_USER.PASSWORD_WRONG_TIMES is '密码错误次数' ; comment on column T_SYS_USER.LAST_LOGIN_DATE is '最后登录时间' ; comment on column T_SYS_USER.EXT_UNIT_ID is '单位代码' ; comment on column T_SYS_USER.EXT_MEMO is '用户印章(base64)' ; comment on column T_SYS_USER.JOB is '岗位' ; comment on column T_SYS_USER.IS_QDPORT_USER is '是否青岛港人员 (0：板块人员，2：青岛港人员，99：其他)' ; comment on column T_SYS_USER.LAST_UPDATE_PWD_DATE is '密码最后修改时间' ; create table T_SYS_ROLE ( ID NUMBER(20) not null constraint SYS_C009436 primary key constraint SYS_C00149877 check ("ID" IS NOT NULL) constraint SYS_C009435 check ("ID" IS NOT NULL), NAME NVARCHAR2(100), CODE NVARCHAR2(100), DESCRIPTION NVARCHAR2(100), SORT NUMBER(11), STATE NUMBER(11), UPDATED_AT DATE, CREATED_AT DATE, IS_SHOW NUMBER(11) ) ; comment on table T_SYS_ROLE is '系统管理-角色表' ; comment on column T_SYS_ROLE.ID is 'id' ; comment on column T_SYS_ROLE.NAME is '角色名称' ; comment on column T_SYS_ROLE.CODE is '角色代码' ; comment on column T_SYS_ROLE.DESCRIPTION is '角色描述' ; comment on column T_SYS_ROLE.SORT is '排序' ; comment on column T_SYS_ROLE.STATE is '状态：0-正常，1-禁用' ; comment on column T_SYS_ROLE.UPDATED_AT is '更新时间' ; comment on column T_SYS_ROLE.CREATED_AT is '创建时间' ; comment on column T_SYS_ROLE.IS_SHOW is '是否显示，0：不显示，1：显示' ; create table T_SYS_PORT_AREA ( ID VARCHAR2(20) not null constraint SYS_C0014155 primary key constraint SYS_C0014734 check ("ID" IS NOT NULL), PORT_AREA_CODE VARCHAR2(255) not null constraint SYS_C0014154 check ("PORT_AREA_CODE" IS NOT NULL) constraint SYS_C0014735 check ("PORT_AREA_CODE" IS NOT NULL), PORT_AREA_NAME VARCHAR2(255) ) ; comment on table T_SYS_PORT_AREA is '港区表' ; comment on column T_SYS_PORT_AREA.ID is '主键' ; comment on column T_SYS_PORT_AREA.PORT_AREA_CODE is '港区代码' ; comment on column T_SYS_PORT_AREA.PORT_AREA_NAME is '港区名称' ; create table T_SYS_PART_JOB ( USER_ID NUMBER(20), DEPT_ID NUMBER(20) ) ; comment on table T_SYS_PART_JOB is '兼职表' ; comment on column T_SYS_PART_JOB.USER_ID is '用户id' ; comment on column T_SYS_PART_JOB.DEPT_ID is '部门id' ; create table T_SYS_MENU ( ID NUMBER(20) not null constraint SYS_C009434 primary key constraint SYS_C00150999 check ("ID" IS NOT NULL) constraint SYS_C009433 check ("ID" IS NOT NULL), PARENT_ID NUMBER(20), NAME NVARCHAR2(100), CODE NVARCHAR2(100), ICON NVARCHAR2(100), PATH NVARCHAR2(100), DESCRIPTION NVARCHAR2(100), TYPE NUMBER(11), SORT NUMBER(11), SYSTEM_CODE NVARCHAR2(255), STATE NUMBER(11), UPDATED_AT DATE, CREATED_AT DATE, MENU_TYPE NUMBER(11) ) ; comment on table T_SYS_MENU is '系统管理-功能菜单表' ; comment on column T_SYS_MENU.ID is 'id' ; comment on column T_SYS_MENU.PARENT_ID is '所属菜单id' ; comment on column T_SYS_MENU.NAME is '菜单名称' ; comment on column T_SYS_MENU.CODE is '菜单代码' ; comment on column T_SYS_MENU.ICON is '菜单图标' ; comment on column T_SYS_MENU.PATH is '菜单路径' ; comment on column T_SYS_MENU.DESCRIPTION is '菜单描述' ; comment on column T_SYS_MENU.TYPE is '菜单类型：1-菜单，2-按钮' ; comment on column T_SYS_MENU.SORT is '排序' ; comment on column T_SYS_MENU.SYSTEM_CODE is '系统编号' ; comment on column T_SYS_MENU.STATE is '状态：0-正常，1-禁用' ; comment on column T_SYS_MENU.UPDATED_AT is '更新时间' ; comment on column T_SYS_MENU.CREATED_AT is '创建时间' ; comment on column T_SYS_MENU.MENU_TYPE is '菜单类型：1-网页菜单，2-APP菜单' ; create table T_SYS_DEPT ( ID NUMBER(20) not null constraint SYS_C009430 primary key constraint SYS_C00149873 check ("ID" IS NOT NULL) constraint SYS_C009429 check ("ID" IS NOT NULL), PARENT_ID NUMBER(20), NAME NVARCHAR2(100), CODE NVARCHAR2(100), DESCRIPTION NVARCHAR2(200), SORT NUMBER, STATE NUMBER, UPDATED_AT DATE, CREATED_AT DATE, ANCESTORS VARCHAR2(255), DEPT_TYPE NUMBER default 0 not null constraint SYS_C0010719 check ("DEPT_TYPE" IS NOT NULL), EX_WECHAT VARCHAR2(100), EX_PORTRAIT VARCHAR2(100), EX_GENDER VARCHAR2(100), EX_REGION VARCHAR2(100), EX_PROVINCE VARCHAR2(100) ) ; comment on table T_SYS_DEPT is '系统管理-部门表' ; comment on column T_SYS_DEPT.ID is 'id' ; comment on column T_SYS_DEPT.PARENT_ID is '所属部门id' ; comment on column T_SYS_DEPT.NAME is '部门名称' ; comment on column T_SYS_DEPT.CODE is '部门代码' ; comment on column T_SYS_DEPT.DESCRIPTION is '部门描述' ; comment on column T_SYS_DEPT.SORT is '排序' ; comment on column T_SYS_DEPT.STATE is '状态：0-正常，1-禁用' ; comment on column T_SYS_DEPT.UPDATED_AT is '更新时间' ; comment on column T_SYS_DEPT.CREATED_AT is '创建时间' ; comment on column T_SYS_DEPT.ANCESTORS is '祖籍' ; comment on column T_SYS_DEPT.DEPT_TYPE is '部门类型 0部门 1公司' ; comment on column T_SYS_DEPT.EX_WECHAT is '预留字段5' ; comment on column T_SYS_DEPT.EX_PORTRAIT is '预留字段4' ; comment on column T_SYS_DEPT.EX_GENDER is '预留字段3' ; comment on column T_SYS_DEPT.EX_REGION is '预留字段2' ; comment on column T_SYS_DEPT.EX_PROVINCE is '预留字段1' ; create table T_SYNC_USER_CHANGE_HISTORY ( ID VARCHAR2(50) not null constraint SYS_C0010258 unique constraint SYS_C0010255 check ("ID" IS NOT NULL) constraint SYS_C0014728 check ("ID" IS NOT NULL), CHANGE_TYPE NUMBER default 0 not null constraint SYS_C0010256 check ("CHANGE_TYPE" IS NOT NULL) constraint SYS_C0014729 check ("CHANGE_TYPE" IS NOT NULL), USERNAME VARCHAR2(50) not null constraint SYS_C0010257 check ("USERNAME" IS NOT NULL) constraint SYS_C0014730 check ("USERNAME" IS NOT NULL), NAME VARCHAR2(50), CHANGE_TIME TIMESTAMP(6), SYNC_TIME TIMESTAMP(6), REMARK VARCHAR2(500) ) ; comment on table T_SYNC_USER_CHANGE_HISTORY is '同步用户变动表' ; comment on column T_SYNC_USER_CHANGE_HISTORY.CHANGE_TYPE is '变更类型 0新增 1锁定 2其他变动' ; comment on column T_SYNC_USER_CHANGE_HISTORY.USERNAME is '用户工号' ; comment on column T_SYNC_USER_CHANGE_HISTORY.NAME is '姓名' ; comment on column T_SYNC_USER_CHANGE_HISTORY.CHANGE_TIME is '改变时间' ; comment on column T_SYNC_USER_CHANGE_HISTORY.SYNC_TIME is '同步时间' ; comment on column T_SYNC_USER_CHANGE_HISTORY.REMARK is '备注' ; create table T_SMS ( ID NUMBER(20) not null constraint SYS_C0014727 check ("ID" IS NOT NULL) constraint SYS_C00149805 check ("ID" IS NOT NULL) constraint SYS_C0020140 check ("ID" IS NOT NULL) constraint SYS_C009428 check ("ID" IS NOT NULL), TENANT_ID NVARCHAR2(12), CATEGORY NUMBER(11), SMS_CODE VARCHAR2(12), TEMPLATE_ID VARCHAR2(64), ACCESS_KEY NVARCHAR2(255), SECRET_KEY NVARCHAR2(255), REGION_ID NVARCHAR2(255), SIGN_NAME VARCHAR2(64), REMARK NVARCHAR2(255), CREATE_USER NUMBER(20), CREATE_DEPT NUMBER(20), CREATE_TIME DATE, UPDATE_USER NUMBER(20), UPDATE_TIME DATE, STATUS NUMBER(11), IS_DELETED NUMBER(11) ) ; comment on table T_SMS is '短信配置表' ; comment on column T_SMS.ID is '主键' ; comment on column T_SMS.TENANT_ID is '租户ID' ; comment on column T_SMS.CATEGORY is '分类' ; comment on column T_SMS.SMS_CODE is '资源编号' ; comment on column T_SMS.TEMPLATE_ID is '模板ID' ; comment on column T_SMS.ACCESS_KEY is 'accessKey' ; comment on column T_SMS.SECRET_KEY is 'secretKey' ; comment on column T_SMS.REGION_ID is 'regionId' ; comment on column T_SMS.SIGN_NAME is '短信签名' ; comment on column T_SMS.REMARK is '备注' ; comment on column T_SMS.CREATE_USER is '创建人' ; comment on column T_SMS.CREATE_DEPT is '创建部门' ; comment on column T_SMS.CREATE_TIME is '创建时间' ; comment on column T_SMS.UPDATE_USER is '修改人' ; comment on column T_SMS.UPDATE_TIME is '修改时间' ; comment on column T_SMS.STATUS is '状态' ; comment on column T_SMS.IS_DELETED is '是否已删除' ; -- auto-generated definition create table T_SCOPE_DATA ( ID NUMBER(20) not null constraint SYS_C0011059 primary key constraint SYS_C00167861 check ("ID" IS NOT NULL) constraint SYS_C009427 check ("ID" IS NOT NULL), MENU_ID NUMBER(20), RESOURCE_CODE NVARCHAR2(255), SCOPE_NAME NVARCHAR2(255), SCOPE_FIELD NVARCHAR2(255), SCOPE_CLASS NVARCHAR2(500), SCOPE_COLUMN NVARCHAR2(255), SCOPE_TYPE NUMBER(11), SCOPE_VALUE NCLOB, REMARK NVARCHAR2(255), CREATE_USER NUMBER(20), CREATE_DEPT NUMBER(20), CREATE_TIME DATE, UPDATE_USER NUMBER(20), UPDATE_TIME DATE, STATUS NUMBER(11), IS_DELETED NUMBER(11), SORT NUMBER(1) ) ; comment on table T_SCOPE_DATA is '数据权限表' ; comment on column T_SCOPE_DATA.ID is '主键' ; comment on column T_SCOPE_DATA.MENU_ID is '菜单主键' ; comment on column T_SCOPE_DATA.RESOURCE_CODE is '资源编号' ; comment on column T_SCOPE_DATA.SCOPE_NAME is '数据权限名称' ; comment on column T_SCOPE_DATA.SCOPE_FIELD is '数据权限字段' ; comment on column T_SCOPE_DATA.SCOPE_CLASS is '数据权限类名' ; comment on column T_SCOPE_DATA.SCOPE_COLUMN is '数据权限字段' ; comment on column T_SCOPE_DATA.SCOPE_TYPE is '数据权限类型(1 全部可见,2 本人可见,3所在机构可见, 4所在机构及子级可见,5自定义)' ; comment on column T_SCOPE_DATA.SCOPE_VALUE is '数据权限值域' ; comment on column T_SCOPE_DATA.REMARK is '数据权限备注' ; comment on column T_SCOPE_DATA.CREATE_USER is '创建人' ; comment on column T_SCOPE_DATA.CREATE_DEPT is '创建部门' ; comment on column T_SCOPE_DATA.CREATE_TIME is '创建时间' ; comment on column T_SCOPE_DATA.UPDATE_USER is '修改人' ; comment on column T_SCOPE_DATA.UPDATE_TIME is '修改时间' ; comment on column T_SCOPE_DATA.STATUS is '状态' ; comment on column T_SCOPE_DATA.IS_DELETED is '是否已删除' ; comment on column T_SCOPE_DATA.SORT is '排序' ; create table T_SCOPE_API ( ID NUMBER(20), MENU_ID NUMBER(20), SCOPE_NAME NVARCHAR2(500), RESOURCE_CODE NVARCHAR2(500), SCOPE_PATH NVARCHAR2(500), SCOPE_TYPE NUMBER(11), REMARK NVARCHAR2(2000), CREATE_USER NUMBER(20), CREATE_DEPT NUMBER(20), CREATE_TIME DATE, UPDATE_TIME DATE, UPDATE_USER NUMBER(20), IS_DELETED NUMBER(11) ) ; comment on table T_SCOPE_API is '接口权限表' ; comment on column T_SCOPE_API.ID is '主键' ; comment on column T_SCOPE_API.MENU_ID is '菜单Id' ; comment on column T_SCOPE_API.SCOPE_NAME is '权限名称' ; comment on column T_SCOPE_API.RESOURCE_CODE is '权限编号' ; comment on column T_SCOPE_API.SCOPE_PATH is '权限路径' ; comment on column T_SCOPE_API.SCOPE_TYPE is '接口类型(0.业务接口, 1.系统接口)' ; comment on column T_SCOPE_API.REMARK is '权限备注' ; comment on column T_SCOPE_API.CREATE_USER is '创建人' ; comment on column T_SCOPE_API.CREATE_DEPT is '创建部门' ; comment on column T_SCOPE_API.CREATE_TIME is '创建时间' ; comment on column T_SCOPE_API.UPDATE_TIME is '修改时间' ; comment on column T_SCOPE_API.UPDATE_USER is '修改人' ; comment on column T_SCOPE_API.IS_DELETED is '删除标识' ; create table T_ROLE_SCOPE ( ID NUMBER(20) not null constraint SYS_C00167862 check ("ID" IS NOT NULL) constraint SYS_C009426 check ("ID" IS NOT NULL), SCOPE_CATEGORY NUMBER(11), SCOPE_ID NUMBER(20), ROLE_ID NUMBER(20) ) ; comment on table T_ROLE_SCOPE is '角色数据权限关联表' ; comment on column T_ROLE_SCOPE.ID is '主键' ; comment on column T_ROLE_SCOPE.SCOPE_CATEGORY is '权限类型(1:数据权限、2:接口权限)' ; comment on column T_ROLE_SCOPE.SCOPE_ID is '权限ID' ; comment on column T_ROLE_SCOPE.ROLE_ID is '角色ID' ; create table T_POST ( ID NUMBER(20) not null constraint SYS_C0014724 check ("ID" IS NOT NULL) constraint SYS_C00163722 check ("ID" IS NOT NULL) constraint SYS_C009425 check ("ID" IS NOT NULL), TENANT_ID NVARCHAR2(12), CATEGORY NUMBER(11), POST_CODE VARCHAR2(12), POST_NAME VARCHAR2(64), SORT NUMBER(11), REMARK NVARCHAR2(255), CREATE_USER NUMBER(20), CREATE_DEPT NUMBER(20), CREATE_TIME DATE, UPDATE_USER NUMBER(20), UPDATE_TIME DATE, STATUS NUMBER(11), IS_DELETED NUMBER(11) ) ; comment on table T_POST is '岗位表' ; comment on column T_POST.ID is '主键' ; comment on column T_POST.TENANT_ID is '租户ID' ; comment on column T_POST.CATEGORY is '岗位类型' ; comment on column T_POST.POST_CODE is '岗位编号' ; comment on column T_POST.POST_NAME is '岗位名称' ; comment on column T_POST.SORT is '岗位排序' ; comment on column T_POST.REMARK is '岗位描述' ; comment on column T_POST.CREATE_USER is '创建人' ; comment on column T_POST.CREATE_DEPT is '创建部门' ; comment on column T_POST.CREATE_TIME is '创建时间' ; comment on column T_POST.UPDATE_USER is '修改人' ; comment on column T_POST.UPDATE_TIME is '修改时间' ; comment on column T_POST.STATUS is '状态' ; comment on column T_POST.IS_DELETED is '是否已删除' ; create table T_PARAM ( ID NUMBER(20) not null constraint SYS_C009420 primary key constraint SYS_C00152319 check ("ID" IS NOT NULL) constraint SYS_C009419 check ("ID" IS NOT NULL), PARAM_NAME NVARCHAR2(255), PARAM_KEY NVARCHAR2(255), PARAM_VALUE NVARCHAR2(255), REMARK NVARCHAR2(255), CREATE_USER NUMBER(20), CREATE_DEPT NUMBER(20), CREATE_TIME DATE, UPDATE_USER NUMBER(20), UPDATE_TIME DATE, STATUS NUMBER(11), IS_DELETED NUMBER(11) ) ; comment on table T_PARAM is '参数表' ; comment on column T_PARAM.ID is '主键' ; comment on column T_PARAM.PARAM_NAME is '参数名' ; comment on column T_PARAM.PARAM_KEY is '参数键' ; comment on column T_PARAM.PARAM_VALUE is '参数值' ; comment on column T_PARAM.REMARK is '备注' ; comment on column T_PARAM.CREATE_USER is '创建人' ; comment on column T_PARAM.CREATE_DEPT is '创建部门' ; comment on column T_PARAM.CREATE_TIME is '创建时间' ; comment on column T_PARAM.UPDATE_USER is '修改人' ; comment on column T_PARAM.UPDATE_TIME is '修改时间' ; comment on column T_PARAM.STATUS is '状态' ; comment on column T_PARAM.IS_DELETED is '是否已删除' ; create table T_PAGE_VIEW ( MENU_ID NUMBER(20), USER_NAME VARCHAR2(50) ) ; create table T_OSS ( ID NUMBER(20) not null constraint SYS_C00149807 check ("ID" IS NOT NULL) constraint SYS_C0020124 check ("ID" IS NOT NULL) constraint SYS_C009418 check ("ID" IS NOT NULL), TENANT_ID NVARCHAR2(12), CATEGORY NUMBER(11), OSS_CODE NVARCHAR2(32), ENDPOINT NVARCHAR2(255), ACCESS_KEY NVARCHAR2(255), SECRET_KEY NVARCHAR2(255), BUCKET_NAME NVARCHAR2(255), APP_ID NVARCHAR2(255), REGION NVARCHAR2(255), REMARK NVARCHAR2(255), CREATE_USER VARCHAR2(50), CREATE_DEPT VARCHAR2(50), CREATE_TIME DATE, UPDATE_USER VARCHAR2(50), UPDATE_TIME DATE, STATUS NUMBER(11), IS_DELETED NUMBER(11) ) ; comment on table T_OSS is '对象存储表' ; comment on column T_OSS.ID is '主键' ; comment on column T_OSS.TENANT_ID is '租户ID' ; comment on column T_OSS.CATEGORY is '分类' ; comment on column T_OSS.OSS_CODE is '资源编号' ; comment on column T_OSS.ENDPOINT is '资源地址' ; comment on column T_OSS.ACCESS_KEY is 'accessKey' ; comment on column T_OSS.SECRET_KEY is 'secretKey' ; comment on column T_OSS.BUCKET_NAME is '空间名' ; comment on column T_OSS.APP_ID is '应用ID' ; comment on column T_OSS.REGION is '地域简称' ; comment on column T_OSS.REMARK is '备注' ; comment on column T_OSS.CREATE_USER is '创建人' ; comment on column T_OSS.CREATE_DEPT is '创建部门' ; comment on column T_OSS.CREATE_TIME is '创建时间' ; comment on column T_OSS.UPDATE_USER is '修改人' ; comment on column T_OSS.UPDATE_TIME is '修改时间' ; comment on column T_OSS.STATUS is '状态' ; comment on column T_OSS.IS_DELETED is '是否已删除' ; create table T_NOTICE_IS_READ ( ID VARCHAR2(20) not null constraint SYS_C0014180 primary key constraint SYS_C0014179 check ("ID" IS NOT NULL) constraint SYS_C0014719 check ("ID" IS NOT NULL), NOTICE_ID VARCHAR2(20), USER_NAME VARCHAR2(50) ) ; comment on column T_NOTICE_IS_READ.ID is '主键' ; comment on column T_NOTICE_IS_READ.NOTICE_ID is '公告id' ; comment on column T_NOTICE_IS_READ.USER_NAME is '用户工号' ; create table T_NOTICE ( ID NUMBER(20) not null constraint SYS_C00149809 check ("ID" IS NOT NULL) constraint SYS_C0020123 check ("ID" IS NOT NULL) constraint SYS_C009417 check ("ID" IS NOT NULL), TENANT_ID NVARCHAR2(12), TITLE NVARCHAR2(255), CATEGORY NUMBER(11), CONTENT NVARCHAR2(2000), CREATE_USER VARCHAR2(100), CREATE_DEPT VARCHAR2(100), CREATE_TIME DATE, UPDATE_USER VARCHAR2(100), UPDATE_TIME DATE, STATUS NUMBER(11), IS_DELETED NUMBER(11), IS_MUSTREAD NUMBER default 0, PUBLISH_STATUS NUMBER default 0, EXPIRE_TIME DATE, PUBLISH_TIME DATE, INTRODUCE VARCHAR2(255), IS_POPUP NUMBER, IS_SHOW NUMBER, SEND_SCOPE NUMBER ) ; comment on table T_NOTICE is '通知公告表' ; comment on column T_NOTICE.ID is '主键' ; comment on column T_NOTICE.TENANT_ID is '租户ID' ; comment on column T_NOTICE.TITLE is '标题' ; comment on column T_NOTICE.CATEGORY is '类型1默认，2新闻，3系统公告' ; comment on column T_NOTICE.CONTENT is '内容' ; comment on column T_NOTICE.CREATE_USER is '创建人' ; comment on column T_NOTICE.CREATE_DEPT is '创建部门' ; comment on column T_NOTICE.CREATE_TIME is '创建时间' ; comment on column T_NOTICE.UPDATE_USER is '修改人' ; comment on column T_NOTICE.UPDATE_TIME is '修改时间' ; comment on column T_NOTICE.STATUS is '状态' ; comment on column T_NOTICE.IS_DELETED is '是否已删除' ; comment on column T_NOTICE.IS_MUSTREAD is '是否必读：0：false 1：true' ; comment on column T_NOTICE.PUBLISH_STATUS is '是否发布：0：未发布 1：已发布' ; comment on column T_NOTICE.EXPIRE_TIME is '过期时间' ; comment on column T_NOTICE.PUBLISH_TIME is '发布时间' ; comment on column T_NOTICE.INTRODUCE is '简介' ; comment on column T_NOTICE.IS_POPUP is '是否重复弹出1弹出 ;2不弹出' ; comment on column T_NOTICE.IS_SHOW is '是否展示1展示;2不展示' ; comment on column T_NOTICE.SEND_SCOPE is '发送范围' ; create table T_MESSAGE_CONTENT ( MESSAGE_ID VARCHAR2(100) not null constraint SYS_C0010666 primary key, MESSAGE_TITLE VARCHAR2(255), RECEIVE_CODE VARCHAR2(255), STATE NUMBER, SEND_USER_CODE VARCHAR2(50), SEND_USER_NAME VARCHAR2(50), SEND_TIME VARCHAR2(50), DELETE_RECORDS NUMBER, MESSAGE_CONTENT NCLOB, MES_TYPE NUMBER, MES_ID VARCHAR2(100), APP_SOURCE VARCHAR2(50), IS_SKIP NUMBER(1), SKIP_URL VARCHAR2(255), TASK_ID VARCHAR2(100), SERIAL_NUMBER VARCHAR2(100) ) ; comment on table T_MESSAGE_CONTENT is '站内信内容表' ; comment on column T_MESSAGE_CONTENT.MESSAGE_ID is '关联站内信id' ; comment on column T_MESSAGE_CONTENT.MESSAGE_TITLE is '站内信标题' ; comment on column T_MESSAGE_CONTENT.RECEIVE_CODE is '收件人列表' ; comment on column T_MESSAGE_CONTENT.STATE is '状态;0已读;1未读' ; comment on column T_MESSAGE_CONTENT.SEND_USER_CODE is '发送人工号' ; comment on column T_MESSAGE_CONTENT.SEND_USER_NAME is '发送人姓名' ; comment on column T_MESSAGE_CONTENT.SEND_TIME is '发送时间' ; comment on column T_MESSAGE_CONTENT.DELETE_RECORDS is '发送记录状态0未删除;1删除' ; comment on column T_MESSAGE_CONTENT.MESSAGE_CONTENT is '站内信内容' ; comment on column T_MESSAGE_CONTENT.MES_TYPE is '1通知;2代办' ; comment on column T_MESSAGE_CONTENT.MES_ID is '信使消息主键' ; comment on column T_MESSAGE_CONTENT.APP_SOURCE is '来源应用' ; comment on column T_MESSAGE_CONTENT.IS_SKIP is '是否需要跳转0:false,1:true' ; comment on column T_MESSAGE_CONTENT.SKIP_URL is '跳转链接' ; comment on column T_MESSAGE_CONTENT.TASK_ID is '任务id' ; comment on column T_MESSAGE_CONTENT.SERIAL_NUMBER is '流水号' ; create table T_MES_LOG ( ID VARCHAR2(50) not null constraint SYS_C0013036 primary key constraint SYS_C0013035 check ("ID" IS NOT NULL) constraint SYS_C0014717 check ("ID" IS NOT NULL), SEND_USER VARCHAR2(100), INCEPT_USER VARCHAR2(100), SEND_TIME VARCHAR2(100), TITLE VARCHAR2(255), TYPE NUMBER(1), PHONE NUMBER(11), CONTENT NCLOB ) ; comment on column T_MES_LOG.ID is '主键' ; comment on column T_MES_LOG.SEND_USER is '发送人' ; comment on column T_MES_LOG.INCEPT_USER is '接收人' ; comment on column T_MES_LOG.SEND_TIME is '发送时间' ; comment on column T_MES_LOG.TITLE is '标题' ; comment on column T_MES_LOG.TYPE is '类型1短信;2邮件;3站内信' ; comment on column T_MES_LOG.PHONE is '手机号' ; comment on column T_MES_LOG.CONTENT is '内容' ; create table T_MAIL ( ID VARCHAR2(100) not null constraint SYS_C0011068 primary key constraint SYS_C0011067 check ("ID" IS NOT NULL) constraint SYS_C0011069 check ("ID" IS NOT NULL) constraint SYS_C0014715 check ("ID" IS NOT NULL), HOST VARCHAR2(100), PASSWORD VARCHAR2(100), USERNAME VARCHAR2(100), STATE VARCHAR2(100), CODE VARCHAR2(100) ) ; comment on column T_MAIL.ID is '主键' ; comment on column T_MAIL.HOST is '端口' ; comment on column T_MAIL.PASSWORD is '密码' ; comment on column T_MAIL.USERNAME is '用户名' ; comment on column T_MAIL.STATE is '状态' ; comment on column T_MAIL.CODE is 'code' ; create table T_LABEL ( ID VARCHAR2(100) not null constraint SYS_C0014188 primary key constraint SYS_C0014708 check ("ID" IS NOT NULL), TITLE VARCHAR2(255 char) not null constraint SYS_C0014187 check ("TITLE" IS NOT NULL) constraint SYS_C0014709 check ("TITLE" IS NOT NULL), CREATE_TIME TIMESTAMP(6) default SYSDATE ) ; create table T_INSIDE_MESSAGE ( ID NUMBER(20) not null constraint SYS_C009410 primary key constraint SYS_C0014707 check ("ID" IS NOT NULL) constraint SYS_C00151079 check ("ID" IS NOT NULL) constraint SYS_C0020163 check ("ID" IS NOT NULL) constraint SYS_C009409 check ("ID" IS NOT NULL), TITLE NVARCHAR2(100), CONTENT NVARCHAR2(255), SEND_TIME DATE, SENDER NVARCHAR2(50), RECIPIENT NVARCHAR2(50), RANGE_TYPE NVARCHAR2(255), TYPE NVARCHAR2(50), IS_SKIP NUMBER default 0, SKIP_URL VARCHAR2(100) ) ; comment on table T_INSIDE_MESSAGE is '站内消息表' ; comment on column T_INSIDE_MESSAGE.ID is '主键' ; comment on column T_INSIDE_MESSAGE.TITLE is '标题' ; comment on column T_INSIDE_MESSAGE.CONTENT is '内容' ; comment on column T_INSIDE_MESSAGE.SEND_TIME is '发送时间' ; comment on column T_INSIDE_MESSAGE.SENDER is '发送人工号' ; comment on column T_INSIDE_MESSAGE.RECIPIENT is '接受人工号' ; comment on column T_INSIDE_MESSAGE.RANGE_TYPE is '范围类型(个人，部门，全体)' ; comment on column T_INSIDE_MESSAGE.TYPE is '消息类型(0短信;1邮件;2应用登记审核;3项目登记审核)' ; comment on column T_INSIDE_MESSAGE.IS_SKIP is '是否需要跳转0:false,1:true' ; comment on column T_INSIDE_MESSAGE.SKIP_URL is '跳转链接' ; create table T_EMAIL_LOG ( USERNAME NVARCHAR2(100), RECEIVE_STR NVARCHAR2(100), SUBJECT NVARCHAR2(100), CONTENT NVARCHAR2(100), TYPE NVARCHAR2(50), SEND_TIME DATE, IS_READ NUMBER, ID VARCHAR2(60) ) ; comment on table T_EMAIL_LOG is '邮件短信发送记录表' ; comment on column T_EMAIL_LOG.USERNAME is '发送人' ; comment on column T_EMAIL_LOG.RECEIVE_STR is '接收人' ; comment on column T_EMAIL_LOG.SUBJECT is '主题' ; comment on column T_EMAIL_LOG.CONTENT is '内容' ; comment on column T_EMAIL_LOG.TYPE is '类型' ; comment on column T_EMAIL_LOG.SEND_TIME is '发送时间' ; comment on column T_EMAIL_LOG.IS_READ is '是否必读' ; comment on column T_EMAIL_LOG.ID is 'id' ; create table T_DICT_BIZ ( ID NUMBER(20) not null constraint SYS_C00149811 check ("ID" IS NOT NULL) constraint SYS_C0020116 check ("ID" IS NOT NULL) constraint SYS_C009406 check ("ID" IS NOT NULL), TENANT_ID NVARCHAR2(12), PARENT_ID NUMBER(20), CODE NVARCHAR2(255), DICT_KEY NVARCHAR2(255), DICT_VALUE NVARCHAR2(255), SORT NUMBER(11), REMARK NVARCHAR2(255), IS_SEALED NUMBER(11), IS_DELETED NUMBER(11) ) ; comment on table T_DICT_BIZ is '数据源配置表' ; comment on column T_DICT_BIZ.ID is '主键' ; comment on column T_DICT_BIZ.TENANT_ID is '租户ID' ; comment on column T_DICT_BIZ.PARENT_ID is '父主键' ; comment on column T_DICT_BIZ.CODE is '字典码' ; comment on column T_DICT_BIZ.DICT_KEY is '字典值' ; comment on column T_DICT_BIZ.DICT_VALUE is '字典名称' ; comment on column T_DICT_BIZ.SORT is '排序' ; comment on column T_DICT_BIZ.REMARK is '字典备注' ; comment on column T_DICT_BIZ.IS_SEALED is '是否已封存' ; comment on column T_DICT_BIZ.IS_DELETED is '是否已删除' ; create table T_DICT ( ID NUMBER(20) not null constraint SYS_C00149813 check ("ID" IS NOT NULL) constraint SYS_C0020115 check ("ID" IS NOT NULL) constraint SYS_C009405 check ("ID" IS NOT NULL), PARENT_ID NUMBER(20), CODE NVARCHAR2(255), DICT_KEY NVARCHAR2(255), DICT_VALUE NVARCHAR2(255), SORT NUMBER(11), REMARK NVARCHAR2(255), IS_SEALED NUMBER(11), IS_DELETED NUMBER(11) ) ; comment on table T_DICT is '字典表' ; comment on column T_DICT.ID is '主键' ; comment on column T_DICT.PARENT_ID is '父主键' ; comment on column T_DICT.CODE is '字典码' ; comment on column T_DICT.DICT_KEY is '字典值' ; comment on column T_DICT.DICT_VALUE is '字典名称' ; comment on column T_DICT.SORT is '排序' ; comment on column T_DICT.REMARK is '字典备注' ; comment on column T_DICT.IS_SEALED is '是否已封存' ; comment on column T_DICT.IS_DELETED is '是否已删除' ; create table T_DESK_MENU ( ID NUMBER(20) not null constraint SYS_C009404 primary key constraint SYS_C009403 check ("ID" IS NOT NULL), MENU_ID VARCHAR2(50), USER_NAME VARCHAR2(50), CREATE_TIME DATE, IS_DELETED NUMBER(1) ) ; comment on column T_DESK_MENU.MENU_ID is '菜单ID' ; comment on column T_DESK_MENU.USER_NAME is '创建者用户名' ; comment on column T_DESK_MENU.CREATE_TIME is '创建时间' ; comment on column T_DESK_MENU.IS_DELETED is '删除标识' ; create table T_CUSTOMIZE_MENU ( ID NUMBER(20) not null constraint SYS_C009400 primary key constraint SYS_C009399 check ("ID" IS NOT NULL), MENU_NAME VARCHAR2(50), MENU_URL VARCHAR2(500), IS_DELETED NUMBER(1) ) ; comment on column T_CUSTOMIZE_MENU.MENU_NAME is '菜单名称' ; comment on column T_CUSTOMIZE_MENU.MENU_URL is '菜单路径' ; comment on column T_CUSTOMIZE_MENU.IS_DELETED is '删除标识' ; create table T_COMPANY_USER ( ID NUMBER not null constraint SYS_C0013492 primary key constraint SYS_C0013490 check ("ID" IS NOT NULL) constraint SYS_C0014688 check ("ID" IS NOT NULL), COMPANY_ID NUMBER(20), GH NVARCHAR2(100), NAME NVARCHAR2(100), MOBILE NVARCHAR2(100), UPDATED_AT DATE, CREATED_AT DATE, STATE NUMBER(11) not null constraint SYS_C0013493 check ("STATE" IS NOT NULL) constraint SYS_C0014689 check ("STATE" IS NOT NULL), USER_ID NUMBER(20) ) ; comment on column T_COMPANY_USER.ID is 'id' ; comment on column T_COMPANY_USER.COMPANY_ID is '所属公司id' ; comment on column T_COMPANY_USER.GH is '工号' ; comment on column T_COMPANY_USER.NAME is '姓名' ; comment on column T_COMPANY_USER.MOBILE is '电话' ; comment on column T_COMPANY_USER.UPDATED_AT is '更新时间' ; comment on column T_COMPANY_USER.CREATED_AT is '创建时间' ; comment on column T_COMPANY_USER.STATE is '状态：0-正常，1-禁用' ; comment on column T_COMPANY_USER.USER_ID is '用户id' ; create table T_COMPANY ( ID NUMBER(20) not null constraint SYS_C0013479 primary key constraint SYS_C0013477 check ("ID" IS NOT NULL) constraint SYS_C0014686 check ("ID" IS NOT NULL), NAME NVARCHAR2(100) not null constraint SYS_C0013478 check ("NAME" IS NOT NULL) constraint SYS_C0014687 check ("NAME" IS NOT NULL), DESCRIPTION NVARCHAR2(200), SORT NUMBER, STATE NUMBER, UPDATED_AT DATE, CREATED_AT DATE ) ; comment on column T_COMPANY.ID is 'id' ; comment on column T_COMPANY.NAME is '公司名称' ; comment on column T_COMPANY.DESCRIPTION is '公司描述' ; comment on column T_COMPANY.SORT is '排序' ; comment on column T_COMPANY.STATE is '状态：0-正常，1-禁用' ; comment on column T_COMPANY.UPDATED_AT is '更新时间' ; comment on column T_COMPANY.CREATED_AT is '创建时间' ; create table T_CLIENT ( ID NUMBER(20) not null constraint SYS_C00149815 check ("ID" IS NOT NULL) constraint SYS_C0020103 check ("ID" IS NOT NULL) constraint SYS_C009390 check ("ID" IS NOT NULL), CLIENT_ID NVARCHAR2(48) not null constraint SYS_C00149816 check ("CLIENT_ID" IS NOT NULL) constraint SYS_C0020104 check ("CLIENT_ID" IS NOT NULL) constraint SYS_C009391 check ("CLIENT_ID" IS NOT NULL), CLIENT_SECRET NVARCHAR2(256) not null constraint SYS_C00149817 check ("CLIENT_SECRET" IS NOT NULL) constraint SYS_C0020105 check ("CLIENT_SECRET" IS NOT NULL) constraint SYS_C009392 check ("CLIENT_SECRET" IS NOT NULL), RESOURCE_IDS NVARCHAR2(256), SCOPE NVARCHAR2(256) not null constraint SYS_C00149818 check ("SCOPE" IS NOT NULL) constraint SYS_C0020106 check ("SCOPE" IS NOT NULL) constraint SYS_C009393 check ("SCOPE" IS NOT NULL), AUTHORIZED_GRANT_TYPES NVARCHAR2(256) not null constraint SYS_C00149819 check ("AUTHORIZED_GRANT_TYPES" IS NOT NULL) constraint SYS_C0020107 check ("AUTHORIZED_GRANT_TYPES" IS NOT NULL) constraint SYS_C009394 check ("AUTHORIZED_GRANT_TYPES" IS NOT NULL), WEB_SERVER_REDIRECT_URI NVARCHAR2(256), AUTHORITIES NVARCHAR2(256), ACCESS_TOKEN_VALIDITY NUMBER(11) not null constraint SYS_C00149820 check ("ACCESS_TOKEN_VALIDITY" IS NOT NULL) constraint SYS_C0020108 check ("ACCESS_TOKEN_VALIDITY" IS NOT NULL) constraint SYS_C009395 check ("ACCESS_TOKEN_VALIDITY" IS NOT NULL), REFRESH_TOKEN_VALIDITY NUMBER(11) not null constraint SYS_C00149821 check ("REFRESH_TOKEN_VALIDITY" IS NOT NULL) constraint SYS_C0020109 check ("REFRESH_TOKEN_VALIDITY" IS NOT NULL) constraint SYS_C009396 check ("REFRESH_TOKEN_VALIDITY" IS NOT NULL), ADDITIONAL_INFORMATION NCLOB, AUTOAPPROVE NVARCHAR2(256), CREATE_USER NUMBER(20), CREATE_DEPT NUMBER(20), CREATE_TIME DATE, UPDATE_USER NUMBER(20), UPDATE_TIME DATE, STATUS NUMBER(11) not null constraint SYS_C00149822 check ("STATUS" IS NOT NULL) constraint SYS_C0020110 check ("STATUS" IS NOT NULL) constraint SYS_C009397 check ("STATUS" IS NOT NULL), IS_DELETED NUMBER(11) not null constraint SYS_C00149823 check ("IS_DELETED" IS NOT NULL) constraint SYS_C0020111 check ("IS_DELETED" IS NOT NULL) constraint SYS_C009398 check ("IS_DELETED" IS NOT NULL), CLIENT_NAME NVARCHAR2(50), TWO_FACTOR_AUTH NVARCHAR2(100), LOGOUT_ADDRESS NVARCHAR2(500), IS_LOGON_CONF NUMBER(1), MODIFY_USER NVARCHAR2(50) ) ; comment on table T_CLIENT is '客户端表' ; comment on column T_CLIENT.ID is '主键' ; comment on column T_CLIENT.CLIENT_ID is '客户端ID' ; comment on column T_CLIENT.CLIENT_SECRET is '客户端密钥' ; comment on column T_CLIENT.RESOURCE_IDS is '资源集合' ; comment on column T_CLIENT.SCOPE is '授权范围' ; comment on column T_CLIENT.AUTHORIZED_GRANT_TYPES is '授权类型' ; comment on column T_CLIENT.WEB_SERVER_REDIRECT_URI is '回调地址' ; comment on column T_CLIENT.AUTHORITIES is '权限' ; comment on column T_CLIENT.ACCESS_TOKEN_VALIDITY is '令牌过期秒数' ; comment on column T_CLIENT.REFRESH_TOKEN_VALIDITY is '刷新令牌过期秒数' ; comment on column T_CLIENT.ADDITIONAL_INFORMATION is '附加说明' ; comment on column T_CLIENT.AUTOAPPROVE is '自动授权' ; comment on column T_CLIENT.CREATE_USER is '创建人' ; comment on column T_CLIENT.CREATE_DEPT is '创建部门' ; comment on column T_CLIENT.CREATE_TIME is '创建时间' ; comment on column T_CLIENT.UPDATE_USER is '修改人' ; comment on column T_CLIENT.UPDATE_TIME is '修改时间' ; comment on column T_CLIENT.STATUS is '状态' ; comment on column T_CLIENT.IS_DELETED is '是否已删除' ; comment on column T_CLIENT.CLIENT_NAME is '应用名称' ; comment on column T_CLIENT.TWO_FACTOR_AUTH is '双因素认证' ; comment on column T_CLIENT.LOGOUT_ADDRESS is '登出地址' ; comment on column T_CLIENT.IS_LOGON_CONF is '登陆可配置 默认0：否 1：是' ; comment on column T_CLIENT.MODIFY_USER is '修改人中文' ; create table T_ATTACH ( ID NUMBER(20) not null constraint SYS_C00149833 check ("ID" IS NOT NULL) constraint SYS_C0020102 check ("ID" IS NOT NULL) constraint SYS_C009389 check ("ID" IS NOT NULL), TENANT_ID NVARCHAR2(12), LINK VARCHAR2(1000), DOMAIN_URL VARCHAR2(500), NAME VARCHAR2(500), ORIGINAL_NAME VARCHAR2(500), EXTENSION VARCHAR2(12), ATTACH_SIZE NUMBER(20), CREATE_USER NUMBER(20), CREATE_DEPT NUMBER(20), CREATE_TIME DATE, UPDATE_USER NUMBER(20), UPDATE_TIME DATE, STATUS NUMBER(11), IS_DELETED NUMBER(11) ) ; comment on table T_ATTACH is '附件表' ; comment on column T_ATTACH.ID is '主键' ; comment on column T_ATTACH.TENANT_ID is '租户ID' ; comment on column T_ATTACH.LINK is '附件地址' ; comment on column T_ATTACH.DOMAIN_URL is '附件域名' ; comment on column T_ATTACH.NAME is '附件名称' ; comment on column T_ATTACH.ORIGINAL_NAME is '附件原名' ; comment on column T_ATTACH.EXTENSION is '附件拓展名' ; comment on column T_ATTACH.ATTACH_SIZE is '附件大小' ; comment on column T_ATTACH.CREATE_USER is '创建人' ; comment on column T_ATTACH.CREATE_DEPT is '创建部门' ; comment on column T_ATTACH.CREATE_TIME is '创建时间' ; comment on column T_ATTACH.UPDATE_USER is '修改人' ; comment on column T_ATTACH.UPDATE_TIME is '修改时间' ; comment on column T_ATTACH.STATUS is '状态' ; comment on column T_ATTACH.IS_DELETED is '是否已删除' ; create table T_APP_VERSION ( ID NVARCHAR2(50) not null constraint SYS_C00158682 check ("ID" IS NOT NULL) constraint SYS_C0020379 check ("ID" IS NOT NULL) constraint SYS_C009387 check ("ID" IS NOT NULL), TYPE NUMBER(1), LATEST_VERSION NVARCHAR2(255), LATEST_APK NVARCHAR2(255), UP_INSTRUCTIONS NVARCHAR2(255), REVISE_DATE DATE, COMMENTS NVARCHAR2(255), APP_ID NVARCHAR2(50), CREATE_USER NVARCHAR2(50), CREATE_TIME DATE, UPDATE_USER NVARCHAR2(50), UPDATE_TIME DATE, CREATE_DEPT NVARCHAR2(50), STATUS NUMBER(1), IS_DELETED NUMBER(1) not null constraint SYS_C00158683 check ("IS_DELETED" IS NOT NULL) constraint SYS_C0020382 check ("IS_DELETED" IS NOT NULL) constraint SYS_C009388 check ("IS_DELETED" IS NOT NULL) ) ; comment on column T_APP_VERSION.TYPE is '0：安卓1：IOS' ; comment on column T_APP_VERSION.LATEST_VERSION is 'app版本' ; comment on column T_APP_VERSION.LATEST_APK is 'app版本地址' ; comment on column T_APP_VERSION.UP_INSTRUCTIONS is '更新版本说明' ; comment on column T_APP_VERSION.REVISE_DATE is '更新时间' ; comment on column T_APP_VERSION.COMMENTS is '备注' ; comment on column T_APP_VERSION.APP_ID is '应用Id' ; comment on column T_APP_VERSION.CREATE_USER is '创建用户' ; comment on column T_APP_VERSION.CREATE_TIME is '创建时间' ; comment on column T_APP_VERSION.UPDATE_USER is '更新用户' ; comment on column T_APP_VERSION.UPDATE_TIME is '更新时间' ; comment on column T_APP_VERSION.CREATE_DEPT is '创建部门' ; comment on column T_APP_VERSION.STATUS is '业务状态' ; comment on column T_APP_VERSION.IS_DELETED is '删除标识' ; create table T_AGENT ( ID VARCHAR2(100), TITLE VARCHAR2(200), START_TIME DATE, START_NAME VARCHAR2(100), EXAMINE_NAME VARCHAR2(100), TYPE VARCHAR2(100), IS_SKIP NUMBER, SKIP_URL VARCHAR2(200), AGENT_START NUMBER, FLOWABLE_ID VARCHAR2(200), START_USER VARCHAR2(50), EXAMINE_USER VARCHAR2(50), TASK_ID VARCHAR2(100), TASK_NAME VARCHAR2(100), SERIAL_NUMBER VARCHAR2(100) ) ; comment on table T_AGENT is '代办事项表' ; comment on column T_AGENT.ID is '主键id' ; comment on column T_AGENT.TITLE is '标题' ; comment on column T_AGENT.START_TIME is '发起时间' ; comment on column T_AGENT.START_NAME is '发起人工号' ; comment on column T_AGENT.EXAMINE_NAME is '审批人工号' ; comment on column T_AGENT.TYPE is '代办类型(0:应用登记审核，1:项目登记审核,2:服务上架审批)' ; comment on column T_AGENT.IS_SKIP is '是否需要跳转0:false,1:true' ; comment on column T_AGENT.SKIP_URL is '跳转链接' ; comment on column T_AGENT.AGENT_START is '代办状态(0:未处理，1:已处理)' ; comment on column T_AGENT.FLOWABLE_ID is '工作流id' ; comment on column T_AGENT.START_USER is '发起人姓名' ; comment on column T_AGENT.EXAMINE_USER is '审批人姓名' ; comment on column T_AGENT.TASK_ID is '任务id' ; comment on column T_AGENT.TASK_NAME is '节点名称' ; comment on column T_AGENT.SERIAL_NUMBER is '流水号' ; create table SYS_TASK_FORM ( ID NUMBER(20) not null constraint SYS_C009306 primary key constraint SYS_C0014670 check ("ID" IS NOT NULL) constraint SYS_C00155935 check ("ID" IS NOT NULL) constraint SYS_C009305 check ("ID" IS NOT NULL), FORM_ID NUMBER(20), TASK_ID NVARCHAR2(50) ) ; comment on table SYS_TASK_FORM is '流程任务关联表单' ; comment on column SYS_TASK_FORM.ID is '主键' ; comment on column SYS_TASK_FORM.FORM_ID is '表单主键' ; comment on column SYS_TASK_FORM.TASK_ID is '所属任务' ; create table SYS_LISTENER ( ID NUMBER(20) not null constraint SYS_C009304 primary key constraint SYS_C0014669 check ("ID" IS NOT NULL) constraint SYS_C00155932 check ("ID" IS NOT NULL) constraint SYS_C009303 check ("ID" IS NOT NULL), NAME NVARCHAR2(128), TYPE NVARCHAR2(32), EVENT_TYPE NVARCHAR2(32), VALUE_TYPE NVARCHAR2(32), VALUE NVARCHAR2(255), CREATE_TIME DATE, UPDATE_TIME DATE, CREATE_USER NUMBER(20), UPDATE_USER NUMBER(20), STATUS NUMBER(4), REMARK NVARCHAR2(255) ) ; comment on table SYS_LISTENER is '流程监听' ; comment on column SYS_LISTENER.ID is '表单主键' ; comment on column SYS_LISTENER.NAME is '名称' ; comment on column SYS_LISTENER.TYPE is '监听类型' ; comment on column SYS_LISTENER.EVENT_TYPE is '事件类型' ; comment on column SYS_LISTENER.VALUE_TYPE is '值类型' ; comment on column SYS_LISTENER.VALUE is '执行内容' ; comment on column SYS_LISTENER.CREATE_TIME is '创建时间' ; comment on column SYS_LISTENER.UPDATE_TIME is '更新时间' ; comment on column SYS_LISTENER.CREATE_USER is '创建人员' ; comment on column SYS_LISTENER.UPDATE_USER is '更新人员' ; comment on column SYS_LISTENER.STATUS is '状态' ; comment on column SYS_LISTENER.REMARK is '备注' ; create table SYS_FORM ( FORM_ID NUMBER(20) not null constraint SYS_C009302 primary key constraint SYS_C0014668 check ("FORM_ID" IS NOT NULL) constraint SYS_C00155934 check ("FORM_ID" IS NOT NULL) constraint SYS_C009301 check ("FORM_ID" IS NOT NULL), FORM_NAME NVARCHAR2(50), FORM_CONTENT NCLOB, CREATE_TIME DATE, UPDATE_TIME DATE, CREATE_USER NUMBER(20), UPDATE_USER NUMBER(20), REMARK NVARCHAR2(255) ) ; comment on table SYS_FORM is '流程表单' ; comment on column SYS_FORM.FORM_ID is '表单主键' ; comment on column SYS_FORM.FORM_NAME is '表单名称' ; comment on column SYS_FORM.FORM_CONTENT is '表单内容' ; comment on column SYS_FORM.CREATE_TIME is '创建时间' ; comment on column SYS_FORM.UPDATE_TIME is '更新时间' ; comment on column SYS_FORM.CREATE_USER is '创建人员' ; comment on column SYS_FORM.UPDATE_USER is '更新人员' ; comment on column SYS_FORM.REMARK is '备注' ; create table SYS_EXPRESSION ( ID NUMBER(20) not null constraint SYS_C009300 primary key constraint SYS_C0014667 check ("ID" IS NOT NULL) constraint SYS_C00155931 check ("ID" IS NOT NULL) constraint SYS_C009299 check ("ID" IS NOT NULL), NAME NVARCHAR2(50), EXPRESSION NVARCHAR2(255), CREATE_TIME DATE, UPDATE_TIME DATE, CREATE_USER NUMBER(20), UPDATE_USER NUMBER(20), STATUS NUMBER(4), REMARK NVARCHAR2(255) ) ; comment on table SYS_EXPRESSION is '流程表达式' ; comment on column SYS_EXPRESSION.ID is '表单主键' ; comment on column SYS_EXPRESSION.NAME is '表达式名称' ; comment on column SYS_EXPRESSION.EXPRESSION is '表达式内容' ; comment on column SYS_EXPRESSION.CREATE_TIME is '创建时间' ; comment on column SYS_EXPRESSION.UPDATE_TIME is '更新时间' ; comment on column SYS_EXPRESSION.CREATE_USER is '创建人员' ; comment on column SYS_EXPRESSION.UPDATE_USER is '更新人员' ; comment on column SYS_EXPRESSION.STATUS is '状态' ; comment on column SYS_EXPRESSION.REMARK is '备注' ; create table SYS_DEPLOY_FORM ( ID NUMBER(20) not null constraint SYS_C009294 primary key constraint SYS_C0014661 check ("ID" IS NOT NULL) constraint SYS_C00155933 check ("ID" IS NOT NULL) constraint SYS_C009293 check ("ID" IS NOT NULL), FORM_ID NUMBER(20), DEPLOY_ID NVARCHAR2(50) ) ; comment on table SYS_DEPLOY_FORM is '流程实例关联表单' ; comment on column SYS_DEPLOY_FORM.ID is '主键' ; comment on column SYS_DEPLOY_FORM.FORM_ID is '表单主键' ; comment on column SYS_DEPLOY_FORM.DEPLOY_ID is '流程实例主键' ; create table R_SYS_USER_ROLE ( USER_ID NUMBER, ROLE_ID NUMBER ) ; comment on table R_SYS_USER_ROLE is '系统管理-用户角色关联表' ; comment on column R_SYS_USER_ROLE.USER_ID is '用户表id' ; comment on column R_SYS_USER_ROLE.ROLE_ID is '角色表id' ; create table R_SYS_USER_INDIVIDUAL ( ID NUMBER not null constraint SYS_C009292 primary key constraint SYS_C0014601 check ("ID" IS NOT NULL) constraint SYS_C009291 check ("ID" IS NOT NULL), USER_ID NUMBER, PATH VARCHAR2(255), INDIVIDUA_NAME VARCHAR2(255) ) ; comment on column R_SYS_USER_INDIVIDUAL.ID is '主键' ; comment on column R_SYS_USER_INDIVIDUAL.USER_ID is '用户id' ; comment on column R_SYS_USER_INDIVIDUAL.PATH is '路径' ; comment on column R_SYS_USER_INDIVIDUAL.INDIVIDUA_NAME is '名称' ; create table R_SYS_USER_APP ( USER_ID NUMBER, APP_ID NUMBER ) ; comment on table R_SYS_USER_APP is '用户应用关联表' ; comment on column R_SYS_USER_APP.USER_ID is '用户Id' ; comment on column R_SYS_USER_APP.APP_ID is '应用Id' ; create table R_SYS_ROLE_MENU ( ROLE_ID NUMBER(20), MENU_ID NUMBER(20) ) ; comment on table R_SYS_ROLE_MENU is '系统管理-角色菜单关联表' ; comment on column R_SYS_ROLE_MENU.ROLE_ID is '角色表id' ; comment on column R_SYS_ROLE_MENU.MENU_ID is '菜单表id' ; create table R_SYS_DEPT_ROLE ( DEPT_ID NUMBER, ROLE_ID NUMBER ) ; comment on table R_SYS_DEPT_ROLE is '系统管理-部门角色关联表' ; comment on column R_SYS_DEPT_ROLE.DEPT_ID is '部门表id' ; comment on column R_SYS_DEPT_ROLE.ROLE_ID is '角色表id' ; create table R_SYS_DEPT_PORT_AREA ( DEPT_ID NVARCHAR2(20) not null constraint SYS_C0014156 check ("DEPT_ID" IS NOT NULL) constraint SYS_C0014598 check ("DEPT_ID" IS NOT NULL), PORT_AREA_ID NVARCHAR2(20) not null constraint SYS_C0014157 check ("PORT_AREA_ID" IS NOT NULL) constraint SYS_C0014599 check ("PORT_AREA_ID" IS NOT NULL) ) ; comment on column R_SYS_DEPT_PORT_AREA.DEPT_ID is '部门ID' ; comment on column R_SYS_DEPT_PORT_AREA.PORT_AREA_ID is '港区ID' ; create table QDPORT_WF_SERIAL ( ID NUMBER(20) not null constraint SYS_C0012685 check ("ID" IS NOT NULL) constraint SYS_C0015812 check ("ID" IS NOT NULL), DEPLOYMENT_ID NVARCHAR2(255), NAME NVARCHAR2(255), PREFIX NVARCHAR2(255), DATE_FORMAT NVARCHAR2(255), SUFFIX_LENGTH NUMBER(11), START_SEQUENCE NUMBER(11), CONNECTOR NVARCHAR2(255), CURRENT_SEQUENCE NUMBER(11), CYCLE NVARCHAR2(255), CREATE_USER NUMBER(20), CREATE_DEPT NUMBER(20), CREATE_TIME DATE, UPDATE_USER NUMBER(20), UPDATE_TIME DATE, STATUS NVARCHAR2(255), IS_DELETED NUMBER(11) ) ; comment on table QDPORT_WF_SERIAL is '流程流水号' ; comment on column QDPORT_WF_SERIAL.DEPLOYMENT_ID is '部署id' ; comment on column QDPORT_WF_SERIAL.NAME is '名称' ; comment on column QDPORT_WF_SERIAL.PREFIX is '前缀' ; comment on column QDPORT_WF_SERIAL.DATE_FORMAT is '日期格式化' ; comment on column QDPORT_WF_SERIAL.SUFFIX_LENGTH is '后缀位数' ; comment on column QDPORT_WF_SERIAL.START_SEQUENCE is '初始数值' ; comment on column QDPORT_WF_SERIAL.CONNECTOR is '连接符' ; comment on column QDPORT_WF_SERIAL.CURRENT_SEQUENCE is '当前序列' ; comment on column QDPORT_WF_SERIAL.CYCLE is '重置周期 none不重置 day天 week周 month月 year年' ; comment on column QDPORT_WF_SERIAL.CREATE_USER is '创建人' ; comment on column QDPORT_WF_SERIAL.CREATE_DEPT is '创建部门' ; comment on column QDPORT_WF_SERIAL.CREATE_TIME is '创建时间' ; comment on column QDPORT_WF_SERIAL.UPDATE_USER is '修改人' ; comment on column QDPORT_WF_SERIAL.UPDATE_TIME is '修改时间' ; comment on column QDPORT_WF_SERIAL.STATUS is '状态' ; comment on column QDPORT_WF_SERIAL.IS_DELETED is '是否已删除' ; create table QDPORT_WF_PROXY ( ID NUMBER(20) not null constraint SYS_C0012684 check ("ID" IS NOT NULL) constraint SYS_C0015810 check ("ID" IS NOT NULL), USER_ID NUMBER(20), PROXY_USER_ID NUMBER(20), PROCESS_DEF_KEY NVARCHAR2(750), TYPE NVARCHAR2(255), START_TIME DATE, END_TIME DATE, STATUS NUMBER(11) ) ; comment on table QDPORT_WF_PROXY is '流程代理' ; comment on column QDPORT_WF_PROXY.USER_ID is '委托人' ; comment on column QDPORT_WF_PROXY.PROXY_USER_ID is '代理人' ; comment on column QDPORT_WF_PROXY.PROCESS_DEF_KEY is '流程定义key' ; comment on column QDPORT_WF_PROXY.TYPE is '1永久 2定时' ; comment on column QDPORT_WF_PROXY.START_TIME is '开始时间' ; comment on column QDPORT_WF_PROXY.END_TIME is '结束时间' ; comment on column QDPORT_WF_PROXY.STATUS is '状态' ; create table QDPORT_WF_PROCESS_LEAVE ( ID NUMBER(20) not null constraint SYS_C0012682 check ("ID" IS NOT NULL) constraint SYS_C0015806 check ("ID" IS NOT NULL), PROCESS_INS_ID NVARCHAR2(64), PROCESS_DEF_ID NVARCHAR2(64), CURRENT_NODE NVARCHAR2(64), DATETIME NVARCHAR2(64), DAYS NUMBER(11), REASON NCLOB, ATTACHMENT NCLOB, CREATE_USER NUMBER(20), CREATE_DEPT NUMBER(20), CREATE_TIME DATE not null constraint SYS_C0012683 check ("CREATE_TIME" IS NOT NULL) constraint SYS_C0015807 check ("CREATE_TIME" IS NOT NULL), UPDATE_USER NUMBER(20), UPDATE_TIME DATE, STATUS NUMBER(11), IS_DELETED NUMBER(11) default 0, FORM_KEY VARCHAR2(255), FORM_URL VARCHAR2(255) ) ; comment on table QDPORT_WF_PROCESS_LEAVE is '请假流程业务示例' ; comment on column QDPORT_WF_PROCESS_LEAVE.PROCESS_INS_ID is '流程实例id' ; comment on column QDPORT_WF_PROCESS_LEAVE.PROCESS_DEF_ID is '流程定义id' ; comment on column QDPORT_WF_PROCESS_LEAVE.CURRENT_NODE is '当前节点' ; comment on column QDPORT_WF_PROCESS_LEAVE.DATETIME is '时间范围' ; comment on column QDPORT_WF_PROCESS_LEAVE.DAYS is '请假天数' ; comment on column QDPORT_WF_PROCESS_LEAVE.REASON is '请假理由' ; comment on column QDPORT_WF_PROCESS_LEAVE.ATTACHMENT is '附件' ; comment on column QDPORT_WF_PROCESS_LEAVE.CREATE_USER is '创建人' ; comment on column QDPORT_WF_PROCESS_LEAVE.CREATE_DEPT is '创建部门' ; comment on column QDPORT_WF_PROCESS_LEAVE.CREATE_TIME is '创建时间' ; comment on column QDPORT_WF_PROCESS_LEAVE.UPDATE_USER is '修改人' ; comment on column QDPORT_WF_PROCESS_LEAVE.UPDATE_TIME is '修改时间' ; comment on column QDPORT_WF_PROCESS_LEAVE.STATUS is '状态' ; comment on column QDPORT_WF_PROCESS_LEAVE.IS_DELETED is '是否已删除' ; comment on column QDPORT_WF_PROCESS_LEAVE.FORM_KEY is '外置表单key' ; comment on column QDPORT_WF_PROCESS_LEAVE.FORM_URL is '外置表单url' ; create table QDPORT_WF_MODEL_SCOPE ( ID NUMBER(20) not null constraint SYS_C0012681 check ("ID" IS NOT NULL) constraint SYS_C0015804 check ("ID" IS NOT NULL), MODEL_ID NVARCHAR2(255), MODEL_KEY NVARCHAR2(255), TYPE NVARCHAR2(255), VAL NVARCHAR2(255), TEXT NVARCHAR2(255) ) ; comment on table QDPORT_WF_MODEL_SCOPE is '流程模型权限' ; comment on column QDPORT_WF_MODEL_SCOPE.MODEL_ID is '模型id' ; comment on column QDPORT_WF_MODEL_SCOPE.MODEL_KEY is '模型key' ; comment on column QDPORT_WF_MODEL_SCOPE.TYPE is '类型 user用户 role角色 dept部门 post职位' ; comment on column QDPORT_WF_MODEL_SCOPE.VAL is '用户;角色;部门;职位 id集合' ; comment on column QDPORT_WF_MODEL_SCOPE.TEXT is '用户;角色;部门;职位 name集合' ; create table QDPORT_WF_FORM_HISTORY ( ID NUMBER(20) not null constraint SYS_C0012680 check ("ID" IS NOT NULL) constraint SYS_C0015802 check ("ID" IS NOT NULL), FORM_ID NUMBER(20), FORM_KEY NVARCHAR2(255), NAME NVARCHAR2(255), CONTENT NCLOB, APP_CONTENT NCLOB, VERSION NUMBER(11), CATEGORY_ID NUMBER(20), REMARK NVARCHAR2(255), CREATE_USER NUMBER(20), CREATE_DEPT NUMBER(20), CREATE_TIME DATE, UPDATE_USER NUMBER(20), UPDATE_TIME DATE, STATUS NUMBER(11), IS_DELETED NUMBER(11) ) ; comment on table QDPORT_WF_FORM_HISTORY is '流程表单' ; comment on column QDPORT_WF_FORM_HISTORY.FORM_ID is '表单id' ; comment on column QDPORT_WF_FORM_HISTORY.FORM_KEY is '表单key' ; comment on column QDPORT_WF_FORM_HISTORY.NAME is '表单名称' ; comment on column QDPORT_WF_FORM_HISTORY.CONTENT is '表单内容' ; comment on column QDPORT_WF_FORM_HISTORY.APP_CONTENT is 'app表单内容' ; comment on column QDPORT_WF_FORM_HISTORY.VERSION is '版本' ; comment on column QDPORT_WF_FORM_HISTORY.CATEGORY_ID is '分类id' ; comment on column QDPORT_WF_FORM_HISTORY.REMARK is '备注' ; comment on column QDPORT_WF_FORM_HISTORY.CREATE_USER is '创建人' ; comment on column QDPORT_WF_FORM_HISTORY.CREATE_DEPT is '创建部门' ; comment on column QDPORT_WF_FORM_HISTORY.CREATE_TIME is '创建时间' ; comment on column QDPORT_WF_FORM_HISTORY.UPDATE_USER is '修改人' ; comment on column QDPORT_WF_FORM_HISTORY.UPDATE_TIME is '修改时间' ; comment on column QDPORT_WF_FORM_HISTORY.STATUS is '状态' ; comment on column QDPORT_WF_FORM_HISTORY.IS_DELETED is '是否已删除' ; create table QDPORT_WF_FORM_DEFAULT_VALUES ( ID NUMBER(20) not null constraint SYS_C0012679 check ("ID" IS NOT NULL) constraint SYS_C0015800 check ("ID" IS NOT NULL), NAME NVARCHAR2(255), CONTENT NVARCHAR2(255), FIELD_TYPE NVARCHAR2(255), CREATE_USER NUMBER(20), CREATE_DEPT NUMBER(20), CREATE_TIME DATE, UPDATE_USER NUMBER(20), UPDATE_TIME DATE, STATUS NVARCHAR2(255), IS_DELETED NUMBER(11), TENANT_ID NVARCHAR2(12) ) ; comment on table QDPORT_WF_FORM_DEFAULT_VALUES is '流程表单字段默认值' ; comment on column QDPORT_WF_FORM_DEFAULT_VALUES.NAME is '名称' ; comment on column QDPORT_WF_FORM_DEFAULT_VALUES.CONTENT is '内容' ; comment on column QDPORT_WF_FORM_DEFAULT_VALUES.FIELD_TYPE is '字段类型' ; comment on column QDPORT_WF_FORM_DEFAULT_VALUES.CREATE_USER is '创建人' ; comment on column QDPORT_WF_FORM_DEFAULT_VALUES.CREATE_DEPT is '创建部门' ; comment on column QDPORT_WF_FORM_DEFAULT_VALUES.CREATE_TIME is '创建时间' ; comment on column QDPORT_WF_FORM_DEFAULT_VALUES.UPDATE_USER is '修改人' ; comment on column QDPORT_WF_FORM_DEFAULT_VALUES.UPDATE_TIME is '修改时间' ; comment on column QDPORT_WF_FORM_DEFAULT_VALUES.STATUS is '状态' ; comment on column QDPORT_WF_FORM_DEFAULT_VALUES.IS_DELETED is '是否已删除' ; comment on column QDPORT_WF_FORM_DEFAULT_VALUES.TENANT_ID is '租户ID' ; create table QDPORT_WF_FORM ( ID NUMBER(20) not null constraint SYS_C0012678 check ("ID" IS NOT NULL) constraint SYS_C0015798 check ("ID" IS NOT NULL), FORM_KEY NVARCHAR2(255), NAME NVARCHAR2(255), CONTENT NCLOB, APP_CONTENT NCLOB, VERSION NUMBER(11), CATEGORY_ID NUMBER(20), REMARK NVARCHAR2(255), CREATE_USER NUMBER(20), CREATE_DEPT NUMBER(20), CREATE_TIME DATE, UPDATE_USER NUMBER(20), UPDATE_TIME DATE, STATUS NUMBER(11), IS_DELETED NUMBER(11), TENANT_ID NVARCHAR2(12) ) ; comment on table QDPORT_WF_FORM is '流程表单' ; comment on column QDPORT_WF_FORM.FORM_KEY is '表单key' ; comment on column QDPORT_WF_FORM.NAME is '表单名称' ; comment on column QDPORT_WF_FORM.CONTENT is '表单内容' ; comment on column QDPORT_WF_FORM.APP_CONTENT is 'app表单内容' ; comment on column QDPORT_WF_FORM.VERSION is '版本' ; comment on column QDPORT_WF_FORM.CATEGORY_ID is '分类id' ; comment on column QDPORT_WF_FORM.REMARK is '备注' ; comment on column QDPORT_WF_FORM.CREATE_USER is '创建人' ; comment on column QDPORT_WF_FORM.CREATE_DEPT is '创建部门' ; comment on column QDPORT_WF_FORM.CREATE_TIME is '创建时间' ; comment on column QDPORT_WF_FORM.UPDATE_USER is '修改人' ; comment on column QDPORT_WF_FORM.UPDATE_TIME is '修改时间' ; comment on column QDPORT_WF_FORM.STATUS is '状态' ; comment on column QDPORT_WF_FORM.IS_DELETED is '是否已删除' ; comment on column QDPORT_WF_FORM.TENANT_ID is '租户ID' ; create table QDPORT_WF_DRAFT ( ID NUMBER(20) not null constraint SYS_C0012677 check ("ID" IS NOT NULL) constraint SYS_C0015796 check ("ID" IS NOT NULL), USER_ID NUMBER(20), FORM_KEY NVARCHAR2(255), PROCESS_DEF_ID NVARCHAR2(255), VARIABLES NCLOB, PLATFORM NVARCHAR2(255) ) ; comment on table QDPORT_WF_DRAFT is '流程草稿箱' ; comment on column QDPORT_WF_DRAFT.USER_ID is '用户id' ; comment on column QDPORT_WF_DRAFT.FORM_KEY is '表单key' ; comment on column QDPORT_WF_DRAFT.PROCESS_DEF_ID is '流程定义id' ; comment on column QDPORT_WF_DRAFT.VARIABLES is '表单变量' ; comment on column QDPORT_WF_DRAFT.PLATFORM is '平台 pc;app' ; create table QDPORT_WF_DEPLOYMENT_FORM ( ID NUMBER(20) not null constraint SYS_C0012676 check ("ID" IS NOT NULL) constraint SYS_C0015794 check ("ID" IS NOT NULL), DEPLOYMENT_ID NVARCHAR2(255), FORM_KEY NVARCHAR2(255), CONTENT NCLOB, APP_CONTENT NCLOB, TASK_KEY NVARCHAR2(255), TASK_NAME NVARCHAR2(255), CREATE_USER NUMBER(20), CREATE_DEPT NUMBER(20), CREATE_TIME DATE, UPDATE_USER NUMBER(20), UPDATE_TIME DATE, STATUS NVARCHAR2(255), IS_DELETED NUMBER(11) default 0 ) ; comment on table QDPORT_WF_DEPLOYMENT_FORM is '流程部署 - 表单' ; comment on column QDPORT_WF_DEPLOYMENT_FORM.DEPLOYMENT_ID is '流程部署id' ; comment on column QDPORT_WF_DEPLOYMENT_FORM.FORM_KEY is '表单key' ; comment on column QDPORT_WF_DEPLOYMENT_FORM.CONTENT is '表单内容' ; comment on column QDPORT_WF_DEPLOYMENT_FORM.APP_CONTENT is 'app表单内容' ; comment on column QDPORT_WF_DEPLOYMENT_FORM.TASK_KEY is '节点key' ; comment on column QDPORT_WF_DEPLOYMENT_FORM.TASK_NAME is '节点名称' ; comment on column QDPORT_WF_DEPLOYMENT_FORM.CREATE_USER is '创建人' ; comment on column QDPORT_WF_DEPLOYMENT_FORM.CREATE_DEPT is '创建部门' ; comment on column QDPORT_WF_DEPLOYMENT_FORM.CREATE_TIME is '创建时间' ; comment on column QDPORT_WF_DEPLOYMENT_FORM.UPDATE_USER is '修改人' ; comment on column QDPORT_WF_DEPLOYMENT_FORM.UPDATE_TIME is '修改时间' ; comment on column QDPORT_WF_DEPLOYMENT_FORM.STATUS is '状态' ; comment on column QDPORT_WF_DEPLOYMENT_FORM.IS_DELETED is '是否已删除' ; create table QDPORT_WF_COPY ( ID NUMBER(20) not null constraint SYS_C0012675 check ("ID" IS NOT NULL) constraint SYS_C0015792 check ("ID" IS NOT NULL), USER_ID NUMBER(20), TITLE NVARCHAR2(255), INITIATOR NVARCHAR2(255), TASK_ID NVARCHAR2(255), PROCESS_ID NVARCHAR2(255), FORM_KEY NVARCHAR2(255), FORM_URL NVARCHAR2(255), CREATE_USER NUMBER(20), CREATE_DEPT NUMBER(20), CREATE_TIME DATE, UPDATE_USER NUMBER(20), UPDATE_TIME DATE, STATUS NVARCHAR2(255), IS_DELETED NUMBER(11) ) ; comment on table QDPORT_WF_COPY is '流程抄送' ; comment on column QDPORT_WF_COPY.USER_ID is '用户id' ; comment on column QDPORT_WF_COPY.TITLE is '标题' ; comment on column QDPORT_WF_COPY.INITIATOR is '发起者' ; comment on column QDPORT_WF_COPY.TASK_ID is '任务id' ; comment on column QDPORT_WF_COPY.PROCESS_ID is '流程实例id' ; comment on column QDPORT_WF_COPY.FORM_KEY is '外置表单key' ; comment on column QDPORT_WF_COPY.FORM_URL is '外置表单url' ; comment on column QDPORT_WF_COPY.CREATE_USER is '创建人' ; comment on column QDPORT_WF_COPY.CREATE_DEPT is '创建部门' ; comment on column QDPORT_WF_COPY.CREATE_TIME is '创建时间' ; comment on column QDPORT_WF_COPY.UPDATE_USER is '修改人' ; comment on column QDPORT_WF_COPY.UPDATE_TIME is '修改时间' ; comment on column QDPORT_WF_COPY.STATUS is '状态' ; comment on column QDPORT_WF_COPY.IS_DELETED is '是否已删除' ; create table QDPORT_WF_CONDITION ( ID NUMBER(20) not null constraint SYS_C0012674 check ("ID" IS NOT NULL) constraint SYS_C0015790 check ("ID" IS NOT NULL), NAME NVARCHAR2(255), EXPRESSION NVARCHAR2(255), TYPE NVARCHAR2(255), CREATE_USER NUMBER(20), CREATE_DEPT NUMBER(20), CREATE_TIME DATE, UPDATE_USER NUMBER(20), UPDATE_TIME DATE, STATUS NVARCHAR2(255), IS_DELETED NUMBER(11), TENANT_ID NVARCHAR2(12) ) ; comment on table QDPORT_WF_CONDITION is '流程表达式' ; comment on column QDPORT_WF_CONDITION.NAME is '名称' ; comment on column QDPORT_WF_CONDITION.EXPRESSION is '表达式' ; comment on column QDPORT_WF_CONDITION.TYPE is '类型' ; comment on column QDPORT_WF_CONDITION.CREATE_USER is '创建人' ; comment on column QDPORT_WF_CONDITION.CREATE_DEPT is '创建部门' ; comment on column QDPORT_WF_CONDITION.CREATE_TIME is '创建时间' ; comment on column QDPORT_WF_CONDITION.UPDATE_USER is '修改人' ; comment on column QDPORT_WF_CONDITION.UPDATE_TIME is '修改时间' ; comment on column QDPORT_WF_CONDITION.STATUS is '状态' ; comment on column QDPORT_WF_CONDITION.IS_DELETED is '是否已删除' ; comment on column QDPORT_WF_CONDITION.TENANT_ID is '租户ID' ; create table QDPORT_WF_CATEGORY ( ID NUMBER(20) not null constraint SYS_C0012673 check ("ID" IS NOT NULL) constraint SYS_C0015788 check ("ID" IS NOT NULL), NAME NVARCHAR2(255), PID NUMBER(20) default 0, SORT NUMBER(11), CREATE_USER NUMBER(20), CREATE_DEPT NUMBER(20), CREATE_TIME DATE, UPDATE_USER NUMBER(20), UPDATE_TIME DATE, STATUS NVARCHAR2(255), IS_DELETED NUMBER(11), TENANT_ID NVARCHAR2(12) ) ; comment on table QDPORT_WF_CATEGORY is '流程分类' ; comment on column QDPORT_WF_CATEGORY.NAME is '分类名称' ; comment on column QDPORT_WF_CATEGORY.PID is '上级id' ; comment on column QDPORT_WF_CATEGORY.SORT is '排序' ; comment on column QDPORT_WF_CATEGORY.CREATE_USER is '创建人' ; comment on column QDPORT_WF_CATEGORY.CREATE_DEPT is '创建部门' ; comment on column QDPORT_WF_CATEGORY.CREATE_TIME is '创建时间' ; comment on column QDPORT_WF_CATEGORY.UPDATE_USER is '修改人' ; comment on column QDPORT_WF_CATEGORY.UPDATE_TIME is '修改时间' ; comment on column QDPORT_WF_CATEGORY.STATUS is '状态' ; comment on column QDPORT_WF_CATEGORY.IS_DELETED is '是否已删除' ; comment on column QDPORT_WF_CATEGORY.TENANT_ID is '租户ID' ; create table QDPORT_WF_BUTTON ( ID NUMBER(20) not null constraint SYS_C0012672 check ("ID" IS NOT NULL) constraint SYS_C0015786 check ("ID" IS NOT NULL), BUTTON_KEY NVARCHAR2(255), NAME NVARCHAR2(255), DISPLAY NUMBER(4), SORT NUMBER(11), CREATE_USER NUMBER(20), CREATE_DEPT NUMBER(20), CREATE_TIME DATE, UPDATE_USER NUMBER(20), UPDATE_TIME DATE, STATUS NVARCHAR2(255), IS_DELETED NUMBER(11) default 0, TENANT_ID NVARCHAR2(12) default '000000' ) ; comment on table QDPORT_WF_BUTTON is '流程按钮' ; comment on column QDPORT_WF_BUTTON.BUTTON_KEY is '按钮key' ; comment on column QDPORT_WF_BUTTON.NAME is '名称' ; comment on column QDPORT_WF_BUTTON.DISPLAY is '默认是否显示' ; comment on column QDPORT_WF_BUTTON.SORT is '排序' ; comment on column QDPORT_WF_BUTTON.CREATE_USER is '创建人' ; comment on column QDPORT_WF_BUTTON.CREATE_DEPT is '创建部门' ; comment on column QDPORT_WF_BUTTON.CREATE_TIME is '创建时间' ; comment on column QDPORT_WF_BUTTON.UPDATE_USER is '修改人' ; comment on column QDPORT_WF_BUTTON.UPDATE_TIME is '修改时间' ; comment on column QDPORT_WF_BUTTON.STATUS is '状态' ; comment on column QDPORT_WF_BUTTON.IS_DELETED is '是否已删除' ; comment on column QDPORT_WF_BUTTON.TENANT_ID is '租户ID' ; create table GRID_INFO ( ID NUMBER(20) not null primary key, ROUTING_ADDRESS VARCHAR2(100), PRIORITY NUMBER(10), REMARK VARCHAR2(50) default NULL, CREATE_TIME TIMESTAMP(6) default NULL, CREATE_USER_ID VARCHAR2(50) default NULL, CREATE_USER_NAME VARCHAR2(50) default NULL, UPDATE_TIME TIMESTAMP(6) default NULL, UPDATE_USER_ID VARCHAR2(50) default NULL, UPDATE_USER_NAME VARCHAR2(50) default NULL ) ; comment on table GRID_INFO is 'GRID基础信息' ; comment on column GRID_INFO.ID is '表单主键' ; comment on column GRID_INFO.ROUTING_ADDRESS is '路由地址' ; comment on column GRID_INFO.PRIORITY is '优先级（根据等级选择1用户0管理员）' ; comment on column GRID_INFO.REMARK is '备注' ; comment on column GRID_INFO.CREATE_TIME is '创建时间' ; comment on column GRID_INFO.CREATE_USER_ID is '创建人' ; comment on column GRID_INFO.CREATE_USER_NAME is '创建人' ; comment on column GRID_INFO.UPDATE_TIME is '修改时间' ; comment on column GRID_INFO.UPDATE_USER_ID is '修改人id' ; comment on column GRID_INFO.UPDATE_USER_NAME is '修改人姓名' ; create table GRID_FOUNDATION ( ID NUMBER(20) not null primary key, GRID_ID NUMBER(20), FIELD_PROPERTIES VARCHAR2(50), FIELD_NAME VARCHAR2(50), FIELD_SORT CHAR(2), FIELD_HIDE CHAR(2), FIELD_FREEZE CHAR(2), FIELD_WIDTH NUMBER, FIELD_ORDER NUMBER, REMARK VARCHAR2(50) default NULL, CREATE_TIME TIMESTAMP(6) default NULL, CREATE_USER_ID VARCHAR2(50) default NULL, CREATE_USER_NAME VARCHAR2(50) default NULL, UPDATE_TIME TIMESTAMP(6) default NULL, UPDATE_USER_ID VARCHAR2(50) default NULL, UPDATE_USER_NAME VARCHAR2(50) default NULL ) ; comment on table GRID_FOUNDATION is 'GRID详细信息' ; comment on column GRID_FOUNDATION.ID is '表单主键' ; comment on column GRID_FOUNDATION.GRID_ID is '外键' ; comment on column GRID_FOUNDATION.FIELD_PROPERTIES is '字段属性' ; comment on column GRID_FOUNDATION.FIELD_NAME is '字段名称' ; comment on column GRID_FOUNDATION.FIELD_SORT is '排序（1是0否）' ; comment on column GRID_FOUNDATION.FIELD_HIDE is '隐藏（1是0否）' ; comment on column GRID_FOUNDATION.FIELD_FREEZE is '冻结（1是0否）' ; comment on column GRID_FOUNDATION.FIELD_WIDTH is '宽度' ; comment on column GRID_FOUNDATION.FIELD_ORDER is '顺序' ; comment on column GRID_FOUNDATION.REMARK is '备注' ; comment on column GRID_FOUNDATION.CREATE_TIME is '创建时间' ; comment on column GRID_FOUNDATION.CREATE_USER_ID is '创建人' ; comment on column GRID_FOUNDATION.CREATE_USER_NAME is '创建人' ; comment on column GRID_FOUNDATION.UPDATE_TIME is '修改时间' ; comment on column GRID_FOUNDATION.UPDATE_USER_ID is '修改人id' ; comment on column GRID_FOUNDATION.UPDATE_USER_NAME is '修改人姓名' ; create table GEN_TABLE_FIELD ( ID NUMBER(20) default "GEN_TABLE_FIELD_SEQ"."NEXTVAL" not null constraint SYS_C0010995 primary key constraint SYS_C0010994 check ("ID" IS NOT NULL) constraint SYS_C0014527 check ("ID" IS NOT NULL), TABLE_ID NUMBER(20), FIELD_NAME VARCHAR2(200), FIELD_TYPE VARCHAR2(200), FIELD_COMMENT VARCHAR2(200), ATTR_NAME VARCHAR2(200), ATTR_TYPE VARCHAR2(200), PACKAGE_NAME VARCHAR2(200), SORT NUMBER(10), AUTO_FILL VARCHAR2(20), PRIMARY_PK NUMBER(2), BASE_FIELD NUMBER(2), FORM_ITEM NUMBER(2), FORM_REQUIRED NUMBER(2), FORM_TYPE VARCHAR2(200), FORM_DICT VARCHAR2(200), FORM_VALIDATOR VARCHAR2(200), GRID_ITEM NUMBER(2), GRID_SORT NUMBER(2), QUERY_ITEM NUMBER(2), QUERY_TYPE VARCHAR2(200), QUERY_FORM_TYPE VARCHAR2(200) ) ; comment on table GEN_TABLE_FIELD is '代码生成表字段' ; comment on column GEN_TABLE_FIELD.ID is 'id' ; comment on column GEN_TABLE_FIELD.TABLE_ID is '表ID' ; comment on column GEN_TABLE_FIELD.FIELD_NAME is '字段名称' ; comment on column GEN_TABLE_FIELD.FIELD_TYPE is '字段类型' ; comment on column GEN_TABLE_FIELD.FIELD_COMMENT is '字段说明' ; comment on column GEN_TABLE_FIELD.ATTR_NAME is '属性名' ; comment on column GEN_TABLE_FIELD.ATTR_TYPE is '属性类型' ; comment on column GEN_TABLE_FIELD.PACKAGE_NAME is '属性包名' ; comment on column GEN_TABLE_FIELD.SORT is '排序' ; comment on column GEN_TABLE_FIELD.AUTO_FILL is '自动填充 DEFAULT、INSERT、UPDATE、INSERT_UPDATE' ; comment on column GEN_TABLE_FIELD.PRIMARY_PK is '主键 0：否 1：是' ; comment on column GEN_TABLE_FIELD.BASE_FIELD is '基类字段 0：否 1：是' ; comment on column GEN_TABLE_FIELD.FORM_ITEM is '表单项 0：否 1：是' ; comment on column GEN_TABLE_FIELD.FORM_REQUIRED is '表单必填 0：否 1：是' ; comment on column GEN_TABLE_FIELD.FORM_TYPE is '表单类型' ; comment on column GEN_TABLE_FIELD.FORM_DICT is '表单字典类型' ; comment on column GEN_TABLE_FIELD.FORM_VALIDATOR is '表单效验' ; comment on column GEN_TABLE_FIELD.GRID_ITEM is '列表项 0：否 1：是' ; comment on column GEN_TABLE_FIELD.GRID_SORT is '列表排序 0：否 1：是' ; comment on column GEN_TABLE_FIELD.QUERY_ITEM is '查询项 0：否 1：是' ; comment on column GEN_TABLE_FIELD.QUERY_TYPE is '查询方式' ; comment on column GEN_TABLE_FIELD.QUERY_FORM_TYPE is '查询表单类型' ; create table GEN_TABLE ( ID NUMBER(20) default "GEN_TABLE_SEQ"."NEXTVAL" not null constraint SYS_C0010993 primary key constraint SYS_C0010992 check ("ID" IS NOT NULL) constraint SYS_C0014526 check ("ID" IS NOT NULL), TABLE_NAME VARCHAR2(200), CLASS_NAME VARCHAR2(200), TABLE_COMMENT VARCHAR2(200), AUTHOR VARCHAR2(200), EMAIL VARCHAR2(200), PACKAGE_NAME VARCHAR2(200), VERSION VARCHAR2(200), GENERATOR_TYPE NUMBER(2), BACKEND_PATH VARCHAR2(500), FRONTEND_PATH VARCHAR2(500), MODULE_NAME VARCHAR2(200), FUNCTION_NAME VARCHAR2(200), FORM_LAYOUT NUMBER(2), DATASOURCE_ID NUMBER(20), BASECLASS_ID NUMBER(20), CREATE_TIME DATE ) ; comment on table GEN_TABLE is '代码生成表' ; comment on column GEN_TABLE.ID is 'id' ; comment on column GEN_TABLE.TABLE_NAME is '表名' ; comment on column GEN_TABLE.CLASS_NAME is '类名' ; comment on column GEN_TABLE.TABLE_COMMENT is '说明' ; comment on column GEN_TABLE.AUTHOR is '作者' ; comment on column GEN_TABLE.EMAIL is '邮箱' ; comment on column GEN_TABLE.PACKAGE_NAME is '项目包名' ; comment on column GEN_TABLE.VERSION is '项目版本号' ; comment on column GEN_TABLE.GENERATOR_TYPE is '生成方式 0：zip压缩包 1：自定义目录' ; comment on column GEN_TABLE.BACKEND_PATH is '后端生成路径' ; comment on column GEN_TABLE.FRONTEND_PATH is '前端生成路径' ; comment on column GEN_TABLE.MODULE_NAME is '模块名' ; comment on column GEN_TABLE.FUNCTION_NAME is '功能名' ; comment on column GEN_TABLE.FORM_LAYOUT is '表单布局 1：一列 2：两列' ; comment on column GEN_TABLE.DATASOURCE_ID is '数据源ID' ; comment on column GEN_TABLE.BASECLASS_ID is '基类ID' ; comment on column GEN_TABLE.CREATE_TIME is '创建时间' ; create unique index GEN_TABLE_NAME on GEN_TABLE (TABLE_NAME) ; create table GEN_PROJECT_MODIFY ( ID NUMBER(20) default "GEN_PROJECT_MODIFY_SEQ"."NEXTVAL" not null constraint SYS_C0010997 primary key constraint SYS_C0010996 check ("ID" IS NOT NULL) constraint SYS_C0014525 check ("ID" IS NOT NULL), PROJECT_NAME VARCHAR2(100), PROJECT_CODE VARCHAR2(100), PROJECT_PACKAGE VARCHAR2(100), PROJECT_PATH VARCHAR2(200), MODIFY_PROJECT_NAME VARCHAR2(100), MODIFY_PROJECT_CODE VARCHAR2(100), MODIFY_PROJECT_PACKAGE VARCHAR2(100), EXCLUSIONS VARCHAR2(200), MODIFY_SUFFIX VARCHAR2(200), MODIFY_TMP_PATH VARCHAR2(100), CREATE_TIME DATE ) ; comment on table GEN_PROJECT_MODIFY is '项目名变更' ; comment on column GEN_PROJECT_MODIFY.ID is 'id' ; comment on column GEN_PROJECT_MODIFY.PROJECT_NAME is '项目名' ; comment on column GEN_PROJECT_MODIFY.PROJECT_CODE is '项目标识' ; comment on column GEN_PROJECT_MODIFY.PROJECT_PACKAGE is '项目包名' ; comment on column GEN_PROJECT_MODIFY.PROJECT_PATH is '项目路径' ; comment on column GEN_PROJECT_MODIFY.MODIFY_PROJECT_NAME is '变更项目名' ; comment on column GEN_PROJECT_MODIFY.MODIFY_PROJECT_CODE is '变更标识' ; comment on column GEN_PROJECT_MODIFY.MODIFY_PROJECT_PACKAGE is '变更包名' ; comment on column GEN_PROJECT_MODIFY.EXCLUSIONS is '排除文件' ; comment on column GEN_PROJECT_MODIFY.MODIFY_SUFFIX is '变更文件' ; comment on column GEN_PROJECT_MODIFY.MODIFY_TMP_PATH is '变更临时路径' ; comment on column GEN_PROJECT_MODIFY.CREATE_TIME is '创建时间' ; create table GEN_FIELD_TYPE ( ID NUMBER(20) default "GEN_FIELD_TYPE_SEQ"."NEXTVAL" not null constraint SYS_C0010989 primary key constraint SYS_C0010988 check ("ID" IS NOT NULL) constraint SYS_C0014524 check ("ID" IS NOT NULL), COLUMN_TYPE VARCHAR2(200), ATTR_TYPE VARCHAR2(200), PACKAGE_NAME VARCHAR2(200), CREATE_TIME DATE ) ; comment on table GEN_FIELD_TYPE is '字段类型管理' ; comment on column GEN_FIELD_TYPE.ID is 'id' ; comment on column GEN_FIELD_TYPE.COLUMN_TYPE is '字段类型' ; comment on column GEN_FIELD_TYPE.ATTR_TYPE is '属性类型' ; comment on column GEN_FIELD_TYPE.PACKAGE_NAME is '属性包名' ; comment on column GEN_FIELD_TYPE.CREATE_TIME is '创建时间' ; create unique index GEN_COLUMN_TYPE on GEN_FIELD_TYPE (COLUMN_TYPE) ; create table GEN_DATASOURCE ( ID NUMBER(20) default "GEN_DATASOURCE_SEQ"."NEXTVAL" not null constraint SYS_C0010987 primary key constraint SYS_C0010986 check ("ID" IS NOT NULL) constraint SYS_C0014523 check ("ID" IS NOT NULL), DB_TYPE VARCHAR2(200), CONN_NAME VARCHAR2(200), CONN_URL VARCHAR2(500), USERNAME VARCHAR2(200), PASSWORD VARCHAR2(200), CREATE_TIME DATE ) ; comment on table GEN_DATASOURCE is '数据源管理' ; comment on column GEN_DATASOURCE.ID is 'id' ; comment on column GEN_DATASOURCE.DB_TYPE is '数据库类型' ; comment on column GEN_DATASOURCE.CONN_NAME is '连接名' ; comment on column GEN_DATASOURCE.CONN_URL is 'URL' ; comment on column GEN_DATASOURCE.USERNAME is '用户名' ; comment on column GEN_DATASOURCE.PASSWORD is '密码' ; comment on column GEN_DATASOURCE.CREATE_TIME is '创建时间' ; create table GEN_BASE_CLASS ( ID NUMBER(20) default "GEN_BASE_CLASS_SEQ"."NEXTVAL" not null constraint SYS_C0010991 primary key constraint SYS_C0010990 check ("ID" IS NOT NULL) constraint SYS_C0014522 check ("ID" IS NOT NULL), PACKAGE_NAME VARCHAR2(200), CODE VARCHAR2(200), FIELDS VARCHAR2(500), REMARK VARCHAR2(200), CREATE_TIME DATE ) ; comment on table GEN_BASE_CLASS is '基类管理' ; comment on column GEN_BASE_CLASS.ID is 'id' ; comment on column GEN_BASE_CLASS.PACKAGE_NAME is '基类包名' ; comment on column GEN_BASE_CLASS.CODE is '基类编码' ; comment on column GEN_BASE_CLASS.FIELDS is '基类字段，多个用英文逗号分隔' ; comment on column GEN_BASE_CLASS.REMARK is '备注' ; comment on column GEN_BASE_CLASS.CREATE_TIME is '创建时间' ; create table ACT_DE_MODEL ( ID NVARCHAR2(255) not null constraint SYS_C0012501 check ("ID" IS NOT NULL) constraint SYS_C0012506 check ("ID" IS NOT NULL), NAME NVARCHAR2(400) not null constraint SYS_C0012502 check ("NAME" IS NOT NULL) constraint SYS_C0012507 check ("NAME" IS NOT NULL), MODEL_KEY NVARCHAR2(400) not null constraint SYS_C0012503 check ("MODEL_KEY" IS NOT NULL) constraint SYS_C0012508 check ("MODEL_KEY" IS NOT NULL), FORM_KEY NVARCHAR2(255), CATEGORY_ID NUMBER(20), DESCRIPTION NCLOB, MODEL_COMMENT NCLOB, CREATED DATE, CREATED_BY NVARCHAR2(255), LAST_UPDATED DATE, LAST_UPDATED_BY NVARCHAR2(255), VERSION NUMBER(11), XML NCLOB, MODEL_EDITOR_JSON NCLOB, THUMBNAIL BLOB, MODEL_TYPE NUMBER(11), TENANT_ID NVARCHAR2(255), ICON NVARCHAR2(255), SEND_NOTICE NUMBER(1) default 0 not null, TIMEOUT_NOTICE_DURATION NUMBER(8, 2) default 0 not null ) ; comment on table ACT_DE_MODEL is '流程 - 定义 - 模型' ; comment on column ACT_DE_MODEL.NAME is '名称' ; comment on column ACT_DE_MODEL.MODEL_KEY is '模型标识' ; comment on column ACT_DE_MODEL.FORM_KEY is '表单标识' ; comment on column ACT_DE_MODEL.CATEGORY_ID is '分类id' ; comment on column ACT_DE_MODEL.DESCRIPTION is '描述' ; comment on column ACT_DE_MODEL.MODEL_COMMENT is '评论' ; comment on column ACT_DE_MODEL.CREATED is '创建时间' ; comment on column ACT_DE_MODEL.CREATED_BY is '创建人' ; comment on column ACT_DE_MODEL.LAST_UPDATED is '最后更新时间' ; comment on column ACT_DE_MODEL.LAST_UPDATED_BY is '最后更新人' ; comment on column ACT_DE_MODEL.VERSION is '版本' ; comment on column ACT_DE_MODEL.XML is 'xml' ; comment on column ACT_DE_MODEL.MODEL_EDITOR_JSON is 'flowable-ui编辑器json' ; comment on column ACT_DE_MODEL.THUMBNAIL is '缩略图' ; comment on column ACT_DE_MODEL.MODEL_TYPE is '类型' ; comment on column ACT_DE_MODEL.TENANT_ID is '租户id' ; comment on column ACT_DE_MODEL.ICON is '图标' ; comment on column ACT_DE_MODEL.SEND_NOTICE is '是否通知审批人 0通知 1不通知' ; comment on column ACT_DE_MODEL.TIMEOUT_NOTICE_DURATION is '审批超时提醒时长 （小时）0为不通知' ; create table ACT_DE_MODEL_HISTORY ( ID NVARCHAR2(255) not null constraint SYS_C0012382 primary key constraint SYS_C0012364 check ("ID" IS NOT NULL) constraint SYS_C0012509 check ("ID" IS NOT NULL), NAME NVARCHAR2(400) not null constraint SYS_C0012365 check ("NAME" IS NOT NULL) constraint SYS_C0012510 check ("NAME" IS NOT NULL), MODEL_KEY NVARCHAR2(400) not null constraint SYS_C0012366 check ("MODEL_KEY" IS NOT NULL) constraint SYS_C0012511 check ("MODEL_KEY" IS NOT NULL), FORM_KEY NVARCHAR2(255), CATEGORY_ID NUMBER(20), DESCRIPTION NCLOB, MODEL_COMMENT NCLOB, CREATED DATE, CREATED_BY NVARCHAR2(255), LAST_UPDATED DATE, LAST_UPDATED_BY NVARCHAR2(255), REMOVAL_DATE DATE, VERSION NUMBER(11), XML NCLOB, MODEL_EDITOR_JSON NCLOB, MODEL_ID NVARCHAR2(255) not null constraint SYS_C0012367 check ("MODEL_ID" IS NOT NULL) constraint SYS_C0012512 check ("MODEL_ID" IS NOT NULL), MODEL_TYPE NUMBER(11), TENANT_ID NVARCHAR2(255), ICON NVARCHAR2(255) ) ; comment on table ACT_DE_MODEL_HISTORY is '流程 - 定义 - 模型历史' ; comment on column ACT_DE_MODEL_HISTORY.NAME is '名称' ; comment on column ACT_DE_MODEL_HISTORY.MODEL_KEY is '模型标识' ; comment on column ACT_DE_MODEL_HISTORY.FORM_KEY is '表单标识' ; comment on column ACT_DE_MODEL_HISTORY.CATEGORY_ID is '分类id' ; comment on column ACT_DE_MODEL_HISTORY.DESCRIPTION is '描述' ; comment on column ACT_DE_MODEL_HISTORY.MODEL_COMMENT is '注释' ; comment on column ACT_DE_MODEL_HISTORY.CREATED is '创建时间' ; comment on column ACT_DE_MODEL_HISTORY.CREATED_BY is '创建人' ; comment on column ACT_DE_MODEL_HISTORY.LAST_UPDATED is '最后更新时间' ; comment on column ACT_DE_MODEL_HISTORY.LAST_UPDATED_BY is '最后更新人' ; comment on column ACT_DE_MODEL_HISTORY.REMOVAL_DATE is '移除时间' ; comment on column ACT_DE_MODEL_HISTORY.VERSION is '版本' ; comment on column ACT_DE_MODEL_HISTORY.XML is 'xml' ; comment on column ACT_DE_MODEL_HISTORY.MODEL_EDITOR_JSON is 'flowable-ui编辑器json' ; comment on column ACT_DE_MODEL_HISTORY.MODEL_ID is 'modelId' ; comment on column ACT_DE_MODEL_HISTORY.MODEL_TYPE is '类型' ; comment on column ACT_DE_MODEL_HISTORY.TENANT_ID is '租户id' ; comment on column ACT_DE_MODEL_HISTORY.ICON is '图标' ;