CREATE TABLE  "UC_USER_UNITE"
(
 "ID_" VARCHAR(64) NOT NULL,
 "USER_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "OPEN_ID_" VARCHAR(1000) DEFAULT NULL
 NULL,
 "WX_WORK_ID_" VARCHAR(1000) DEFAULT NULL
 NULL,
 "DINGTALK_ID_" VARCHAR(1000) DEFAULT NULL
 NULL,
 "TENANT_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "MP_OPEN_ID_" VARCHAR(255) NULL,
 "FLYBOOK_ID_" VARCHAR2(100) DEFAULT NULL
 NULL
);
CREATE TABLE  "UC_USER_UNDER"
(
 "ID_" VARCHAR(64) NOT NULL,
 "USER_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "UNDER_USER_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "UNDER_USER_NAME_" VARCHAR(64) DEFAULT NULL
 NULL,
 "ORG_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "UPDATE_TIME_" DATETIME(6) NULL,
 "IS_DELE_" CHAR(1) DEFAULT '0'
 NULL,
 "VERSION_" INTEGER DEFAULT NULL
 NULL,
 "CREATE_BY_" VARCHAR(64) DEFAULT NULL
 NULL,
 "CREATE_ORG_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "CREATE_TIME_" DATETIME(6) NULL,
 "UPDATE_BY_" VARCHAR(64) DEFAULT NULL
 NULL,
 "DIMEN_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "TENANT_ID_" VARCHAR(64) DEFAULT NULL
 NULL
);
CREATE TABLE  "UC_USER_ROLE"
(
 "ID_" VARCHAR(64) NOT NULL,
 "ROLE_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "USER_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "UPDATE_TIME_" DATETIME(6) NULL,
 "IS_DELE_" CHAR(1) DEFAULT '0'
 NULL,
 "VERSION_" INTEGER DEFAULT NULL
 NULL,
 "CREATE_BY_" VARCHAR(64) DEFAULT NULL
 NULL,
 "CREATE_ORG_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "CREATE_TIME_" DATETIME(6) NULL,
 "UPDATE_BY_" VARCHAR(64) DEFAULT NULL
 NULL,
 "TENANT_ID_" VARCHAR(64) DEFAULT NULL
 NULL
);
CREATE TABLE  "UC_USER_REL"
(
 "ID_" VARCHAR(64) NOT NULL,
 "NAME_" VARCHAR(255) DEFAULT NULL
 NULL,
 "LEVEL_" VARCHAR(64) DEFAULT NULL
 NULL,
 "PARENT_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "TYPE_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "GROUP_TYPE_" VARCHAR(64) DEFAULT NULL
 NULL,
 "PATH_" VARCHAR(512) DEFAULT NULL
 NULL,
 "VALUE_" VARCHAR(64) DEFAULT NULL
 NULL,
 "STATUS_" INTEGER DEFAULT NULL
 NULL,
 "ALIAS_" VARCHAR(64) DEFAULT NULL
 NULL,
 "UPDATE_TIME_" DATETIME(6) NULL,
 "IS_DELE_" CHAR(1) DEFAULT '0'
 NULL,
 "VERSION_" INTEGER DEFAULT NULL
 NULL,
 "CREATE_BY_" VARCHAR(64) DEFAULT NULL
 NULL,
 "CREATE_ORG_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "CREATE_TIME_" DATETIME(6) NULL,
 "UPDATE_BY_" VARCHAR(64) DEFAULT NULL
 NULL,
 "TENANT_ID_" VARCHAR(64) DEFAULT NULL
 NULL
);
CREATE TABLE  "UC_USER_PARAMS"
(
 "ID_" VARCHAR(64) NOT NULL,
 "USER_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "CODE_" VARCHAR(64) DEFAULT NULL
 NULL,
 "VALUE_" VARCHAR(64) DEFAULT NULL
 NULL,
 "UPDATE_TIME_" DATETIME(6) NULL,
 "IS_DELE_" CHAR(1) DEFAULT '0'
 NULL,
 "VERSION_" INTEGER DEFAULT NULL
 NULL,
 "CREATE_BY_" VARCHAR(64) DEFAULT NULL
 NULL,
 "CREATE_ORG_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "CREATE_TIME_" DATETIME(6) NULL,
 "UPDATE_BY_" VARCHAR(64) DEFAULT NULL
 NULL,
 "TENANT_ID_" VARCHAR(64) DEFAULT NULL
 NULL
);
CREATE TABLE  "UC_USER_GROUP"
(
 "ID_" VARCHAR(64) NOT NULL,
 "NAME_" VARCHAR(255) DEFAULT NULL
 NULL,
 "JSON_" VARCHAR(2000) DEFAULT NULL
 NULL,
 "CODE_" VARCHAR(64) DEFAULT NULL
 NULL,
 "DESCRIPTION_" VARCHAR(512) DEFAULT NULL
 NULL,
 "USER_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "ORG_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "ROLE_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "POS_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "UPDATE_TIME_" DATETIME(6) NULL,
 "IS_DELE_" CHAR(1) DEFAULT '0'
 NULL,
 "VERSION_" INTEGER DEFAULT NULL
 NULL,
 "CREATE_BY_" VARCHAR(64) DEFAULT NULL
 NULL,
 "CREATE_ORG_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "CREATE_TIME_" DATETIME(6) NULL,
 "UPDATE_BY_" VARCHAR(64) DEFAULT NULL
 NULL,
 "TENANT_ID_" VARCHAR(64) DEFAULT NULL
 NULL
);
CREATE TABLE  "UC_USER"
(
 "ID_" VARCHAR(64) NOT NULL,
 "FULLNAME_" VARCHAR(255) DEFAULT NULL
 NULL,
 "ACCOUNT_" VARCHAR(255) DEFAULT NULL
 NULL,
 "PASSWORD_" VARCHAR(64) DEFAULT NULL
 NULL,
 "EMAIL_" VARCHAR(64) DEFAULT NULL
 NULL,
 "MOBILE_" VARCHAR(255) DEFAULT NULL
 NULL,
 "WEIXIN_" VARCHAR(64) DEFAULT NULL
 NULL,
 "CREATE_TIME_" DATETIME(6) NULL,
 "CREATE_ORG_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "UPDATE_BY_" VARCHAR(64) DEFAULT NULL
 NULL,
 "TENANT_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "ADDRESS_" VARCHAR(512) DEFAULT NULL
 NULL,
 "PHOTO_" VARCHAR(255) DEFAULT NULL
 NULL,
 "SEX_" VARCHAR(64) DEFAULT NULL
 NULL,
 "FROM_" VARCHAR(64) DEFAULT NULL
 NULL,
 "STATUS_" INTEGER DEFAULT NULL
 NULL,
 "HAS_SYNC_TO_WX_" INTEGER DEFAULT NULL
 NULL,
 "NOTIFY_TYPE_" VARCHAR(64) DEFAULT NULL
 NULL,
 "USER_NUMBER_" VARCHAR(64) DEFAULT NULL
 NULL,
 "ID_CARD_" VARCHAR(38) DEFAULT NULL
 NULL,
 "PHONE_" VARCHAR(64) DEFAULT NULL
 NULL,
 "BIRTHDAY_" DATETIME(6) NULL,
 "ENTRY_DATE_" DATETIME(6) NULL,
 "LEAVE_DATE_" DATETIME(6) NULL,
 "EDUCATION_" VARCHAR(64) DEFAULT NULL
 NULL,
 "UPDATE_TIME_" DATETIME(6) NULL,
 "CREATE_BY_" VARCHAR(64) DEFAULT NULL
 NULL,
 "IS_DELE_" CHAR(1) DEFAULT '0'
 NULL,
 "VERSION_" INTEGER DEFAULT NULL
 NULL,
 "PWD_CREATE_TIME_" DATETIME(6) NULL,
 "CLIENT_ID_" VARCHAR(255) NULL,
 "CLIENT_TOKEN_" VARCHAR(255) NULL,
 "TWO_VERIFY_SECRET_" VARCHAR2(50) DEFAULT NULL
 NULL
);
CREATE TABLE  "UC_TENANT_TYPE"
(
 "ID_" VARCHAR(64) NOT NULL,
 "NAME_" VARCHAR(64) DEFAULT NULL
 NULL,
 "CODE_" VARCHAR(64) DEFAULT NULL
 NULL,
 "STATUS_" VARCHAR(20) DEFAULT NULL
 NULL,
 "IS_DEFAULT_" CHAR(1) DEFAULT NULL
 NULL,
 "DESC_" VARCHAR(300) DEFAULT NULL
 NULL,
 "CREATE_TIME_" DATETIME(6) NULL,
 "CREATE_BY_" VARCHAR(64) DEFAULT NULL
 NULL,
 "CREATE_ORG_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "UPDATE_TIME_" DATETIME(6) NULL,
 "UPDATE_BY_" VARCHAR(64) DEFAULT NULL
 NULL
);
CREATE TABLE  "UC_TENANT_PARAMS"
(
 "ID_" VARCHAR(64) NOT NULL,
 "TENANT_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "CODE_" VARCHAR(64) DEFAULT NULL
 NULL,
 "VALUE_" VARCHAR(600) DEFAULT NULL
 NULL,
 "CREATE_TIME_" DATETIME(6) NULL,
 "CREATE_BY_" VARCHAR(64) DEFAULT NULL
 NULL,
 "CREATE_ORG_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "UPDATE_TIME_" DATETIME(6) NULL,
 "UPDATE_BY_" VARCHAR(64) DEFAULT NULL
 NULL
);
CREATE TABLE  "UC_TENANT_MANAGE"
(
 "ID_" VARCHAR(64) NOT NULL,
 "TYPE_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "NAME_" VARCHAR2(300) DEFAULT NULL
 NULL,
 "CODE_" VARCHAR(128) DEFAULT NULL
 NULL,
 "STATUS_" VARCHAR(20) DEFAULT NULL
 NULL,
 "SHORTHAND_" VARCHAR2(150) DEFAULT NULL
 NULL,
 "DOMAIN_" VARCHAR(128) DEFAULT NULL
 NULL,
 "MANAGE_LOGO_" VARCHAR(1200) DEFAULT NULL
 NULL,
 "FRONT_LOGO_" VARCHAR(1200) DEFAULT NULL
 NULL,
 "ICO_" VARCHAR(1200) DEFAULT NULL
 NULL,
 "DESC_" VARCHAR(300) DEFAULT NULL
 NULL,
 "CREATE_TIME_" DATETIME(6) NULL,
 "CREATE_BY_" VARCHAR(64) DEFAULT NULL
 NULL,
 "CREATE_ORG_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "UPDATE_TIME_" DATETIME(6) NULL,
 "IS_DELE_" CHAR(1) DEFAULT '0'
 NULL,
 "NAME_FRONT_" VARCHAR2(300) DEFAULT NULL
 NULL,
 "UPDATE_BY_" VARCHAR(64) DEFAULT NULL
 NULL,
 "BASE_URL_" VARCHAR(255) DEFAULT NULL
 NULL
);
CREATE TABLE  "UC_TENANT_MAIL_SERVER"
(
 "ID_" VARCHAR(64) NOT NULL,
 "TENANT_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "MAIL_TYPE_" VARCHAR(64) DEFAULT NULL
 NULL,
 "MAIL_HOST_" VARCHAR(128) DEFAULT NULL
 NULL,
 "MAIL_PASS_" VARCHAR(128) DEFAULT NULL
 NULL,
 "NICK_NAME_" VARCHAR(128) DEFAULT NULL
 NULL,
 "USER_NAME_" VARCHAR(128) DEFAULT NULL
 NULL,
 "MAIL_PORT_" INTEGER DEFAULT NULL
 NULL,
 "USE_SSL_" SMALLINT DEFAULT NULL
 NULL,
 "DESC_" VARCHAR(300) DEFAULT NULL
 NULL,
 "CREATE_TIME_" DATETIME(6) NULL,
 "CREATE_BY_" VARCHAR(64) DEFAULT NULL
 NULL,
 "CREATE_ORG_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "UPDATE_TIME_" DATETIME(6) NULL,
 "UPDATE_BY_" VARCHAR(64) DEFAULT NULL
 NULL,
 "SMTP_HOST_" VARCHAR(128) NULL,
 "SEND_PORT_" VARCHAR(20) NULL
);
CREATE TABLE  "UC_TENANT_LOGS"
(
 "ID_" VARCHAR(64) NOT NULL,
 "TENANT_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "TYPE_" VARCHAR(64) DEFAULT NULL
 NULL,
 "NAME_" VARCHAR(300) DEFAULT NULL
 NULL,
 "REQ_URL_" VARCHAR(300) DEFAULT NULL
 NULL,
 "IP_" VARCHAR(20) DEFAULT NULL
 NULL,
 "PARAMS_" VARCHAR(4000) DEFAULT NULL
 NULL,
 "OPE_CONTENT_" CLOB NULL,
 "RESULT_" SMALLINT DEFAULT NULL
 NULL,
 "REASON_" VARCHAR(4000) DEFAULT NULL
 NULL,
 "CREATE_TIME_" DATETIME(6) NULL,
 "CREATE_BY_" VARCHAR(64) DEFAULT NULL
 NULL,
 "CREATE_ORG_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "UPDATE_TIME_" DATETIME(6) NULL,
 "UPDATE_BY_" VARCHAR(64) DEFAULT NULL
 NULL
);
CREATE TABLE  "UC_TENANT_IGNORE_MENU"
(
 "ID_" VARCHAR(64) NOT NULL,
 "TENANT_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "MENU_CODE_" VARCHAR(64) DEFAULT NULL
 NULL,
 "CREATE_TIME_" DATETIME(6) NULL,
 "CREATE_BY_" VARCHAR(64) DEFAULT NULL
 NULL,
 "CREATE_ORG_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "UPDATE_TIME_" DATETIME(6) NULL,
 "UPDATE_BY_" VARCHAR(64) DEFAULT NULL
 NULL
);
CREATE TABLE  "UC_TENANT_AUTH"
(
 "ID_" VARCHAR(64) NOT NULL,
 "TYPE_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "TENANT_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "USER_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "USER_NAME_" VARCHAR(64) DEFAULT NULL
 NULL,
 "CREATE_TIME_" DATETIME(6) NULL,
 "CREATE_BY_" VARCHAR(64) DEFAULT NULL
 NULL,
 "CREATE_ORG_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "UPDATE_TIME_" DATETIME(6) NULL,
 "UPDATE_BY_" VARCHAR(64) DEFAULT NULL
 NULL
);
CREATE TABLE  "UC_SHIFT_USER"
(
 "ID_" VARCHAR(64) NOT NULL,
 "USER_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "SHIFT_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "TENANT_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "IS_DELE_" VARCHAR(1) DEFAULT NULL
 NULL,
 "VERSION_" INTEGER DEFAULT NULL
 NULL,
 "CREATE_BY_" VARCHAR(64) DEFAULT NULL
 NULL,
 "UPDATE_BY_" VARCHAR(64) DEFAULT NULL
 NULL,
 "CREATE_TIME_" DATETIME(6) DEFAULT NULL
 NULL,
 "UPDATE_TIME_" DATETIME(6) DEFAULT NULL
 NULL,
 "CREATE_ORG_ID_" VARCHAR(64) DEFAULT NULL
 NULL
);
CREATE TABLE  "UC_SHIFT_RULE"
(
 "ID_" VARCHAR(64) NOT NULL,
 "NAME_" VARCHAR(128) DEFAULT NULL
 NULL,
 "KEY_" VARCHAR(128) DEFAULT NULL
 NULL,
 "DESC_" CLOB NULL,
 "RULE_" CLOB NULL,
 "HOLIDAY_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "IS_DELE_" VARCHAR(1) DEFAULT NULL
 NULL,
 "CREATE_TIME_" DATETIME(6) DEFAULT NULL
 NULL,
 "UPDATE_TIME_" DATETIME(6) DEFAULT NULL
 NULL,
 "CREATE_BY_" VARCHAR(64) DEFAULT NULL
 NULL,
 "UPDATE_BY_" VARCHAR(64) DEFAULT NULL
 NULL,
 "CREATE_ORG_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "TENANT_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "VERSION_" INTEGER DEFAULT NULL
 NULL
);
CREATE TABLE  "UC_ROLE"
(
 "ID_" VARCHAR(64) NOT NULL,
 "NAME_" VARCHAR2(150) DEFAULT NULL
 NULL,
 "CODE_" VARCHAR(64) DEFAULT NULL
 NULL,
 "ENABLED_" INTEGER DEFAULT NULL
 NULL,
 "DESCRIPTION_" VARCHAR2(150) DEFAULT NULL
 NULL,
 "UPDATE_TIME_" DATETIME(6) NULL,
 "IS_DELE_" CHAR(1) DEFAULT '0'
 NULL,
 "VERSION_" INTEGER DEFAULT NULL
 NULL,
 "CREATE_BY_" VARCHAR(64) DEFAULT NULL
 NULL,
 "UPDATE_BY_" VARCHAR(64) DEFAULT NULL
 NULL,
 "CREATE_ORG_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "CREATE_TIME_" DATETIME(6) NULL,
 "TENANT_ID_" VARCHAR(64) DEFAULT NULL
 NULL
);
CREATE TABLE  "UC_REL_TYPE"
(
 "ID_" VARCHAR(64) NOT NULL,
 "NAME_" VARCHAR(64) DEFAULT NULL
 NULL,
 "CODE_" VARCHAR(64) DEFAULT NULL
 NULL,
 "DESCRIPTION_" VARCHAR(255) DEFAULT NULL
 NULL,
 "UPDATE_TIME_" DATETIME(6) NULL,
 "IS_DELE_" CHAR(1) DEFAULT '0'
 NULL,
 "VERSION_" INTEGER DEFAULT NULL
 NULL
);
CREATE TABLE  "UC_REL_AUTH"
(
 "ID_" VARCHAR(64) NOT NULL,
 "USER_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "REL_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "TYPE_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "UPDATE_TIME_" DATETIME(6) NULL,
 "IS_DELE_" CHAR(1) DEFAULT '0'
 NULL,
 "VERSION_" INTEGER DEFAULT NULL
 NULL,
 "CREATE_BY_" VARCHAR(64) DEFAULT NULL
 NULL,
 "CREATE_ORG_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "CREATE_TIME_" DATETIME(6) NULL,
 "UPDATE_BY_" VARCHAR(64) DEFAULT NULL
 NULL,
 "TENANT_ID_" VARCHAR(64) DEFAULT NULL
 NULL
);
CREATE TABLE  "UC_PWD_STRATEGY"
(
 "ID_" VARCHAR(64) NOT NULL,
 "INIT_PWD_" VARCHAR(64) DEFAULT NULL
 NULL,
 "PWD_RULE_" SMALLINT DEFAULT NULL
 NULL,
 "PWD_LENGTH_" SMALLINT DEFAULT NULL
 NULL,
 "DURATION_" SMALLINT DEFAULT NULL
 NULL,
 "ENABLE_" SMALLINT DEFAULT NULL
 NULL,
 "TENANT_ID_" VARCHAR(64) DEFAULT NULL
 NULL
);
CREATE TABLE  "UC_PROPERTIES"
(
 "ID_" VARCHAR(64) NOT NULL,
 "NAME_" VARCHAR(64) DEFAULT NULL
 NULL,
 "CODE_" VARCHAR(64) DEFAULT NULL
 NULL,
 "GROUP_" VARCHAR(64) DEFAULT NULL
 NULL,
 "VALUE_" VARCHAR(200) DEFAULT NULL
 NULL,
 "ENCRYPT_" INTEGER DEFAULT NULL
 NULL,
 "DESCRIPTION_" VARCHAR(200) DEFAULT NULL
 NULL,
 "UPDATE_TIME_" DATETIME(6) NULL,
 "IS_DELE_" CHAR(1) DEFAULT '0'
 NULL,
 "VERSION_" INTEGER DEFAULT NULL
 NULL,
 "CREATE_BY_" VARCHAR(64) DEFAULT NULL
 NULL,
 "CREATE_ORG_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "CREATE_TIME_" DATETIME(6) NULL,
 "UPDATE_BY_" VARCHAR(64) DEFAULT NULL
 NULL,
 "TENANT_ID_" VARCHAR(64) DEFAULT NULL
 NULL
);
CREATE TABLE  "UC_PARAMS"
(
 "ID_" VARCHAR(64) NOT NULL,
 "NAME_" VARCHAR(64) DEFAULT NULL
 NULL,
 "CODE_" VARCHAR(64) DEFAULT NULL
 NULL,
 "TYPE_" VARCHAR(64) DEFAULT NULL
 NULL,
 "CTL_TYPE_" VARCHAR(64) DEFAULT NULL
 NULL,
 "JSON_" VARCHAR(1700) DEFAULT NULL
 NULL,
 "UPDATE_TIME_" DATETIME(6) NULL,
 "IS_DELE_" CHAR(1) DEFAULT '0'
 NULL,
 "VERSION_" INTEGER DEFAULT NULL
 NULL,
 "CREATE_BY_" VARCHAR(64) DEFAULT NULL
 NULL,
 "CREATE_ORG_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "CREATE_TIME_" DATETIME(6) NULL,
 "UPDATE_BY_" VARCHAR(64) DEFAULT NULL
 NULL,
 "TENANT_TYPE_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "TENANT_ID_" VARCHAR(64) DEFAULT NULL
 NULL
);
CREATE TABLE  "UC_ORGAN"
(
 "ID_" VARCHAR(64) NOT NULL,
 "CODE_" VARCHAR(64) DEFAULT NULL
 NULL,
 "NAME_" VARCHAR(255) DEFAULT NULL
 NULL,
 "DESC_" VARCHAR(512) DEFAULT NULL
 NULL,
 "CREATE_BY_" VARCHAR(64) DEFAULT NULL
 NULL,
 "CREATE_TIME_" DATETIME(6) NULL,
 "UPDATE_TIME_" DATETIME(6) NULL,
 "IS_DELE_" CHAR(1) DEFAULT '0'
 NULL,
 "VERSION_" INTEGER DEFAULT NULL
 NULL
);
CREATE TABLE  "UC_ORG_USER"
(
 "ID_" VARCHAR(64) NOT NULL,
 "ORG_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "USER_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "IS_MASTER_" INTEGER DEFAULT 0
 NOT NULL,
 "POS_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "IS_CHARGE_" INTEGER DEFAULT 0
 NULL,
 "START_DATE_" DATETIME(6) NULL,
 "END_DATE_" DATETIME(6) NULL,
 "IS_REL_ACTIVE_" INTEGER NOT NULL,
 "UPDATE_TIME_" DATETIME(6) NULL,
 "IS_DELE_" CHAR(1) DEFAULT '0'
 NULL,
 "VERSION_" INTEGER DEFAULT NULL
 NULL,
 "CREATE_BY_" VARCHAR(64) DEFAULT NULL
 NULL,
 "CREATE_ORG_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "CREATE_TIME_" DATETIME(6) NULL,
 "UPDATE_BY_" VARCHAR(64) DEFAULT NULL
 NULL,
 "TENANT_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "DEM_ID_" VARCHAR(64) NULL
);
CREATE TABLE  "UC_ORG_UNITE"
(
 "ID_" VARCHAR2(64) NOT NULL,
 "ORG_ID_" VARCHAR2(64) DEFAULT NULL
 NULL,
 "WX_WORK_ID_" VARCHAR2(100) DEFAULT NULL
 NULL,
 "DINGTALK_ID_" VARCHAR2(100) DEFAULT NULL
 NULL,
 "FLYBOOK_ID_" VARCHAR2(100) DEFAULT NULL
 NULL,
 "DELETE_FLAG_" NUMBER(1,0) DEFAULT 0
 NOT NULL,
 "UPDATE_TIME_" DATETIME(6) NULL,
 "CREATE_TIME_" DATETIME(6) NULL,
 "TENANT_ID_" VARCHAR2(64) DEFAULT NULL
 NULL
);
CREATE TABLE  "UC_ORG_ROLE"
(
 "ID_" VARCHAR(64) NOT NULL,
 "ROLE_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "ORG_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "IS_INHERIT_" INTEGER DEFAULT 0
 NULL,
 "UPDATE_TIME_" DATETIME(6) NULL,
 "IS_DELE_" CHAR(1) DEFAULT '0'
 NULL,
 "VERSION_" INTEGER DEFAULT NULL
 NULL,
 "CREATE_BY_" VARCHAR(64) DEFAULT NULL
 NULL,
 "CREATE_ORG_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "CREATE_TIME_" DATETIME(6) NULL,
 "UPDATE_BY_" VARCHAR(64) DEFAULT NULL
 NULL,
 "TENANT_ID_" VARCHAR(64) DEFAULT NULL
 NULL
);
CREATE TABLE  "UC_ORG_POST"
(
 "ID_" VARCHAR(64) NOT NULL,
 "ORG_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "JOB_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "POS_NAME_" VARCHAR(64) DEFAULT NULL
 NULL,
 "CODE_" VARCHAR(64) DEFAULT NULL
 NULL,
 "IS_CHARGE_" INTEGER DEFAULT 0
 NOT NULL,
 "UPDATE_TIME_" DATETIME(6) NULL,
 "IS_DELE_" CHAR(1) DEFAULT '0'
 NULL,
 "VERSION_" INTEGER DEFAULT NULL
 NULL,
 "CREATE_BY_" VARCHAR(64) DEFAULT NULL
 NULL,
 "CREATE_ORG_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "CREATE_TIME_" DATETIME(6) NULL,
 "UPDATE_BY_" VARCHAR(64) DEFAULT NULL
 NULL,
 "TENANT_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "PARENT_ID_" VARCHAR(64) DEFAULT NULL
 NULL
);
CREATE TABLE  "UC_ORG_PARAMS"
(
 "ID_" VARCHAR(64) NOT NULL,
 "ORG_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "CODE_" VARCHAR(64) DEFAULT NULL
 NULL,
 "VALUE_" VARCHAR(64) DEFAULT NULL
 NULL,
 "UPDATE_TIME_" DATETIME(6) NULL,
 "IS_DELE_" CHAR(1) DEFAULT '0'
 NULL,
 "VERSION_" INTEGER DEFAULT NULL
 NULL,
 "CREATE_BY_" VARCHAR(64) DEFAULT NULL
 NULL,
 "CREATE_ORG_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "CREATE_TIME_" DATETIME(6) NULL,
 "UPDATE_BY_" VARCHAR(64) DEFAULT NULL
 NULL,
 "TENANT_ID_" VARCHAR(64) DEFAULT NULL
 NULL
);
CREATE TABLE  "UC_ORG_JOB"
(
 "ID_" VARCHAR(64) NOT NULL,
 "NAME_" VARCHAR(64) NOT NULL,
 "CODE_" VARCHAR(64) NOT NULL,
 "JOB_LEVEL_" VARCHAR(64) DEFAULT NULL
 NULL,
 "DESCRIPTION_" VARCHAR(512) DEFAULT NULL
 NULL,
 "UPDATE_TIME_" DATETIME(6) NULL,
 "IS_DELE_" CHAR(1) DEFAULT '0'
 NULL,
 "VERSION_" INTEGER DEFAULT NULL
 NULL,
 "CREATE_BY_" VARCHAR(64) DEFAULT NULL
 NULL,
 "CREATE_ORG_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "CREATE_TIME_" DATETIME(6) NULL,
 "UPDATE_BY_" VARCHAR(64) DEFAULT NULL
 NULL,
 "TENANT_ID_" VARCHAR(64) DEFAULT NULL
 NULL
);
CREATE TABLE  "UC_ORG_AUTH"
(
 "ID_" VARCHAR(64) NOT NULL,
 "USER_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "ORG_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "DEM_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "ORG_PERMS_" VARCHAR(255) DEFAULT NULL
 NULL,
 "USER_PERMS_" VARCHAR(255) DEFAULT NULL
 NULL,
 "POS_PERMS_" VARCHAR(255) DEFAULT NULL
 NULL,
 "ORGAUTH_PERMS_" VARCHAR(255) DEFAULT NULL
 NULL,
 "LAYOUT_PERMS_" VARCHAR(255) DEFAULT NULL
 NULL,
 "UPDATE_TIME_" DATETIME(6) NULL,
 "IS_DELE_" CHAR(1) DEFAULT '0'
 NULL,
 "VERSION_" INTEGER DEFAULT NULL
 NULL,
 "CREATE_BY_" VARCHAR(64) DEFAULT NULL
 NULL,
 "CREATE_ORG_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "CREATE_TIME_" DATETIME(6) NULL,
 "UPDATE_BY_" VARCHAR(64) DEFAULT NULL
 NULL,
 "TENANT_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "ROLE_CONFIG_" CLOB NULL,
 "ROLE_PERMS_" VARCHAR(255) NULL
);
CREATE TABLE  "UC_ORG"
(
 "ID_" VARCHAR(64) NOT NULL,
 "NAME_" VARCHAR(150) DEFAULT NULL
 NULL,
 "PARENT_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "ORDER_NO_" INTEGER DEFAULT NULL
 NULL,
 "CODE_" VARCHAR(64) NOT NULL,
 "GRADE_" VARCHAR(64) DEFAULT NULL
 NULL,
 "PATH_" VARCHAR(512) DEFAULT NULL
 NULL,
 "PATH_NAME_" VARCHAR(512) DEFAULT NULL
 NULL,
 "DEM_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "UPDATE_TIME_" DATETIME(6) NULL,
 "IS_DELE_" CHAR(1) DEFAULT '0'
 NULL,
 "VERSION_" INTEGER DEFAULT NULL
 NULL,
 "LIMIT_NUM_" INTEGER DEFAULT 0
 NOT NULL,
 "NOW_NUM_" INTEGER DEFAULT NULL
 NULL,
 "EXCEED_LIMIT_NUM_" INTEGER DEFAULT 0
 NOT NULL,
 "CREATE_BY_" VARCHAR(64) DEFAULT NULL
 NULL,
 "CREATE_ORG_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "CREATE_TIME_" DATETIME(6) NULL,
 "UPDATE_BY_" VARCHAR(64) DEFAULT NULL
 NULL,
 "TENANT_ID_" VARCHAR(64) DEFAULT NULL
 NULL
);
CREATE TABLE  "UC_OPERATE_LOG"
(
 "ID_" VARCHAR(64) NOT NULL,
 "REQ_IP_" VARCHAR(255) DEFAULT NULL
 NULL,
 "REQ_TYPE_" VARCHAR(64) DEFAULT NULL
 NULL,
 "REQ_URL_" VARCHAR(200) DEFAULT NULL
 NULL,
 "REQ_PARAM_" CLOB NULL,
 "START_TIME_" DATETIME(6) NULL,
 "END_TIME_" DATETIME(6) NULL,
 "OPERATOR_NAME_" VARCHAR(64) DEFAULT NULL
 NULL,
 "NOTE_" VARCHAR(2000) DEFAULT NULL
 NULL,
 "SUCCESS_" INTEGER DEFAULT NULL
 NULL,
 "FAIL_REASON_" VARCHAR(2000) DEFAULT NULL
 NULL,
 "IS_DELE_" CHAR(1) DEFAULT '0'
 NULL,
 "VERSION_" INTEGER DEFAULT NULL
 NULL,
 "TENANT_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "CREATE_BY_" VARCHAR(64) DEFAULT NULL
 NULL,
 "CREATE_ORG_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "CREATE_TIME_" DATETIME(6) NULL,
 "UPDATE_BY_" VARCHAR(64) DEFAULT NULL
 NULL,
 "UPDATE_TIME_" DATETIME(6) NULL
);
CREATE TABLE  "UC_ONE_TIME_CODE"
(
 "ID_" VARCHAR2(64) NOT NULL,
 "CODE_" VARCHAR2(50) NOT NULL,
 "USER_ID_" VARCHAR2(64) NOT NULL,
 "IS_USED_" NUMBER(1,0) DEFAULT 0
 NULL,
 "TENANT_ID_" VARCHAR2(64) NULL,
 "CREATE_TIME_" DATETIME(6) NOT NULL,
 "CREATOR_" VARCHAR2(32) NOT NULL,
 "CREATE_BY_" VARCHAR2(64) NOT NULL,
 "IS_DELE_" NUMBER(1,0) DEFAULT 0
 NOT NULL
);
CREATE TABLE  "UC_MATRIX_PROC_RELATION"
(
 "ID_" VARCHAR(64) NOT NULL,
 "MATRIX_CODE_" VARCHAR(255) NULL,
 "PROC_DEF_KEY_" VARCHAR(64) NULL,
 "PROC_DEF_NAME_" VARCHAR(64) NULL,
 "TENANT_ID_" VARCHAR(64) NULL
);
CREATE TABLE  "UC_MATRIX_COL_DEF"
(
 "ID_" VARCHAR(64) NOT NULL,
 "MATRIX_ID_" VARCHAR(255) DEFAULT NULL
 NULL,
 "CODE_" VARCHAR(20) DEFAULT NULL
 NULL,
 "NAME_" VARCHAR(128) DEFAULT NULL
 NULL,
 "STATUS_" INTEGER DEFAULT NULL
 NULL,
 "COL_TYPE_" INTEGER DEFAULT NULL
 NULL,
 "SELECT_TYPE_" INTEGER DEFAULT NULL
 NULL,
 "CTRL_TYPE_" VARCHAR(20) DEFAULT NULL
 NULL,
 "QUERY_ALIAS_" VARCHAR(255) DEFAULT NULL
 NULL,
 "COL_CONFIG_" VARCHAR(255) DEFAULT NULL
 NULL,
 "IS_DELE_" INTEGER DEFAULT NULL
 NULL,
 "CREATE_BY_" VARCHAR(64) DEFAULT NULL
 NULL,
 "CREATE_TIME_" DATETIME(6) DEFAULT NULL
 NULL,
 "CREATE_ORG_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "UPDATE_BY_" VARCHAR(64) DEFAULT NULL
 NULL,
 "UPDATE_TIME_" DATETIME(6) DEFAULT NULL
 NULL,
 "TENANT_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "SN_" INTEGER DEFAULT NULL
 NULL,
 "BIND_KEY_" VARCHAR(255) DEFAULT NULL
 NULL,
 "BIND_VALUE_" VARCHAR(255) DEFAULT NULL
 NULL,
 "SEARCH_FIELD_" VARCHAR(50) NULL
);
CREATE TABLE  "UC_MATRIX_AUTH"
(
 "ID_" VARCHAR(64) NOT NULL,
 "MATRIX_ID_" VARCHAR(64) NULL,
 "USER_ID_" VARCHAR(64) NULL,
 "CREATE_TIME_" DATETIME(6) NULL,
 "CREATE_BY_" VARCHAR(64) NULL,
 "UPDATE_TIME_" DATETIME(6) NULL,
 "UPDATE_BY_" VARCHAR(64) NULL,
 "ACCOUNT_" VARCHAR(64) DEFAULT ''
 NOT NULL
);
CREATE TABLE  "UC_MATRIX"
(
 "ID_" VARCHAR(64) NOT NULL,
 "CODE_" VARCHAR(255) DEFAULT NULL
 NULL,
 "NAME_" VARCHAR(255) DEFAULT NULL
 NULL,
 "TYPE_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "TYPE_NAME_" VARCHAR(255) DEFAULT NULL
 NULL,
 "STATUS_" INTEGER DEFAULT NULL
 NULL,
 "MANAGER_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "MANAGER_NAME_" VARCHAR(255) DEFAULT NULL
 NULL,
 "IS_DELE_" INTEGER DEFAULT NULL
 NULL,
 "CREATE_BY_" VARCHAR(64) DEFAULT NULL
 NULL,
 "CREATE_TIME_" DATETIME(6) DEFAULT NULL
 NULL,
 "CREATE_ORG_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "UPDATE_BY_" VARCHAR(64) DEFAULT NULL
 NULL,
 "UPDATE_TIME_" DATETIME(6) DEFAULT NULL
 NULL,
 "TENANT_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "ENABLED_" NUMBER DEFAULT 1
 NULL
);

