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-已回滚';