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 '图标' /