CREATE TABLE  "UC_LOGIN_LOG"
(
 "ID_" VARCHAR(64) NOT NULL,
 "NAME_" VARCHAR(64) DEFAULT NULL
 NULL,
 "ACCOUNT_" VARCHAR(64) DEFAULT NULL
 NULL,
 "IP_" VARCHAR(20) DEFAULT NULL
 NULL,
 "LOGIN_TYPE_" VARCHAR(20) DEFAULT NULL
 NULL,
 "PC_SUM_" INTEGER DEFAULT 0
 NULL,
 "MOBILE_SUM_" INTEGER DEFAULT 0
 NULL,
 "LOGIN_SUM_" INTEGER DEFAULT NULL
 NULL,
 "CREATE_BY_" VARCHAR(64) DEFAULT NULL
 NULL,
 "CREATE_TIME_" DATETIME(6) NULL,
 "UPDATE_TIME_" DATETIME(6) NULL,
 "CREATE_ORG_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "UPDATE_BY_" VARCHAR(64) DEFAULT NULL
 NULL,
 "TENANT_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "IS_DELE_" CHAR(1) DEFAULT NULL
 NULL,
 "VERSION_" INTEGER DEFAULT NULL
 NULL
);
CREATE TABLE  "UC_HOLIDAY_TIME"
(
 "ID_" VARCHAR(64) NOT NULL,
 "START_TIME_" DATETIME(6) DEFAULT NULL
 NULL,
 "END_TIME_" DATETIME(6) DEFAULT NULL
 NULL,
 "HOLIDAY_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "TENANT_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "TYPE_" SMALLINT NULL
);
CREATE TABLE  "UC_HOLIDAY"
(
 "ID_" VARCHAR(64) NOT NULL,
 "NAME_" VARCHAR(128) DEFAULT NULL
 NULL,
 "KEY_" VARCHAR(128) DEFAULT NULL
 NULL,
 "DESC_" CLOB NULL,
 "IS_DELE_" SMALLINT DEFAULT NULL
 NULL,
 "CREATE_TIME_" DATETIME(6) DEFAULT NULL
 NULL,
 "UPDATE_TIME_" DATETIME(6) DEFAULT NULL
 NULL,
 "CREATE_BY_" VARCHAR(64) DEFAULT NULL
 NULL,
 "UPDATE_BY_" VARCHAR(64) DEFAULT NULL
 NULL,
 "CREATE_ORG_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "VERSION_" INTEGER DEFAULT NULL
 NULL,
 "TENANT_ID_" VARCHAR(64) DEFAULT NULL
 NULL
);
CREATE TABLE  "UC_GROUP_USER"
(
 "ID_" VARCHAR(64) NOT NULL,
 "GROUP_ID_" VARCHAR(64) NULL,
 "USER_ID" VARCHAR(64) NULL,
 "TENANT_ID_" VARCHAR(64) NULL,
 "SN_" INT NULL
);
CREATE TABLE  "UC_GROUP"
(
 "ID_" VARCHAR(64) NOT NULL,
 "GROUP_NAME" VARCHAR(255) NULL,
 "CODE_" VARCHAR(64) NULL,
 "CREATE_BY_" VARCHAR(64) NULL,
 "CREATOR_NAME_" VARCHAR(255) NULL,
 "CREATE_ORG_ID_" VARCHAR(64) NULL,
 "UPDATE_BY_" VARCHAR(64) NULL,
 "CREATE_TIME_" DATETIME(6) NULL,
 "UPDATE_TIME_" DATETIME(6) NULL,
 "TENANT_ID_" VARCHAR(64) NULL
);
CREATE TABLE  "UC_ELECTRONIC_SEAL"
(
 "ID_" VARCHAR(64) NOT NULL,
 "USER_ID_" VARCHAR(64) NULL,
 "FILE_ID_" VARCHAR(64) NULL,
 "PASSWORD_" VARCHAR(64) NULL,
 "IS_USE_" INTEGER NULL,
 "CREATE_TIME_" DATETIME(6) DEFAULT NULL
 NULL,
 "UPDATE_TIME_" DATETIME(6) DEFAULT NULL
 NULL,
 "CREATE_ORG_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "CREATE_BY_" VARCHAR(64) DEFAULT NULL
 NULL,
 "UPDATE_BY_" VARCHAR(64) DEFAULT NULL
 NULL,
 "TENANT_ID_" VARCHAR(64) DEFAULT NULL
 NULL
);
CREATE TABLE  "UC_DEMENSION"
(
 "ID_" VARCHAR(64) NOT NULL,
 "DEM_NAME_" VARCHAR(64) DEFAULT NULL
 NULL,
 "CODE_" VARCHAR(64) DEFAULT NULL
 NULL,
 "IS_DEFAULT_" INTEGER DEFAULT NULL
 NULL,
 "DEM_DESC_" VARCHAR(255) DEFAULT NULL
 NULL,
 "ORGAN_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "IS_DELE_" CHAR(1) DEFAULT '0'
 NULL,
 "VERSION_" INTEGER DEFAULT NULL
 NULL,
 "UPDATE_TIME_" DATETIME(6) NULL,
 "CREATE_BY_" VARCHAR(64) DEFAULT NULL
 NULL,
 "CREATE_TIME_" DATETIME(6) NULL,
 "CREATE_ORG_ID_" VARCHAR(64) DEFAULT NULL
 NULL,
 "UPDATE_BY_" VARCHAR(64) DEFAULT NULL
 NULL,
 "TENANT_ID_" VARCHAR(64) DEFAULT NULL
 NULL
);
CREATE TABLE  "UC_BATCH_SYNC"
(
 "ID_" VARCHAR(64) NOT NULL,
 "EXECUTE_TIME_" DATETIME(6) NULL,
 "DATA_IDS_" CLOB NULL,
 "STATUS_" INT DEFAULT 0
 NULL,
 "CREATE_TIME_" DATETIME(6) NULL,
 "UPDATE_TIME_" DATETIME(6) NULL,
 "CREATE_BY_" VARCHAR(64) NULL,
 "CREATE_ORG_ID_" VARCHAR(64) NULL,
 "UPDATE_BY_" VARCHAR(64) NULL
);

