| | |
|---|
| | | level integer, |
|---|
| | | order_num integer, |
|---|
| | | is_show smallint, |
|---|
| | | serve_type varchar(10), |
|---|
| | | data_type varchar(20), |
|---|
| | | create_user integer, |
|---|
| | | create_time timestamp(6) without time zone default now(), |
|---|
| | | update_user integer, |
|---|
| | |
|---|
| | | comment on column lf.sys_layer.level is '层级：0-根节点'; |
|---|
| | | comment on column lf.sys_layer.order_num is '排序号'; |
|---|
| | | comment on column lf.sys_layer.is_show is '是否显示'; |
|---|
| | | comment on column lf.sys_layer.serve_type is '服务类型'; |
|---|
| | | comment on column lf.sys_layer.data_type is '数据类型'; |
|---|
| | | comment on column lf.sys_layer.create_user is '创建人ID'; |
|---|
| | | comment on column lf.sys_layer.create_time is '创建时间'; |
|---|
| | | comment on column lf.sys_layer.update_user is '更新人ID'; |
|---|
| | | comment on column lf.sys_layer.update_time is '更新时间'; |
|---|
| | | comment on column lf.sys_layer.bak is '备注'; |
|---|
| | | |
|---|
| | | select * from lf.sys_layer; |
|---|
| | | select * from lf.sys_layer order by id; |
|---|
| | | ----------------------------------------------------------------------------------------------------- 33.服务日志表 |
|---|
| | | -- DROP TABLE IF EXISTS lf.sys_serve_log; |
|---|
| | | create table lf.sys_serve_log( |
|---|
