581 lines
14 KiB
SQL
581 lines
14 KiB
SQL
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
|
|
/
|
|
|
|
|
|
|