INSERT INTO  "UC_DEMENSION"("ID_","DEM_NAME_","CODE_","IS_DEFAULT_","DEM_DESC_","ORGAN_ID_","IS_DELE_","VERSION_","UPDATE_TIME_","CREATE_BY_","CREATE_TIME_","CREATE_ORG_ID_","UPDATE_BY_","TENANT_ID_") VALUES('1258608622670319616','行政维度','xzwd',1,null,'0','0',null,null,'1',null,null,'1','-1');


INSERT INTO  "UC_ORG_JOB"("ID_","NAME_","CODE_","JOB_LEVEL_","DESCRIPTION_","UPDATE_TIME_","IS_DELE_","VERSION_","CREATE_BY_","CREATE_ORG_ID_","CREATE_TIME_","UPDATE_BY_","TENANT_ID_") VALUES('1258608888039739392','职员','zy',null,null,null,'0',null,'1',null,null,null,'-1');

INSERT INTO  "UC_PWD_STRATEGY"("ID_","INIT_PWD_","PWD_RULE_","PWD_LENGTH_","DURATION_","ENABLE_","TENANT_ID_") VALUES('1','123456',1,6,7,0,'-1');

INSERT INTO  "UC_ROLE"("ID_","NAME_","CODE_","ENABLED_","DESCRIPTION_","UPDATE_TIME_","IS_DELE_","VERSION_","CREATE_BY_","UPDATE_BY_","CREATE_ORG_ID_","CREATE_TIME_","TENANT_ID_") VALUES('61120','系统管理员','xtgly',1,null,null,'0',1,'1',null,null,null,'-1');
INSERT INTO  "UC_ROLE"("ID_","NAME_","CODE_","ENABLED_","DESCRIPTION_","UPDATE_TIME_","IS_DELE_","VERSION_","CREATE_BY_","UPDATE_BY_","CREATE_ORG_ID_","CREATE_TIME_","TENANT_ID_") VALUES('1258644408874700800','人事管理员','rsgly',1,null,null,'0',null,'1',null,null,null,'-1');
INSERT INTO  "UC_ROLE"("ID_","NAME_","CODE_","ENABLED_","DESCRIPTION_","UPDATE_TIME_","IS_DELE_","VERSION_","CREATE_BY_","UPDATE_BY_","CREATE_ORG_ID_","CREATE_TIME_","TENANT_ID_") VALUES('1258644453707616256','流程管理员','lcgly',1,null,null,'0',null,'1',null,null,null,'-1');
INSERT INTO  "UC_ROLE"("ID_","NAME_","CODE_","ENABLED_","DESCRIPTION_","UPDATE_TIME_","IS_DELE_","VERSION_","CREATE_BY_","UPDATE_BY_","CREATE_ORG_ID_","CREATE_TIME_","TENANT_ID_") VALUES('1258644481708789760','一般用户','ybyh',1,null,null,'0',null,'1',null,null,null,'-1');

