| | |
|---|
| | | json_result varchar2(2100) default '', |
|---|
| | | status number(1) default 0, |
|---|
| | | error_msg varchar2(2100) default '', |
|---|
| | | oper_time date |
|---|
| | | oper_time date, |
|---|
| | | cost_time number(20) default 0 |
|---|
| | | ); |
|---|
| | | |
|---|
| | | alter table sys_oper_log add constraint pk_sys_oper_log primary key (oper_id); |
|---|
| | | create unique index idx_sys_oper_log_bt on sys_oper_log (business_type); |
|---|
| | | create unique index idx_sys_oper_log_s on sys_oper_log (status); |
|---|
| | | create unique index idx_sys_oper_log_ot on sys_oper_log (oper_time); |
|---|
| | | |
|---|
| | | comment on table sys_oper_log is '操作日志记录'; |
|---|
| | | comment on column sys_oper_log.oper_id is '日志主键'; |
|---|
| | |
|---|
| | | comment on column sys_oper_log.status is '操作状态（0正常 1异常）'; |
|---|
| | | comment on column sys_oper_log.error_msg is '错误消息'; |
|---|
| | | comment on column sys_oper_log.oper_time is '操作时间'; |
|---|
| | | comment on column sys_oper_log.cost_time is '消耗时间'; |
|---|
| | | |
|---|
| | | |
|---|
| | | -- ---------------------------- |
|---|
| | |
|---|
| | | ); |
|---|
| | | |
|---|
| | | alter table sys_logininfor add constraint pk_sys_logininfor primary key (info_id); |
|---|
| | | create unique index idx_sys_logininfor_s on sys_logininfor (status); |
|---|
| | | create unique index idx_sys_logininfor_lt on sys_logininfor (login_time); |
|---|
| | | |
|---|
| | | comment on table sys_logininfor is '系统访问记录'; |
|---|
| | | comment on column sys_logininfor.info_id is '访问ID'; |
|---|
