drop table T_BUI_DCT; create table T_BUI_DCT ( ID NUMBER(20) not null primary key, DCT_NM VARCHAR2(32) default ' ' not null, DCT_LEN NUMBER(11) default 0, DCT_TYP VARCHAR2(1) default ' ' not null, DCT_CNM VARCHAR2(60) default ' ' not null, DCT_DECIMAL NUMBER(11) default 0 not null, DCT_SIGN VARCHAR2(1) default ' ' not null, DCT_FORMAT VARCHAR2(1) default ' ' not null, DCT_FUNC VARCHAR2(30) default ' ' not null, DATA_TYP VARCHAR2(1) default ' ' not null, DCT_MOD VARCHAR2(20) default ' ' not null, DCT_DESC VARCHAR2(80) default ' ' not null, REQ_ID VARCHAR2(64) default ' ' not null, TM_SMP VARCHAR2(14) default ' ' not null, NOD_ID VARCHAR2(20) default ' ' not null, UPD_OPR VARCHAR2(10) default ' ' not null, UPD_DESC VARCHAR2(80) default ' ' not null ) ; comment on table T_BUI_DCT is '字典表' ; comment on column T_BUI_DCT.DCT_NM is '字典名' ; comment on column T_BUI_DCT.DCT_LEN is '长度' ; comment on column T_BUI_DCT.DCT_TYP is '类型' ; comment on column T_BUI_DCT.DCT_CNM is '字典中文名' ; comment on column T_BUI_DCT.DCT_DECIMAL is '精度' ; comment on column T_BUI_DCT.DCT_SIGN is '符号' ; comment on column T_BUI_DCT.DCT_FORMAT is '格式' ; comment on column T_BUI_DCT.DCT_FUNC is '功能描述' ; comment on column T_BUI_DCT.DATA_TYP is '数据类型' ; comment on column T_BUI_DCT.DCT_MOD is '模块' ; comment on column T_BUI_DCT.DCT_DESC is '描述' ; comment on column T_BUI_DCT.REQ_ID is '请求id' ; comment on column T_BUI_DCT.TM_SMP is '时间戳' ; comment on column T_BUI_DCT.NOD_ID is '更新节点' ; comment on column T_BUI_DCT.UPD_OPR is '更新操作员' ; comment on column T_BUI_DCT.UPD_DESC is '更新描述' ; create unique index ui1_T_BUI_DCT on T_BUI_DCT (DCT_NM); drop table T_BUI_HLP; create table T_BUI_HLP ( ID NUMBER(20) not null primary key, FLD_ORDER NUMBER(11) default 99 not null, FLD_NM VARCHAR2(32) default ' ' not null, FLD_VAL VARCHAR2(100) default ' ' not null, FLD_EXP VARCHAR2(100) default ' ' not null, FLD_TYP VARCHAR2(1) default ' ' not null, FLD_EXP_DESC VARCHAR2(80) default ' ' not null, TM_SMP VARCHAR2(14) default ' ' not null, REQ_ID VARCHAR2(64) default ' ' not null, NOD_ID VARCHAR2(20) default ' ' not null, UPD_OPR VARCHAR2(10) default ' ' not null, UPD_DESC VARCHAR2(80) default ' ' not null ) ; comment on table T_BUI_HLP is '字典枚举值' ; comment on column T_BUI_HLP.FLD_ORDER is '顺序' ; comment on column T_BUI_HLP.FLD_NM is '名称' ; comment on column T_BUI_HLP.FLD_VAL is '枚举值' ; comment on column T_BUI_HLP.FLD_EXP is '枚举描述' ; comment on column T_BUI_HLP.FLD_TYP is '类型' ; comment on column T_BUI_HLP.FLD_EXP_DESC is '备注' ; comment on column T_BUI_HLP.TM_SMP is '时间戳' ; comment on column T_BUI_HLP.REQ_ID is '请求id' ; comment on column T_BUI_HLP.NOD_ID is '节点id' ; comment on column T_BUI_HLP.UPD_OPR is '更新操作员' ; comment on column T_BUI_HLP.UPD_DESC is '更新描述' ; create unique index ui1_T_BUI_HLP on T_BUI_HLP (FLD_NM, FLD_VAL); drop table T_BUI_MENU; create table T_BUI_MENU ( MENU_ID NUMBER(20) not null primary key, PARENT_ID NUMBER(20) default 0 not null, NAME VARCHAR2(50) default ' ' not null, URL VARCHAR2(200) default ' ' not null, PERMS VARCHAR2(500) default ' ' not null, TYPE VARCHAR2(11) default ' ' not null, ICON VARCHAR2(50) default ' ' not null, ORDER_NUM NUMBER(11) default 0 not null, NOD_ID VARCHAR2(20) default ' ' not null, TM_SMP VARCHAR2(14) default ' ' not null, UPD_OPR VARCHAR2(10) default ' ' not null, ORG_ID NUMBER default 0 not null, REQ_ID VARCHAR2(64) default ' ' not null ) ; comment on table T_BUI_MENU is '菜单管理' ; comment on column T_BUI_MENU.PARENT_ID is '父菜单ID，一级菜单为0' ; comment on column T_BUI_MENU.NAME is '菜单名称' ; comment on column T_BUI_MENU.URL is '菜单URL' ; comment on column T_BUI_MENU.PERMS is '授权(多个用逗号分隔，如：user:list,user:create)' ; comment on column T_BUI_MENU.TYPE is '类型 0：目录 1：菜单 2：按钮' ; comment on column T_BUI_MENU.ICON is '菜单图标' ; comment on column T_BUI_MENU.ORDER_NUM is '排序' ; drop table T_BUI_OPER; create table T_BUI_OPER ( OPER_ID NUMBER(20) not null primary key, OPER_NO VARCHAR2(20) default ' ' not null, OPER_NM VARCHAR2(60) default ' ' not null, OPER_PWD VARCHAR2(100) default ' ' not null, OPER_EMAIL VARCHAR2(60) default ' ' not null, OPER_TYP VARCHAR2(1) default ' ' not null, AUTH_LVL VARCHAR2(2) default ' ' not null, MBL_NO VARCHAR2(11) default ' ' not null, TEL_NO VARCHAR2(11) default ' ' not null, PWD_EXP_PERIOD VARCHAR2(14) default ' ' not null, PWD_UPD_DT VARCHAR2(14) default ' ' not null, VAL_DT VARCHAR2(8) default ' ' not null, EXP_DT VARCHAR2(8) default ' ' not null, STS VARCHAR2(1) default '0' not null, LOGIN_TM VARCHAR2(60) default ' ' not null, LAST_LOG_TM VARCHAR2(14) default ' ' not null, LOGIN_TMS NUMBER default 0 not null, LOG_MOD VARCHAR2(1) default ' ' not null, USB_KEY_ID VARCHAR2(60) default ' ' not null, PSW_FAIL_CNT NUMBER default 0 not null, IMG_PATH VARCHAR2(60) default ' ' not null, PWD_SALT VARCHAR2(10) default ' ' not null, ORG_ID NUMBER default 1 not null, NOD_ID VARCHAR2(20) default ' ' not null, TM_SMP VARCHAR2(14) default ' ' not null, UPD_OPR VARCHAR2(10) default ' ' not null, REQ_ID VARCHAR2(64) default ' ' ) ; comment on table T_BUI_OPER is '操作员信息表' ; comment on column T_BUI_OPER.OPER_ID is 'id' ; comment on column T_BUI_OPER.OPER_NO is '编号' ; comment on column T_BUI_OPER.OPER_NM is '姓名' ; comment on column T_BUI_OPER.OPER_PWD is '密码' ; comment on column T_BUI_OPER.OPER_EMAIL is '邮箱' ; comment on column T_BUI_OPER.OPER_TYP is '操作员类型(1:系统管理员,2:数字证书+密码,3:USBKey+密码)' ; comment on column T_BUI_OPER.AUTH_LVL is '授权级别' ; comment on column T_BUI_OPER.MBL_NO is '操作员类型' ; comment on column T_BUI_OPER.TEL_NO is '操作员类型' ; comment on column T_BUI_OPER.PWD_EXP_PERIOD is '密码失效时间' ; comment on column T_BUI_OPER.PWD_UPD_DT is '操作员类型' ; comment on column T_BUI_OPER.VAL_DT is '生效时间' ; comment on column T_BUI_OPER.EXP_DT is '失效时间' ; comment on column T_BUI_OPER.STS is '状态(0:正常,1:无效,2:过期,3:密码超过最大次数)' ; comment on column T_BUI_OPER.LOGIN_TM is '登录时间' ; comment on column T_BUI_OPER.LAST_LOG_TM is '最近一次登录时间' ; comment on column T_BUI_OPER.LOGIN_TMS is '登录次数' ; comment on column T_BUI_OPER.LOG_MOD is '登录方式(1:密码,2:数字证书+密码,3:USBKey+密码)' ; comment on column T_BUI_OPER.USB_KEY_ID is 'usbkey id' ; comment on column T_BUI_OPER.PSW_FAIL_CNT is '失败次数' ; comment on column T_BUI_OPER.IMG_PATH is '图像地址' ; comment on column T_BUI_OPER.PWD_SALT is '密码salt' ; comment on column T_BUI_OPER.ORG_ID is '机构id' ; comment on column T_BUI_OPER.NOD_ID is '节点ID' ; comment on column T_BUI_OPER.TM_SMP is '时间戳' ; comment on column T_BUI_OPER.UPD_OPR is '操作员ID' ; create unique index UI1_T_BUI_OPER on T_BUI_OPER (OPER_NO) ; drop table T_BUI_OPER_ROLE; create table T_BUI_OPER_ROLE ( ID NUMBER(20) not null primary key, ROLE_ID NUMBER not null, OPER_ID NUMBER not null, STS VARCHAR2(1) default '0' not null, NOD_ID VARCHAR2(20) default ' ' not null, TM_SMP VARCHAR2(14) default ' ' not null, UPD_OPR VARCHAR2(20) default ' ' not null, REQ_ID VARCHAR2(64) default ' ' not null ) ; comment on table T_BUI_OPER_ROLE is '操作员角色关联表' ; comment on column T_BUI_OPER_ROLE.ID is 'id' ; comment on column T_BUI_OPER_ROLE.ROLE_ID is '角色ID' ; comment on column T_BUI_OPER_ROLE.OPER_ID is '操作员ID' ; comment on column T_BUI_OPER_ROLE.STS is '状态(0:正常,1:无效)' ; comment on column T_BUI_OPER_ROLE.NOD_ID is '节点ID' ; comment on column T_BUI_OPER_ROLE.TM_SMP is '时间戳' ; comment on column T_BUI_OPER_ROLE.UPD_OPR is '操作员ID' ; drop table T_BUI_ORG; create table T_BUI_ORG ( ID NUMBER(20) not null primary key, ORG_NO VARCHAR2(22) default ' ' not null, ORG_NM VARCHAR2(60) default ' ' not null, ORG_STS VARCHAR2(1) default '0' not null, SUP_ORG_NO VARCHAR2(22) default ' ' not null, REMARK VARCHAR2(128) default ' ' not null, TM_SMP VARCHAR2(14) default ' ' not null, UPD_OPR VARCHAR2(20) default ' ' not null, REQ_ID VARCHAR2(64) default ' ' not null, NOD_ID VARCHAR2(20) default ' ' not null ) ; comment on table T_BUI_ORG is '机构信息表' ; comment on column T_BUI_ORG.ID is 'id' ; comment on column T_BUI_ORG.ORG_NO is '机构号' ; comment on column T_BUI_ORG.ORG_NM is '名称' ; comment on column T_BUI_ORG.ORG_STS is '机构id(0:正常,1:无效)' ; comment on column T_BUI_ORG.SUP_ORG_NO is '上级机构' ; comment on column T_BUI_ORG.REMARK is '备注' ; comment on column T_BUI_ORG.TM_SMP is '时间戳' ; comment on column T_BUI_ORG.UPD_OPR is '操作员ID' ; comment on column T_BUI_ORG.REQ_ID is '请求ID' ; comment on column T_BUI_ORG.NOD_ID is '节点ID' ; drop table T_BUI_ROLE; create table T_BUI_ROLE ( ID NUMBER not null primary key, NAME VARCHAR2(60) default ' ' not null, REMARK VARCHAR2(128) default ' ' not null, ORG_ID NUMBER default 0 not null, STS VARCHAR2(1) default '0' not null, NOD_ID VARCHAR2(20) default ' ' not null, TM_SMP VARCHAR2(14) default ' ' not null, UPD_OPR VARCHAR2(20) default ' ' not null, REQ_ID VARCHAR2(64) default ' ' not null ) ; comment on table T_BUI_ROLE is '角色信息表' ; comment on column T_BUI_ROLE.ID is 'id' ; comment on column T_BUI_ROLE.NAME is '名称' ; comment on column T_BUI_ROLE.REMARK is '备注' ; comment on column T_BUI_ROLE.ORG_ID is '机构id' ; comment on column T_BUI_ROLE.STS is '状态(0:正常,1:无效)' ; comment on column T_BUI_ROLE.NOD_ID is '节点ID' ; comment on column T_BUI_ROLE.TM_SMP is '时间戳' ; comment on column T_BUI_ROLE.UPD_OPR is '操作员ID' ; create unique index UI1_T_BUI_ROLE on T_BUI_ROLE (NAME) ; drop table T_BUI_ROLE_MENU; create table T_BUI_ROLE_MENU ( ID NUMBER(20) not null primary key, ROLE_ID NUMBER(20) default 0 not null, MENU_ID NUMBER(20) default 0 not null, NOD_ID VARCHAR2(20) default ' ' not null, TM_SMP VARCHAR2(14) default ' ' not null, UPD_OPR VARCHAR2(10) default ' ' not null, REQ_ID VARCHAR2(64) default ' ' not null ) ; comment on table T_BUI_ROLE_MENU is '角色与菜单对应关系' ; comment on column T_BUI_ROLE_MENU.ROLE_ID is '角色ID' ; comment on column T_BUI_ROLE_MENU.MENU_ID is '菜单ID' ; comment on column T_BUI_ROLE_MENU.NOD_ID is '节点号' ; comment on column T_BUI_ROLE_MENU.TM_SMP is '时间戳' ; comment on column T_BUI_ROLE_MENU.UPD_OPR is '更新操作员' ; drop table T_BUI_CONFIG; create table T_BUI_CONFIG ( ID NUMBER(20) not null primary key, PARAM_KEY VARCHAR2(50) default ' ' not null, PARAM_VALUE VARCHAR2(1024) default ' ' not null, STS VARCHAR2(1) default '0' not null, REMARK VARCHAR2(80) default ' ' not null, REQ_ID VARCHAR2(64) default ' ' not null, NOD_ID VARCHAR2(20) default ' ' not null, TM_SMP VARCHAR2(14) default ' ' not null, UPD_OPR VARCHAR2(10) default ' ' not null ) ; comment on table T_BUI_CONFIG is '系统配置信息表' ; comment on column T_BUI_CONFIG.PARAM_KEY is 'key' ; comment on column T_BUI_CONFIG.PARAM_VALUE is 'value' ; comment on column T_BUI_CONFIG.STS is '状态 0：正常 1：无效' ; comment on column T_BUI_CONFIG.REMARK is '备注' ; comment on column T_BUI_CONFIG.REQ_ID is '请求id' ; comment on column T_BUI_CONFIG.NOD_ID is '节点' ; comment on column T_BUI_CONFIG.TM_SMP is '时间戳' ; comment on column T_BUI_CONFIG.UPD_OPR is '操作员' ; create unique index ui1_T_BUI_CONFIG on T_BUI_CONFIG (PARAM_KEY); drop table T_BUI_OPERLOG; create table T_BUI_OPERLOG ( ID NUMBER(20) not null primary key, OPER_NO VARCHAR2(50) default ' ' , OPER_NM VARCHAR2(1024) default ' ', TXN_CD VARCHAR2(1) default '0', IP_ADDR VARCHAR2(80) default ' ' , REQ_DATA VARCHAR2(80) default ' ' , REQ_ID VARCHAR2(64) default ' ' , NOD_ID VARCHAR2(20) default ' ' , TM_SMP VARCHAR2(14) default ' ' , UPD_OPR VARCHAR2(10) default ' ' , MSG_CODE NUMBER(10) default ' ' , MSG_INFO VARCHAR2(20) default ' ' , ) ; comment on table T_BUI_OPERLOG is '操作日志' ; comment on column T_BUI_OPERLOG.PARAM_KEY is 'key' ; comment on column T_BUI_OPERLOG.PARAM_VALUE is 'value' ; comment on column T_BUI_OPERLOG.STS is '状态 0：正常 1：无效' ; comment on column T_BUI_OPERLOG.REMARK is '备注' ; comment on column T_BUI_OPERLOG.REQ_ID is '请求id' ; comment on column T_BUI_OPERLOG.NOD_ID is '节点' ; comment on column T_BUI_OPERLOG.TM_SMP is '时间戳' ; comment on column T_BUI_OPERLOG.UPD_OPR is '操作员' ; comment on column T_BUI_OPERLOG.MSG_CODE is '响应码' ; comment on column T_BUI_OPERLOG.MSG_INFO is '结果' ; create unique index ui1_T_BUI_OPERLOG on T_BUI_OPERLOG (PARAM_KEY); -- auto-generated definition create sequence S_PUB_ID minvalue 1 start with 1 maxvalue 9999999999999999999 cache 100 /