INSERT INTO  "UC_TENANT_MANAGE"("ID_","TYPE_ID_","NAME_","CODE_","STATUS_","SHORTHAND_","DOMAIN_","MANAGE_LOGO_","FRONT_LOGO_","ICO_","DESC_","CREATE_TIME_","CREATE_BY_","CREATE_ORG_ID_","UPDATE_TIME_","IS_DELE_","NAME_FRONT_","UPDATE_BY_","BASE_URL_") VALUES('-1','1','宏天企业信息平台','platform','enable',null,null,null,null,null,null,null,null,null,null,'0',null,'1',null);

INSERT INTO  "UC_TENANT_TYPE"("ID_","NAME_","CODE_","STATUS_","IS_DEFAULT_","DESC_","CREATE_TIME_","CREATE_BY_","CREATE_ORG_ID_","UPDATE_TIME_","UPDATE_BY_") VALUES('1','平台租户','platform','enable','1','平台租户',null,null,null,null,null);

INSERT INTO  "UC_USER"("ID_","FULLNAME_","ACCOUNT_","PASSWORD_","EMAIL_","MOBILE_","WEIXIN_","CREATE_TIME_","CREATE_ORG_ID_","UPDATE_BY_","TENANT_ID_","ADDRESS_","PHOTO_","SEX_","FROM_","STATUS_","HAS_SYNC_TO_WX_","NOTIFY_TYPE_","USER_NUMBER_","ID_CARD_","PHONE_","BIRTHDAY_","ENTRY_DATE_","LEAVE_DATE_","EDUCATION_","UPDATE_TIME_","CREATE_BY_","IS_DELE_","VERSION_","PWD_CREATE_TIME_","CLIENT_ID_","CLIENT_TOKEN_","TWO_VERIFY_SECRET_") VALUES('1','超级管理员','admin','jZae727K08KaOmKSgOaGzww/XVqGr/PKEgIMkjrcbJI=',null,'18888888888',null,null,null,null,'-1',null,null,null,'system',1,1,null,'1',null,null,null,null,null,null,null,null,'0',30,null,null,null,null);
INSERT INTO  "UC_USER"("ID_","FULLNAME_","ACCOUNT_","PASSWORD_","EMAIL_","MOBILE_","WEIXIN_","CREATE_TIME_","CREATE_ORG_ID_","UPDATE_BY_","TENANT_ID_","ADDRESS_","PHOTO_","SEX_","FROM_","STATUS_","HAS_SYNC_TO_WX_","NOTIFY_TYPE_","USER_NUMBER_","ID_CARD_","PHONE_","BIRTHDAY_","ENTRY_DATE_","LEAVE_DATE_","EDUCATION_","UPDATE_TIME_","CREATE_BY_","IS_DELE_","VERSION_","PWD_CREATE_TIME_","CLIENT_ID_","CLIENT_TOKEN_","TWO_VERIFY_SECRET_") VALUES('-1','游客账号','guest','jZae727K08KaOmKSgOaGzww/XVqGr/PKEgIMkjrcbJI=',null,'18888888889',null,null,null,null,'-1',null,null,null,'system',1,1,null,'1',null,null,null,null,null,null,null,null,'0',30,null,null,null,null);

CREATE VIEW  "USERINFO" ("ID_","FULLNAME_","ACCOUNT_","ORGNAME","POSNAME","JOBNAME","ORGID","POSTID","JOBID","ORGCODE","POSTCODE","JOBCODE","TENANT_ID_")   as (( SELECT
	a.ID_ AS ID_,
	a.FULLNAME_ AS FULLNAME_,
	a.ACCOUNT_ AS ACCOUNT_,
	c.NAME_ AS ORGNAME,
	e.POS_NAME_ AS POSNAME,
	d.NAME_ AS JOBNAME,
	c.ID_ AS ORGID,
	e.ID_ AS POSTID,
	d.ID_ AS JOBID,
	c.CODE_ AS ORGCODE,
	e.CODE_ AS POSTCODE,
	d.CODE_ AS JOBCODE,-(
		1
	) AS TENANT_ID_
	FROM
		((((
						uc_user a
						LEFT JOIN uc_org_user b ON ((
								a.ID_ = b.USER_ID_
							)))
					LEFT JOIN uc_org c ON ((
							b.ORG_ID_ = c.ID_
						)))
				LEFT JOIN uc_org_post e ON ((
						b.POS_ID_ = e.ID_
					)))
			LEFT JOIN uc_org_job d ON ((
					e.JOB_ID_ = d.ID_
				)))
	WHERE
		((
				a.STATUS_ = '1'
				)
		AND ( a.IS_DELE_ = '0' )
	AND ( e.POS_NAME_ IS NOT NULL ))));

	
ALTER TABLE  "UC_USER_UNITE" ADD CONSTRAINT "PK_UC_USER_UNITE" PRIMARY KEY("ID_") ;

ALTER TABLE  "UC_USER_UNDER" ADD CONSTRAINT "PK_UC_USER_UNDER" PRIMARY KEY("ID_") ;

ALTER TABLE  "UC_USER_ROLE" ADD CONSTRAINT "PK_UC_USER_ROLE" PRIMARY KEY("ID_") ;

ALTER TABLE  "UC_USER_REL" ADD CONSTRAINT "PK_UC_USER_REL" PRIMARY KEY("ID_") ;

ALTER TABLE  "UC_USER_PARAMS" ADD CONSTRAINT "PK_UC_USER_PARAMS" PRIMARY KEY("ID_") ;

ALTER TABLE  "UC_USER_GROUP" ADD CONSTRAINT "PK_UC_USER_GROUP" PRIMARY KEY("ID_") ;

ALTER TABLE  "UC_USER" ADD CONSTRAINT "PK_UC_USER" PRIMARY KEY("ID_") ;

ALTER TABLE  "UC_TENANT_TYPE" ADD CONSTRAINT "PK_UC_TENANT_TYPE" PRIMARY KEY("ID_") ;

ALTER TABLE  "UC_TENANT_PARAMS" ADD CONSTRAINT "PK_UC_TENANT_PARAMS" PRIMARY KEY("ID_") ;

ALTER TABLE  "UC_TENANT_MANAGE" ADD CONSTRAINT "PK_UC_TENANT_MANAGE" PRIMARY KEY("ID_") ;

ALTER TABLE  "UC_TENANT_MAIL_SERVER" ADD CONSTRAINT "PK_UC_TENANT_MAIL_SERVER" PRIMARY KEY("ID_") ;

ALTER TABLE  "UC_TENANT_LOGS" ADD CONSTRAINT "PK_UC_TENANT_LOGS" PRIMARY KEY("ID_") ;

ALTER TABLE  "UC_TENANT_IGNORE_MENU" ADD CONSTRAINT "PK_UC_TENANT_IGNORE_MENU" PRIMARY KEY("ID_") ;

ALTER TABLE  "UC_TENANT_AUTH" ADD CONSTRAINT "PK_UC_TENANT_AUTH" PRIMARY KEY("ID_") ;

ALTER TABLE  "UC_SHIFT_USER" ADD CONSTRAINT "PK_UC_SHIFT_USER" PRIMARY KEY("ID_") ;

ALTER TABLE  "UC_SHIFT_RULE" ADD CONSTRAINT "PK_UC_SHIFT_RULE" PRIMARY KEY("ID_") ;

ALTER TABLE  "UC_ROLE" ADD CONSTRAINT "PK_UC_ROLE" PRIMARY KEY("ID_") ;

ALTER TABLE  "UC_REL_TYPE" ADD CONSTRAINT "PK_UC_REL_TYPE" PRIMARY KEY("ID_") ;

ALTER TABLE  "UC_REL_AUTH" ADD CONSTRAINT "PK_UC_REL_AUTH" PRIMARY KEY("ID_") ;

ALTER TABLE  "UC_PWD_STRATEGY" ADD CONSTRAINT "PK_UC_PWD_STRATEGY" PRIMARY KEY("ID_") ;

ALTER TABLE  "UC_PROPERTIES" ADD CONSTRAINT "PK_UC_PROPERTIES" PRIMARY KEY("ID_") ;

ALTER TABLE  "UC_PARAMS" ADD CONSTRAINT "PK_UC_PARAMS" PRIMARY KEY("ID_") ;

ALTER TABLE  "UC_ORGAN" ADD CONSTRAINT "PK_UC_ORGAN" PRIMARY KEY("ID_") ;

ALTER TABLE  "UC_ORG_USER" ADD CONSTRAINT "PK_UC_ORG_USER" PRIMARY KEY("ID_") ;

ALTER TABLE  "UC_ORG_UNITE" ADD CONSTRAINT "SYS_C00143854" PRIMARY KEY("ID_") ;

ALTER TABLE  "UC_ORG_ROLE" ADD CONSTRAINT "PK_UC_ORG_ROLE" PRIMARY KEY("ID_") ;

ALTER TABLE  "UC_ORG_POST" ADD CONSTRAINT "PK_UC_ORG_POST" PRIMARY KEY("ID_") ;

ALTER TABLE  "UC_ORG_PARAMS" ADD CONSTRAINT "PK_UC_ORG_PARAMS" PRIMARY KEY("ID_") ;

ALTER TABLE  "UC_ORG_JOB" ADD CONSTRAINT "PK_UC_ORG_JOB" PRIMARY KEY("ID_") ;

ALTER TABLE  "UC_ORG_AUTH" ADD CONSTRAINT "PK_UC_ORG_AUTH" PRIMARY KEY("ID_") ;

ALTER TABLE  "UC_ORG" ADD CONSTRAINT "PK_UC_ORG" PRIMARY KEY("ID_") ;

ALTER TABLE  "UC_OPERATE_LOG" ADD CONSTRAINT "PK_UC_OPERATE_LOG" PRIMARY KEY("ID_") ;

ALTER TABLE  "UC_ONE_TIME_CODE" ADD CONSTRAINT  PRIMARY KEY("ID_") ;

ALTER TABLE  "UC_MATRIX_PROC_RELATION" ADD CONSTRAINT  PRIMARY KEY("ID_") ;

ALTER TABLE  "UC_MATRIX_COL_DEF" ADD CONSTRAINT "PK_UC_MATRIX_COL_DEF" PRIMARY KEY("ID_") ;

ALTER TABLE  "UC_MATRIX_AUTH" ADD CONSTRAINT  PRIMARY KEY("ID_") ;

ALTER TABLE  "UC_MATRIX" ADD CONSTRAINT "PK_UC_MATRIX" PRIMARY KEY("ID_") ;

ALTER TABLE  "UC_LOGIN_LOG" ADD CONSTRAINT "PK_UC_LOGIN_LOG" PRIMARY KEY("ID_") ;

ALTER TABLE  "UC_HOLIDAY_TIME" ADD CONSTRAINT "PK_UC_HOLIDAY_TIME" PRIMARY KEY("ID_") ;

ALTER TABLE  "UC_HOLIDAY" ADD CONSTRAINT "PK_UC_HOLIDAY" PRIMARY KEY("ID_") ;

ALTER TABLE  "UC_GROUP_USER" ADD CONSTRAINT "UC_GROUP_USER_PK" PRIMARY KEY("ID_") ;

ALTER TABLE  "UC_GROUP" ADD CONSTRAINT "UC_GROUP_PK" PRIMARY KEY("ID_") ;

ALTER TABLE  "UC_ELECTRONIC_SEAL" ADD CONSTRAINT "PK_UC_ELECTRONIC_SEAL" PRIMARY KEY("ID_") ;

ALTER TABLE  "UC_DEMENSION" ADD CONSTRAINT "PK_UC_DEMENSION" PRIMARY KEY("ID_") ;

ALTER TABLE  "UC_BATCH_SYNC" ADD CONSTRAINT  PRIMARY KEY("ID_") ;

CREATE INDEX "IDX_USER_UNITE_USERID"
ON  "UC_USER_UNITE"("USER_ID_");

COMMENT ON TABLE  "UC_USER_UNITE" IS '用户与外部通讯录关系表';

COMMENT ON COLUMN  "UC_USER_UNITE"."ID_" IS '主键';

COMMENT ON COLUMN  "UC_USER_UNITE"."USER_ID_" IS '用户id';

COMMENT ON COLUMN  "UC_USER_UNITE"."OPEN_ID_" IS '公众号openid';

COMMENT ON COLUMN  "UC_USER_UNITE"."WX_WORK_ID_" IS '企业微信userid';

COMMENT ON COLUMN  "UC_USER_UNITE"."DINGTALK_ID_" IS '阿里钉钉userid';

COMMENT ON COLUMN  "UC_USER_UNITE"."TENANT_ID_" IS '租户id';

COMMENT ON COLUMN  "UC_USER_UNITE"."MP_OPEN_ID_" IS '微信小程序openid';

COMMENT ON COLUMN  "UC_USER_UNITE"."FLYBOOK_ID_" IS '飞书用户ID';

CREATE INDEX "IDX_USER_UNDER_USERID"
ON  "UC_USER_UNDER"("USER_ID_");

COMMENT ON TABLE  "UC_USER_UNDER" IS '下属管理';

COMMENT ON COLUMN  "UC_USER_UNDER"."USER_ID_" IS '用户id';

COMMENT ON COLUMN  "UC_USER_UNDER"."UNDER_USER_ID_" IS '下属用户id';

COMMENT ON COLUMN  "UC_USER_UNDER"."UNDER_USER_NAME_" IS '下属用户名';

COMMENT ON COLUMN  "UC_USER_UNDER"."ORG_ID_" IS '组织id';

COMMENT ON COLUMN  "UC_USER_UNDER"."IS_DELE_" IS '是否已删，1已删除，0未删除';

COMMENT ON COLUMN  "UC_USER_UNDER"."VERSION_" IS '版本号';

CREATE INDEX "IDX_USER_ROLE_ROLEID"
ON  "UC_USER_ROLE"("ROLE_ID_");

CREATE INDEX "IDX_USER_ROLE_USERID"
ON  "UC_USER_ROLE"("USER_ID_");

COMMENT ON TABLE  "UC_USER_ROLE" IS '用户角色管理';

COMMENT ON COLUMN  "UC_USER_ROLE"."ROLE_ID_" IS '角色id';

COMMENT ON COLUMN  "UC_USER_ROLE"."USER_ID_" IS '用户id';

COMMENT ON COLUMN  "UC_USER_ROLE"."IS_DELE_" IS '是否已删，1已删除，0未删除';

COMMENT ON COLUMN  "UC_USER_ROLE"."VERSION_" IS '版本号';

CREATE INDEX "IDX_USER_REL_PARENTID"
ON  "UC_USER_REL"("PARENT_ID_");

COMMENT ON TABLE  "UC_USER_REL" IS '用户关系表';

COMMENT ON COLUMN  "UC_USER_REL"."NAME_" IS '名称';

COMMENT ON COLUMN  "UC_USER_REL"."LEVEL_" IS '级别(用于区分有多个上级的情况)';

COMMENT ON COLUMN  "UC_USER_REL"."PARENT_ID_" IS '父id';

COMMENT ON COLUMN  "UC_USER_REL"."TYPE_ID_" IS '用户关系分类下的id';

COMMENT ON COLUMN  "UC_USER_REL"."GROUP_TYPE_" IS '群组id';

COMMENT ON COLUMN  "UC_USER_REL"."PATH_" IS '组织id路径，包含层级关系';

COMMENT ON COLUMN  "UC_USER_REL"."VALUE_" IS '值';

COMMENT ON COLUMN  "UC_USER_REL"."STATUS_" IS '状态（1：正常，0：失效）';

COMMENT ON COLUMN  "UC_USER_REL"."ALIAS_" IS '用户组别名';

COMMENT ON COLUMN  "UC_USER_REL"."IS_DELE_" IS '是否已删，1已删除，0未删除';

COMMENT ON COLUMN  "UC_USER_REL"."VERSION_" IS '版本号';

CREATE INDEX "IDX_USER_PARAMS_USERID"
ON  "UC_USER_PARAMS"("USER_ID_");

CREATE INDEX "IDX_USER_PARAMS_CODE"
ON  "UC_USER_PARAMS"("CODE_");

COMMENT ON TABLE  "UC_USER_PARAMS" IS '用户数';

COMMENT ON COLUMN  "UC_USER_PARAMS"."USER_ID_" IS '用户id';

COMMENT ON COLUMN  "UC_USER_PARAMS"."CODE_" IS '参数代码';

COMMENT ON COLUMN  "UC_USER_PARAMS"."VALUE_" IS '参数值';

COMMENT ON COLUMN  "UC_USER_PARAMS"."IS_DELE_" IS '是否已删，1已删除，0未删除';

COMMENT ON COLUMN  "UC_USER_PARAMS"."VERSION_" IS '版本号';

CREATE UNIQUE INDEX "IDX_GROUP_CODE_UNQ"
ON  "UC_USER_GROUP"("CODE_","TENANT_ID_");

COMMENT ON TABLE  "UC_USER_GROUP" IS '群组管理';

COMMENT ON COLUMN  "UC_USER_GROUP"."NAME_" IS '名称';

COMMENT ON COLUMN  "UC_USER_GROUP"."JSON_" IS '群里的人或组';

COMMENT ON COLUMN  "UC_USER_GROUP"."CODE_" IS '群组代码';

COMMENT ON COLUMN  "UC_USER_GROUP"."DESCRIPTION_" IS '描述';

COMMENT ON COLUMN  "UC_USER_GROUP"."USER_ID_" IS '用户id';

COMMENT ON COLUMN  "UC_USER_GROUP"."ORG_ID_" IS '组织id';

COMMENT ON COLUMN  "UC_USER_GROUP"."ROLE_ID_" IS '角色id';

COMMENT ON COLUMN  "UC_USER_GROUP"."POS_ID_" IS '岗位id';

COMMENT ON COLUMN  "UC_USER_GROUP"."IS_DELE_" IS '是否已删，1已删除，0未删除';

COMMENT ON COLUMN  "UC_USER_GROUP"."VERSION_" IS '版本号';

CREATE UNIQUE INDEX "IDX_ACCOUNT_UNQ"
ON  "UC_USER"("ACCOUNT_","TENANT_ID_");

COMMENT ON TABLE  "UC_USER" IS '用户管理';

COMMENT ON COLUMN  "UC_USER"."FULLNAME_" IS '姓名';

COMMENT ON COLUMN  "UC_USER"."ACCOUNT_" IS '帐号';

COMMENT ON COLUMN  "UC_USER"."PASSWORD_" IS '密码';

COMMENT ON COLUMN  "UC_USER"."EMAIL_" IS '邮箱';

COMMENT ON COLUMN  "UC_USER"."MOBILE_" IS '手机号码';

COMMENT ON COLUMN  "UC_USER"."WEIXIN_" IS '微信号';

COMMENT ON COLUMN  "UC_USER"."ADDRESS_" IS '地址';

COMMENT ON COLUMN  "UC_USER"."PHOTO_" IS '头像';

COMMENT ON COLUMN  "UC_USER"."SEX_" IS '性别：男，女，未知';

COMMENT ON COLUMN  "UC_USER"."FROM_" IS '来源';

COMMENT ON COLUMN  "UC_USER"."STATUS_" IS '0:禁用，1正常';

COMMENT ON COLUMN  "UC_USER"."HAS_SYNC_TO_WX_" IS '微信同步关注状态: 0：未同步  1：已同步，尚未关注  2：已同步且已关注';

COMMENT ON COLUMN  "UC_USER"."NOTIFY_TYPE_" IS '自定义接收消息类型';

COMMENT ON COLUMN  "UC_USER"."USER_NUMBER_" IS '工号';

COMMENT ON COLUMN  "UC_USER"."ID_CARD_" IS '身份证号';

COMMENT ON COLUMN  "UC_USER"."PHONE_" IS '办公电话';

COMMENT ON COLUMN  "UC_USER"."EDUCATION_" IS '学历';

COMMENT ON COLUMN  "UC_USER"."IS_DELE_" IS '是否已删，1已删除，0未删除';

COMMENT ON COLUMN  "UC_USER"."VERSION_" IS '版本号';

COMMENT ON COLUMN  "UC_USER"."CLIENT_ID_" IS '推送服务令牌（设备唯一标识）';

COMMENT ON COLUMN  "UC_USER"."CLIENT_TOKEN_" IS '设备令牌（iOS设备唯一标识）';

COMMENT ON COLUMN  "UC_USER"."TWO_VERIFY_SECRET_" IS '双因素验证绑定密钥';

CREATE INDEX "IDX_TENANT_TYPE_CODE"
ON  "UC_TENANT_TYPE"("CODE_");

COMMENT ON TABLE  "UC_TENANT_TYPE" IS '租户类型';

CREATE INDEX "IDX_TENANT_PARAMS_TENANTID"
ON  "UC_TENANT_PARAMS"("TENANT_ID_");

CREATE INDEX "IDX_TENANT_PARAMS_CODE"
ON  "UC_TENANT_PARAMS"("CODE_");

COMMENT ON TABLE  "UC_TENANT_PARAMS" IS '租户拓展参数';

CREATE INDEX "IDX_TENANT_MANAGE_TYPEID"
ON  "UC_TENANT_MANAGE"("TYPE_ID_");

CREATE UNIQUE INDEX "IDX_TENANT_CODE_UNQ"
ON  "UC_TENANT_MANAGE"("CODE_");

COMMENT ON TABLE  "UC_TENANT_MANAGE" IS '租户管理';

COMMENT ON COLUMN  "UC_TENANT_MANAGE"."IS_DELE_" IS '是否已删，1已删除，0未删除';

COMMENT ON COLUMN  "UC_TENANT_MANAGE"."NAME_FRONT_" IS '应用端租户名称';

COMMENT ON COLUMN  "UC_TENANT_MANAGE"."BASE_URL_" IS '租户域名';

CREATE INDEX "IDX_TENANT_MAIL_TENANTID"
ON  "UC_TENANT_MAIL_SERVER"("TENANT_ID_");

COMMENT ON TABLE  "UC_TENANT_MAIL_SERVER" IS '租户邮件服务器';

COMMENT ON COLUMN  "UC_TENANT_MAIL_SERVER"."MAIL_PORT_" IS '端口号';

COMMENT ON COLUMN  "UC_TENANT_MAIL_SERVER"."USE_SSL_" IS '是否使用SSL认证。0：否；1：是';

COMMENT ON COLUMN  "UC_TENANT_MAIL_SERVER"."SMTP_HOST_" IS 'smt主机';

COMMENT ON COLUMN  "UC_TENANT_MAIL_SERVER"."SEND_PORT_" IS '邮件服务器的端口';

CREATE INDEX "IDX_TENANT_LOGS_TENANTID"
ON  "UC_TENANT_LOGS"("TENANT_ID_");

COMMENT ON TABLE  "UC_TENANT_LOGS" IS '租户管理操作日志';

COMMENT ON COLUMN  "UC_TENANT_LOGS"."RESULT_" IS '操作结果（1:成功，0:失败）';

CREATE INDEX "IDX_TENANT_IGNOREMENU_TENANTID"
ON  "UC_TENANT_IGNORE_MENU"("TENANT_ID_");

COMMENT ON TABLE  "UC_TENANT_IGNORE_MENU" IS '租户禁用菜单';

CREATE INDEX "IDX_TENANT_AUTH_USERID"
ON  "UC_TENANT_AUTH"("USER_ID_");

COMMENT ON TABLE  "UC_TENANT_AUTH" IS '租户管理员';

CREATE INDEX "IDX_SHIFT_USER_SHIFTID"
ON  "UC_SHIFT_USER"("SHIFT_ID_");

CREATE INDEX "IDX_SHIFT_USER_USERID"
ON  "UC_SHIFT_USER"("USER_ID_");

COMMENT ON TABLE  "UC_SHIFT_USER" IS '排班用户表';

COMMENT ON COLUMN  "UC_SHIFT_USER"."ID_" IS '主键';

COMMENT ON COLUMN  "UC_SHIFT_USER"."USER_ID_" IS '用户ID';

COMMENT ON COLUMN  "UC_SHIFT_USER"."SHIFT_ID_" IS '排班ID';

COMMENT ON COLUMN  "UC_SHIFT_USER"."TENANT_ID_" IS '租户ID';

COMMENT ON COLUMN  "UC_SHIFT_USER"."IS_DELE_" IS '是否已删，1已删除，0未删除';

COMMENT ON COLUMN  "UC_SHIFT_USER"."VERSION_" IS '版本';

COMMENT ON COLUMN  "UC_SHIFT_USER"."CREATE_BY_" IS '创建人ID';

COMMENT ON COLUMN  "UC_SHIFT_USER"."UPDATE_BY_" IS '更新人ID';

COMMENT ON COLUMN  "UC_SHIFT_USER"."CREATE_TIME_" IS '创建时间';

COMMENT ON COLUMN  "UC_SHIFT_USER"."UPDATE_TIME_" IS '更新时间';

COMMENT ON COLUMN  "UC_SHIFT_USER"."CREATE_ORG_ID_" IS '创建者所属组织ID';

CREATE INDEX "IDX_SHIFT_RULE_ISDELE"
ON  "UC_SHIFT_RULE"("IS_DELE_");

COMMENT ON TABLE  "UC_SHIFT_RULE" IS '排班规则';

COMMENT ON COLUMN  "UC_SHIFT_RULE"."ID_" IS '主键';

COMMENT ON COLUMN  "UC_SHIFT_RULE"."NAME_" IS '名称';

COMMENT ON COLUMN  "UC_SHIFT_RULE"."KEY_" IS 'KEY';

COMMENT ON COLUMN  "UC_SHIFT_RULE"."DESC_" IS '描述';

COMMENT ON COLUMN  "UC_SHIFT_RULE"."RULE_" IS '规则';

COMMENT ON COLUMN  "UC_SHIFT_RULE"."HOLIDAY_ID_" IS '节假日ID';

COMMENT ON COLUMN  "UC_SHIFT_RULE"."IS_DELE_" IS '是否删除 1删除 0未删除';

COMMENT ON COLUMN  "UC_SHIFT_RULE"."CREATE_TIME_" IS '创建时间';

COMMENT ON COLUMN  "UC_SHIFT_RULE"."UPDATE_TIME_" IS '更新时间';

COMMENT ON COLUMN  "UC_SHIFT_RULE"."CREATE_BY_" IS '创建人';

COMMENT ON COLUMN  "UC_SHIFT_RULE"."UPDATE_BY_" IS '更新人';

COMMENT ON COLUMN  "UC_SHIFT_RULE"."CREATE_ORG_ID_" IS '创建人组织ID';

COMMENT ON COLUMN  "UC_SHIFT_RULE"."TENANT_ID_" IS '租户ID';

COMMENT ON COLUMN  "UC_SHIFT_RULE"."VERSION_" IS '版本';

CREATE UNIQUE INDEX "IDX_ROLE_CODE"
ON  "UC_ROLE"("CODE_","TENANT_ID_","IS_DELE_");

COMMENT ON TABLE  "UC_ROLE" IS '汇报关系分类管理';

COMMENT ON COLUMN  "UC_ROLE"."NAME_" IS '角色名称';

COMMENT ON COLUMN  "UC_ROLE"."CODE_" IS '英文别名';

COMMENT ON COLUMN  "UC_ROLE"."ENABLED_" IS '可用 0：禁用，1：启用';

COMMENT ON COLUMN  "UC_ROLE"."DESCRIPTION_" IS '描述';

COMMENT ON COLUMN  "UC_ROLE"."IS_DELE_" IS '是否已删，1已删除，0未删除';

COMMENT ON COLUMN  "UC_ROLE"."VERSION_" IS '版本号';

CREATE INDEX "IDX_REL_TYPE_CODE"
ON  "UC_REL_TYPE"("CODE_");

COMMENT ON TABLE  "UC_REL_TYPE" IS '分级组织类别';

COMMENT ON COLUMN  "UC_REL_TYPE"."NAME_" IS '汇报关系分类名称';

COMMENT ON COLUMN  "UC_REL_TYPE"."CODE_" IS '英文别名';

COMMENT ON COLUMN  "UC_REL_TYPE"."DESCRIPTION_" IS '描述';

COMMENT ON COLUMN  "UC_REL_TYPE"."IS_DELE_" IS '是否已删，1已删除，0未删除';

COMMENT ON COLUMN  "UC_REL_TYPE"."VERSION_" IS '版本号';

CREATE INDEX "IDX_REL_AUTH_RELID"
ON  "UC_REL_AUTH"("REL_ID_");

CREATE INDEX "IDX_REL_AUTH_USERID"
ON  "UC_REL_AUTH"("USER_ID_");

COMMENT ON TABLE  "UC_REL_AUTH" IS '分级组织管理';

COMMENT ON COLUMN  "UC_REL_AUTH"."USER_ID_" IS '分级汇报线管理员id';

COMMENT ON COLUMN  "UC_REL_AUTH"."REL_ID_" IS '对应汇报线节点id';

COMMENT ON COLUMN  "UC_REL_AUTH"."TYPE_ID_" IS '对应汇报线分类id';

COMMENT ON COLUMN  "UC_REL_AUTH"."IS_DELE_" IS '是否已删，1已删除，0未删除';

COMMENT ON COLUMN  "UC_REL_AUTH"."VERSION_" IS '版本号';

CREATE INDEX "IDX_PWD_STRATEGY_TENANTID"
ON  "UC_PWD_STRATEGY"("TENANT_ID_");

COMMENT ON TABLE  "UC_PWD_STRATEGY" IS '密码策略';

COMMENT ON COLUMN  "UC_PWD_STRATEGY"."PWD_RULE_" IS '密码规则';

COMMENT ON COLUMN  "UC_PWD_STRATEGY"."PWD_LENGTH_" IS '密码长度';

COMMENT ON COLUMN  "UC_PWD_STRATEGY"."DURATION_" IS '密码时长（单位：天）';

COMMENT ON COLUMN  "UC_PWD_STRATEGY"."ENABLE_" IS '启用策略	0:停用，1:启用';

CREATE INDEX "IDX_UC_PROPERTIES_CODE"
ON  "UC_PROPERTIES"("CODE_");

COMMENT ON TABLE  "UC_PROPERTIES" IS '系统配置属性';

COMMENT ON COLUMN  "UC_PROPERTIES"."NAME_" IS '名称';

COMMENT ON COLUMN  "UC_PROPERTIES"."CODE_" IS '别名';

COMMENT ON COLUMN  "UC_PROPERTIES"."GROUP_" IS '分组';

COMMENT ON COLUMN  "UC_PROPERTIES"."VALUE_" IS '参数值';

COMMENT ON COLUMN  "UC_PROPERTIES"."ENCRYPT_" IS '是否加密';

COMMENT ON COLUMN  "UC_PROPERTIES"."DESCRIPTION_" IS '描述';

COMMENT ON COLUMN  "UC_PROPERTIES"."IS_DELE_" IS '是否已删，1已删除，0未删除';

CREATE UNIQUE INDEX "IDX_PARAM_CODE"
ON  "UC_PARAMS"("CODE_","TENANT_ID_","TENANT_TYPE_ID_");

COMMENT ON TABLE  "UC_PARAMS" IS '用户组织参数';

COMMENT ON COLUMN  "UC_PARAMS"."NAME_" IS '参数名称';

COMMENT ON COLUMN  "UC_PARAMS"."CODE_" IS '参数代码';

COMMENT ON COLUMN  "UC_PARAMS"."TYPE_" IS '类型';

COMMENT ON COLUMN  "UC_PARAMS"."CTL_TYPE_" IS '控件类型';

COMMENT ON COLUMN  "UC_PARAMS"."JSON_" IS 'json值';

COMMENT ON COLUMN  "UC_PARAMS"."IS_DELE_" IS '是否已删，1已删除，0未删除';

COMMENT ON COLUMN  "UC_PARAMS"."VERSION_" IS '版本号';

CREATE UNIQUE INDEX "IDX_ORGAN_CODE_UNQ"
ON  "UC_ORGAN"("CODE_");

COMMENT ON TABLE  "UC_ORGAN" IS '机构管理';

COMMENT ON COLUMN  "UC_ORGAN"."CODE_" IS '机构编码';

COMMENT ON COLUMN  "UC_ORGAN"."NAME_" IS '机构名称';

COMMENT ON COLUMN  "UC_ORGAN"."DESC_" IS '机构描述';

COMMENT ON COLUMN  "UC_ORGAN"."CREATE_BY_" IS '创建人';

COMMENT ON COLUMN  "UC_ORGAN"."IS_DELE_" IS '是否已删，1已删除，0未删除';

COMMENT ON COLUMN  "UC_ORGAN"."VERSION_" IS '版本号';

CREATE INDEX "IDX_ORG_USER_USERID"
ON  "UC_ORG_USER"("USER_ID_");

CREATE INDEX "IDX_ORG_USER_ORGID"
ON  "UC_ORG_USER"("ORG_ID_");

COMMENT ON TABLE  "UC_ORG_USER" IS '用户组织关系';

COMMENT ON COLUMN  "UC_ORG_USER"."ORG_ID_" IS '组织编号';

COMMENT ON COLUMN  "UC_ORG_USER"."USER_ID_" IS '用户编号';

COMMENT ON COLUMN  "UC_ORG_USER"."IS_MASTER_" IS '0:非主部门，1：主部门';

COMMENT ON COLUMN  "UC_ORG_USER"."POS_ID_" IS '岗位id';

COMMENT ON COLUMN  "UC_ORG_USER"."IS_CHARGE_" IS '2组织主负责人，1组织负责人，0 不是负责人';

COMMENT ON COLUMN  "UC_ORG_USER"."IS_REL_ACTIVE_" IS '是否有效，0:无效，1：有效';

COMMENT ON COLUMN  "UC_ORG_USER"."IS_DELE_" IS '是否已删，1已删除，0未删除';

COMMENT ON COLUMN  "UC_ORG_USER"."VERSION_" IS '版本号';

COMMENT ON COLUMN  "UC_ORG_USER"."DEM_ID_" IS '维度id';

COMMENT ON TABLE  "UC_ORG_UNITE" IS '组织与外部通讯录关系表';

COMMENT ON COLUMN  "UC_ORG_UNITE"."ID_" IS '主键';

COMMENT ON COLUMN  "UC_ORG_UNITE"."ORG_ID_" IS '平台组织id';

COMMENT ON COLUMN  "UC_ORG_UNITE"."WX_WORK_ID_" IS '企业微信组织id';

COMMENT ON COLUMN  "UC_ORG_UNITE"."DINGTALK_ID_" IS '阿里钉钉组织id';

COMMENT ON COLUMN  "UC_ORG_UNITE"."FLYBOOK_ID_" IS '飞书组织id';

COMMENT ON COLUMN  "UC_ORG_UNITE"."DELETE_FLAG_" IS '是否删除';

COMMENT ON COLUMN  "UC_ORG_UNITE"."UPDATE_TIME_" IS '更新时间';

COMMENT ON COLUMN  "UC_ORG_UNITE"."CREATE_TIME_" IS '创建时间';

COMMENT ON COLUMN  "UC_ORG_UNITE"."TENANT_ID_" IS '租户ID';

CREATE INDEX "IDX_ORG_ROLE_ORGID"
ON  "UC_ORG_ROLE"("ORG_ID_");

CREATE INDEX "IDX_ORG_ROLE_ROLEID"
ON  "UC_ORG_ROLE"("ROLE_ID_");

COMMENT ON TABLE  "UC_ORG_ROLE" IS '组织角色管理';

COMMENT ON COLUMN  "UC_ORG_ROLE"."ROLE_ID_" IS '角色id';

COMMENT ON COLUMN  "UC_ORG_ROLE"."ORG_ID_" IS '组织id';

COMMENT ON COLUMN  "UC_ORG_ROLE"."IS_INHERIT_" IS '子组织是否可以继承,0:不可1:可以';

COMMENT ON COLUMN  "UC_ORG_ROLE"."IS_DELE_" IS '是否已删，1已删除，0未删除';

COMMENT ON COLUMN  "UC_ORG_ROLE"."VERSION_" IS '版本号';

CREATE INDEX "IDX_ORG_POST_JOBID"
ON  "UC_ORG_POST"("JOB_ID_");

CREATE INDEX "IDX_PRG_POST_ORGID"
ON  "UC_ORG_POST"("ORG_ID_");

CREATE UNIQUE INDEX "IDX_POST_CODE_UNQ"
ON  "UC_ORG_POST"("CODE_","TENANT_ID_","IS_DELE_");

COMMENT ON TABLE  "UC_ORG_POST" IS '部门岗位';

COMMENT ON COLUMN  "UC_ORG_POST"."ORG_ID_" IS '组织id';

COMMENT ON COLUMN  "UC_ORG_POST"."JOB_ID_" IS '职务id';

COMMENT ON COLUMN  "UC_ORG_POST"."POS_NAME_" IS '岗位名称';

COMMENT ON COLUMN  "UC_ORG_POST"."CODE_" IS '岗位编码';

COMMENT ON COLUMN  "UC_ORG_POST"."IS_CHARGE_" IS '是否主岗位：1主岗位，0 非主岗位';

COMMENT ON COLUMN  "UC_ORG_POST"."IS_DELE_" IS '是否已删，1已删除，0未删除';

COMMENT ON COLUMN  "UC_ORG_POST"."VERSION_" IS '版本号';

CREATE INDEX "IDX_ORG_PARAMS_ORGID"
ON  "UC_ORG_PARAMS"("ORG_ID_");

COMMENT ON TABLE  "UC_ORG_PARAMS" IS '组织参数';

COMMENT ON COLUMN  "UC_ORG_PARAMS"."ORG_ID_" IS '组织id';

COMMENT ON COLUMN  "UC_ORG_PARAMS"."CODE_" IS '参数代码';

COMMENT ON COLUMN  "UC_ORG_PARAMS"."VALUE_" IS '值';

COMMENT ON COLUMN  "UC_ORG_PARAMS"."IS_DELE_" IS '是否已删，1已删除，0未删除';

COMMENT ON COLUMN  "UC_ORG_PARAMS"."VERSION_" IS '版本号';

CREATE UNIQUE INDEX "IDX_JOB_CODE_UNQ"
ON  "UC_ORG_JOB"("CODE_","TENANT_ID_","IS_DELE_");

COMMENT ON TABLE  "UC_ORG_JOB" IS '职务定义';

COMMENT ON COLUMN  "UC_ORG_JOB"."NAME_" IS '名称';

COMMENT ON COLUMN  "UC_ORG_JOB"."CODE_" IS '编码';

COMMENT ON COLUMN  "UC_ORG_JOB"."JOB_LEVEL_" IS '职务级别';

COMMENT ON COLUMN  "UC_ORG_JOB"."DESCRIPTION_" IS '描述';

COMMENT ON COLUMN  "UC_ORG_JOB"."IS_DELE_" IS '是否已删，1已删除，0未删除';

COMMENT ON COLUMN  "UC_ORG_JOB"."VERSION_" IS '版本号';

CREATE INDEX "IDX_ORG_AUTH_ORGID"
ON  "UC_ORG_AUTH"("ORG_ID_");

CREATE INDEX "IDX_ORG_AUTH_USERID"
ON  "UC_ORG_AUTH"("USER_ID_");

CREATE INDEX "IDX_ORG_AUTH_DEMID"
ON  "UC_ORG_AUTH"("DEM_ID_");

COMMENT ON TABLE  "UC_ORG_AUTH" IS '分级组织管理';

COMMENT ON COLUMN  "UC_ORG_AUTH"."USER_ID_" IS '分级组织管理员id';

COMMENT ON COLUMN  "UC_ORG_AUTH"."ORG_ID_" IS '对应管理组织id';

COMMENT ON COLUMN  "UC_ORG_AUTH"."DEM_ID_" IS '对应维度id';

COMMENT ON COLUMN  "UC_ORG_AUTH"."ORG_PERMS_" IS '组织管理权限';

COMMENT ON COLUMN  "UC_ORG_AUTH"."USER_PERMS_" IS '用户管理权限';

COMMENT ON COLUMN  "UC_ORG_AUTH"."POS_PERMS_" IS '岗位管理权限';

COMMENT ON COLUMN  "UC_ORG_AUTH"."ORGAUTH_PERMS_" IS '分级管理员权限';

COMMENT ON COLUMN  "UC_ORG_AUTH"."LAYOUT_PERMS_" IS '首页布局管理权限';

COMMENT ON COLUMN  "UC_ORG_AUTH"."IS_DELE_" IS '是否已删，1已删除，0未删除';

COMMENT ON COLUMN  "UC_ORG_AUTH"."VERSION_" IS '版本号';

COMMENT ON COLUMN  "UC_ORG_AUTH"."ROLE_CONFIG_" IS '角色配置';

COMMENT ON COLUMN  "UC_ORG_AUTH"."ROLE_PERMS_" IS '角色管理权限';

CREATE INDEX "IDX_ORG_PARENTID"
ON  "UC_ORG"("PARENT_ID_");

CREATE UNIQUE INDEX "IDX_ORG_CODE_UNQ"
ON  "UC_ORG"("CODE_","TENANT_ID_","IS_DELE_");

COMMENT ON TABLE  "UC_ORG" IS '组织架构';

COMMENT ON COLUMN  "UC_ORG"."NAME_" IS '名称';

COMMENT ON COLUMN  "UC_ORG"."PARENT_ID_" IS '父组织id';

COMMENT ON COLUMN  "UC_ORG"."ORDER_NO_" IS '排序号';

COMMENT ON COLUMN  "UC_ORG"."CODE_" IS '组织代码';

COMMENT ON COLUMN  "UC_ORG"."GRADE_" IS '级别';

COMMENT ON COLUMN  "UC_ORG"."PATH_" IS '组织id路径，包含层级关系';

COMMENT ON COLUMN  "UC_ORG"."PATH_NAME_" IS '组织名路径，包含层级关系';

COMMENT ON COLUMN  "UC_ORG"."DEM_ID_" IS '维度id';

COMMENT ON COLUMN  "UC_ORG"."IS_DELE_" IS '是否已删，1已删除，0未删除';

COMMENT ON COLUMN  "UC_ORG"."VERSION_" IS '版本号';

COMMENT ON COLUMN  "UC_ORG"."LIMIT_NUM_" IS '组织限编用户数量(0:不受限制)';

COMMENT ON COLUMN  "UC_ORG"."NOW_NUM_" IS '组织现编用户数量';

COMMENT ON COLUMN  "UC_ORG"."EXCEED_LIMIT_NUM_" IS '是否允许超过限编(0:允许；1:不允许)';

CREATE INDEX "IDX_OPERATE_LOG_TENANTID"
ON  "UC_OPERATE_LOG"("TENANT_ID_");

CREATE INDEX "IDX_OPERATE_LOG_CREATETIME"
ON  "UC_OPERATE_LOG"("CREATE_TIME_");

COMMENT ON TABLE  "UC_OPERATE_LOG" IS '操作日志';

COMMENT ON COLUMN  "UC_OPERATE_LOG"."REQ_IP_" IS '请求ip地址';

COMMENT ON COLUMN  "UC_OPERATE_LOG"."REQ_TYPE_" IS '请求方式';

COMMENT ON COLUMN  "UC_OPERATE_LOG"."REQ_URL_" IS '请求地址';

COMMENT ON COLUMN  "UC_OPERATE_LOG"."OPERATOR_NAME_" IS '操作人';

COMMENT ON COLUMN  "UC_OPERATE_LOG"."NOTE_" IS '说明';

COMMENT ON COLUMN  "UC_OPERATE_LOG"."SUCCESS_" IS '是否成功';

COMMENT ON COLUMN  "UC_OPERATE_LOG"."FAIL_REASON_" IS '失败原因';

COMMENT ON COLUMN  "UC_OPERATE_LOG"."IS_DELE_" IS '是否已删，1已删除，0未删除';

COMMENT ON TABLE  "UC_ONE_TIME_CODE" IS '双因素验证一次性码表';

COMMENT ON COLUMN  "UC_ONE_TIME_CODE"."ID_" IS '主键';

COMMENT ON COLUMN  "UC_ONE_TIME_CODE"."CODE_" IS '一次性验证码';

COMMENT ON COLUMN  "UC_ONE_TIME_CODE"."USER_ID_" IS '所属用户ID';

COMMENT ON COLUMN  "UC_ONE_TIME_CODE"."IS_USED_" IS '是否已使用;0:未使用 1:已使用';

COMMENT ON COLUMN  "UC_ONE_TIME_CODE"."TENANT_ID_" IS '租户id';

COMMENT ON COLUMN  "UC_ONE_TIME_CODE"."CREATE_TIME_" IS '创建时间';

COMMENT ON COLUMN  "UC_ONE_TIME_CODE"."CREATOR_" IS '创建人';

COMMENT ON COLUMN  "UC_ONE_TIME_CODE"."CREATE_BY_" IS '创建人ID';

COMMENT ON COLUMN  "UC_ONE_TIME_CODE"."IS_DELE_" IS '是否删除;0否 1是';

COMMENT ON COLUMN  "UC_MATRIX_PROC_RELATION"."ID_" IS 'id';

COMMENT ON COLUMN  "UC_MATRIX_PROC_RELATION"."MATRIX_CODE_" IS '矩阵编码';

COMMENT ON COLUMN  "UC_MATRIX_PROC_RELATION"."PROC_DEF_KEY_" IS '流程定义Key';

COMMENT ON COLUMN  "UC_MATRIX_PROC_RELATION"."PROC_DEF_NAME_" IS '流程定义名称';

COMMENT ON COLUMN  "UC_MATRIX_PROC_RELATION"."TENANT_ID_" IS '租户id';

CREATE INDEX "IDX_MATRIX_COL_DEF_MATRIXID"
ON  "UC_MATRIX_COL_DEF"("MATRIX_ID_");

CREATE INDEX "IDX_MATRIX_COL_DEF_COLTYPE"
ON  "UC_MATRIX_COL_DEF"("COL_TYPE_");

COMMENT ON TABLE  "UC_MATRIX_COL_DEF" IS '矩阵列定义';

COMMENT ON COLUMN  "UC_MATRIX_COL_DEF"."ID_" IS '主键';

COMMENT ON COLUMN  "UC_MATRIX_COL_DEF"."MATRIX_ID_" IS '所属矩阵ID';

COMMENT ON COLUMN  "UC_MATRIX_COL_DEF"."CODE_" IS '列字段名';

COMMENT ON COLUMN  "UC_MATRIX_COL_DEF"."NAME_" IS '列中文名';

COMMENT ON COLUMN  "UC_MATRIX_COL_DEF"."STATUS_" IS '列状态：0未创建列、1已创建列';

COMMENT ON COLUMN  "UC_MATRIX_COL_DEF"."COL_TYPE_" IS '列类型：1条件列、2角色列';

COMMENT ON COLUMN  "UC_MATRIX_COL_DEF"."SELECT_TYPE_" IS '选择类型：1单选、2多选';

COMMENT ON COLUMN  "UC_MATRIX_COL_DEF"."CTRL_TYPE_" IS '控件类型';

COMMENT ON COLUMN  "UC_MATRIX_COL_DEF"."QUERY_ALIAS_" IS '关联查询alias';

COMMENT ON COLUMN  "UC_MATRIX_COL_DEF"."COL_CONFIG_" IS '列配置信息';

COMMENT ON COLUMN  "UC_MATRIX_COL_DEF"."IS_DELE_" IS '是否删除：0未删、1已删';

COMMENT ON COLUMN  "UC_MATRIX_COL_DEF"."CREATE_BY_" IS '创建人';

COMMENT ON COLUMN  "UC_MATRIX_COL_DEF"."CREATE_TIME_" IS '创建时间';

COMMENT ON COLUMN  "UC_MATRIX_COL_DEF"."CREATE_ORG_ID_" IS '创建人部门id';

COMMENT ON COLUMN  "UC_MATRIX_COL_DEF"."UPDATE_BY_" IS '更新人';

COMMENT ON COLUMN  "UC_MATRIX_COL_DEF"."UPDATE_TIME_" IS '更新时间';

COMMENT ON COLUMN  "UC_MATRIX_COL_DEF"."TENANT_ID_" IS '租户id';

COMMENT ON COLUMN  "UC_MATRIX_COL_DEF"."SN_" IS '排序';

COMMENT ON COLUMN  "UC_MATRIX_COL_DEF"."BIND_KEY_" IS '条件列的回填key的绑定值';

COMMENT ON COLUMN  "UC_MATRIX_COL_DEF"."BIND_VALUE_" IS '条件列的回填value的绑定值';

COMMENT ON COLUMN  "UC_MATRIX_COL_DEF"."SEARCH_FIELD_" IS '搜索条件字段标识';

CREATE INDEX "IDX_MATRIX_AUTH_USERID"
ON  "UC_MATRIX_AUTH"("USER_ID_");

COMMENT ON TABLE  "UC_MATRIX_AUTH" IS '关系矩阵管理员';

COMMENT ON COLUMN  "UC_MATRIX_AUTH"."MATRIX_ID_" IS '关系矩阵ID';

COMMENT ON COLUMN  "UC_MATRIX_AUTH"."USER_ID_" IS '管理员ID';

COMMENT ON COLUMN  "UC_MATRIX_AUTH"."ACCOUNT_" IS '用户账号';

CREATE INDEX "IDX_UC_MATRIX_CODE"
ON  "UC_MATRIX"("CODE_");

COMMENT ON TABLE  "UC_MATRIX" IS '矩阵管理';

COMMENT ON COLUMN  "UC_MATRIX"."ID_" IS '主键';

COMMENT ON COLUMN  "UC_MATRIX"."CODE_" IS '编码/别名';

COMMENT ON COLUMN  "UC_MATRIX"."NAME_" IS '名称';

COMMENT ON COLUMN  "UC_MATRIX"."TYPE_ID_" IS '分类ID';

COMMENT ON COLUMN  "UC_MATRIX"."TYPE_NAME_" IS '分类名称';

COMMENT ON COLUMN  "UC_MATRIX"."STATUS_" IS '状态：0待发布、1已发布';

COMMENT ON COLUMN  "UC_MATRIX"."MANAGER_ID_" IS '管理员ID';

COMMENT ON COLUMN  "UC_MATRIX"."MANAGER_NAME_" IS '管理员名称';

COMMENT ON COLUMN  "UC_MATRIX"."IS_DELE_" IS '是否删除：0未除、1已删';

COMMENT ON COLUMN  "UC_MATRIX"."CREATE_BY_" IS '创建人';

COMMENT ON COLUMN  "UC_MATRIX"."CREATE_TIME_" IS '创建时间';

COMMENT ON COLUMN  "UC_MATRIX"."CREATE_ORG_ID_" IS '创建人部门id';

COMMENT ON COLUMN  "UC_MATRIX"."UPDATE_BY_" IS '更新人';

COMMENT ON COLUMN  "UC_MATRIX"."UPDATE_TIME_" IS '更新时间';

COMMENT ON COLUMN  "UC_MATRIX"."TENANT_ID_" IS '租户id';

COMMENT ON COLUMN  "UC_MATRIX"."ENABLED_" IS '是否启用: 0禁用 1启用';

CREATE INDEX "IDX_LOGIN_LOG_ACCOUNT"
ON  "UC_LOGIN_LOG"("ACCOUNT_");

COMMENT ON TABLE  "UC_LOGIN_LOG" IS '用户登录日志表';

COMMENT ON COLUMN  "UC_LOGIN_LOG"."ID_" IS '主键，用户id';

COMMENT ON COLUMN  "UC_LOGIN_LOG"."NAME_" IS '用户名';

COMMENT ON COLUMN  "UC_LOGIN_LOG"."ACCOUNT_" IS '用户账号';

COMMENT ON COLUMN  "UC_LOGIN_LOG"."IP_" IS '登录IP';

COMMENT ON COLUMN  "UC_LOGIN_LOG"."LOGIN_TYPE_" IS '登录类型（pc：电脑端登录，mobile：移动端登录）';

COMMENT ON COLUMN  "UC_LOGIN_LOG"."PC_SUM_" IS 'PC端登录次数';

COMMENT ON COLUMN  "UC_LOGIN_LOG"."MOBILE_SUM_" IS '移动端登录次数';

COMMENT ON COLUMN  "UC_LOGIN_LOG"."LOGIN_SUM_" IS '登录次数';

COMMENT ON COLUMN  "UC_LOGIN_LOG"."CREATE_BY_" IS '创建人';

COMMENT ON COLUMN  "UC_LOGIN_LOG"."CREATE_ORG_ID_" IS '创建人所属部门id';

COMMENT ON COLUMN  "UC_LOGIN_LOG"."UPDATE_BY_" IS '更新人id';

COMMENT ON COLUMN  "UC_LOGIN_LOG"."TENANT_ID_" IS '租户id';

COMMENT ON COLUMN  "UC_LOGIN_LOG"."VERSION_" IS '版本号';

COMMENT ON TABLE  "UC_HOLIDAY_TIME" IS '假期时间';

COMMENT ON COLUMN  "UC_HOLIDAY_TIME"."ID_" IS '主键';

COMMENT ON COLUMN  "UC_HOLIDAY_TIME"."START_TIME_" IS '假期开始时间';

COMMENT ON COLUMN  "UC_HOLIDAY_TIME"."END_TIME_" IS '假期结束时间';

COMMENT ON COLUMN  "UC_HOLIDAY_TIME"."HOLIDAY_ID_" IS '假期ID';

COMMENT ON COLUMN  "UC_HOLIDAY_TIME"."TENANT_ID_" IS '租户ID';

COMMENT ON COLUMN  "UC_HOLIDAY_TIME"."TYPE_" IS '类型：0假期 1补班';

COMMENT ON TABLE  "UC_HOLIDAY" IS '法定节假日';

COMMENT ON COLUMN  "UC_HOLIDAY"."ID_" IS '主键';

COMMENT ON COLUMN  "UC_HOLIDAY"."NAME_" IS '节日名称';

COMMENT ON COLUMN  "UC_HOLIDAY"."KEY_" IS '节日KEY';

COMMENT ON COLUMN  "UC_HOLIDAY"."DESC_" IS '描述';

COMMENT ON COLUMN  "UC_HOLIDAY"."IS_DELE_" IS '是否已删，1已删除，0未删除';

COMMENT ON COLUMN  "UC_HOLIDAY"."CREATE_TIME_" IS '创建时间';

COMMENT ON COLUMN  "UC_HOLIDAY"."UPDATE_TIME_" IS '更新时间';

COMMENT ON COLUMN  "UC_HOLIDAY"."CREATE_BY_" IS '创建人ID';

COMMENT ON COLUMN  "UC_HOLIDAY"."UPDATE_BY_" IS '更新人ID';

COMMENT ON COLUMN  "UC_HOLIDAY"."CREATE_ORG_ID_" IS '创建组织ID';

COMMENT ON COLUMN  "UC_HOLIDAY"."VERSION_" IS '版本';

COMMENT ON COLUMN  "UC_HOLIDAY"."TENANT_ID_" IS '租户ID';

COMMENT ON TABLE  "UC_GROUP_USER" IS '群组和用户关系表';

COMMENT ON COLUMN  "UC_GROUP_USER"."ID_" IS '主键';

COMMENT ON COLUMN  "UC_GROUP_USER"."GROUP_ID_" IS '外键';

COMMENT ON COLUMN  "UC_GROUP_USER"."USER_ID" IS '用户Id';

COMMENT ON COLUMN  "UC_GROUP_USER"."TENANT_ID_" IS '租户Id';

COMMENT ON COLUMN  "UC_GROUP_USER"."SN_" IS '排序值';

COMMENT ON TABLE  "UC_GROUP" IS '群组管理';

COMMENT ON COLUMN  "UC_GROUP"."ID_" IS '主键';

COMMENT ON COLUMN  "UC_GROUP"."GROUP_NAME" IS '群组名称';

COMMENT ON COLUMN  "UC_GROUP"."CODE_" IS '群组编码';

COMMENT ON COLUMN  "UC_GROUP"."CREATE_BY_" IS '创建人Id';

COMMENT ON COLUMN  "UC_GROUP"."CREATOR_NAME_" IS '创建人名称';

COMMENT ON COLUMN  "UC_GROUP"."CREATE_ORG_ID_" IS '创建人组织ID';

COMMENT ON COLUMN  "UC_GROUP"."UPDATE_BY_" IS '更新人ID';

COMMENT ON COLUMN  "UC_GROUP"."CREATE_TIME_" IS '创建时间';

COMMENT ON COLUMN  "UC_GROUP"."UPDATE_TIME_" IS '更新时间';

COMMENT ON COLUMN  "UC_GROUP"."TENANT_ID_" IS '租户Id';

CREATE INDEX "IDX_ELECTRONIC_SEAL_USERID"
ON  "UC_ELECTRONIC_SEAL"("USER_ID_");

COMMENT ON TABLE  "UC_ELECTRONIC_SEAL" IS '电子签章表';

COMMENT ON COLUMN  "UC_ELECTRONIC_SEAL"."ID_" IS '主键ID';

COMMENT ON COLUMN  "UC_ELECTRONIC_SEAL"."USER_ID_" IS '用户ID';

COMMENT ON COLUMN  "UC_ELECTRONIC_SEAL"."FILE_ID_" IS '签章图片ID';

COMMENT ON COLUMN  "UC_ELECTRONIC_SEAL"."PASSWORD_" IS '使用密码';

COMMENT ON COLUMN  "UC_ELECTRONIC_SEAL"."IS_USE_" IS '当前是否使用';

COMMENT ON COLUMN  "UC_ELECTRONIC_SEAL"."CREATE_TIME_" IS '创建时间';

COMMENT ON COLUMN  "UC_ELECTRONIC_SEAL"."UPDATE_TIME_" IS '更新时间';

COMMENT ON COLUMN  "UC_ELECTRONIC_SEAL"."CREATE_BY_" IS '创建人';

COMMENT ON COLUMN  "UC_ELECTRONIC_SEAL"."UPDATE_BY_" IS '更新人';

COMMENT ON COLUMN  "UC_ELECTRONIC_SEAL"."TENANT_ID_" IS '租户ID';

CREATE UNIQUE INDEX "IDX_DEM_CODE_UNQ"
ON  "UC_DEMENSION"("CODE_","TENANT_ID_");

COMMENT ON TABLE  "UC_DEMENSION" IS '维度管理';

COMMENT ON COLUMN  "UC_DEMENSION"."DEM_NAME_" IS '维度名称';

COMMENT ON COLUMN  "UC_DEMENSION"."CODE_" IS '维度代码';

COMMENT ON COLUMN  "UC_DEMENSION"."IS_DEFAULT_" IS '是否默认(1:默认,0:非默认)';

COMMENT ON COLUMN  "UC_DEMENSION"."DEM_DESC_" IS '描述';

COMMENT ON COLUMN  "UC_DEMENSION"."ORGAN_ID_" IS '机构id';

COMMENT ON COLUMN  "UC_DEMENSION"."IS_DELE_" IS '是否已删，1已删除，0未删除';

COMMENT ON COLUMN  "UC_DEMENSION"."VERSION_" IS '版本号';

COMMENT ON TABLE  "UC_BATCH_SYNC" IS 'UDS同步记录表';

COMMENT ON COLUMN  "UC_BATCH_SYNC"."EXECUTE_TIME_" IS '当前时间';

COMMENT ON COLUMN  "UC_BATCH_SYNC"."DATA_IDS_" IS '同步数据ID，json格式；调用函数名和入参。';

COMMENT ON COLUMN  "UC_BATCH_SYNC"."STATUS_" IS '状态，0-正在同步；1-已提交；2-已回滚';