| | |
| | | create table lf.sys_apply ( |
| | | id serial primary key, |
| | | userid integer default 0, |
| | | depids varchar(100), |
| | | tables varchar(1000), |
| | | depids varchar(500), |
| | | tabs varchar(2000), |
| | | entities varchar(2000), |
| | | wkt varchar(4000), |
| | | pwd varchar(200), |
| | | status integer default 0, |
| | | count integer default 0, |
| | | descr varchar(50), |
| | |
| | | comment on column lf.sys_apply.id is '主键ID'; |
| | | comment on column lf.sys_apply.userid is '用户ID'; |
| | | comment on column lf.sys_apply.depids is '单位ID'; |
| | | comment on column lf.sys_apply.tables is '表名'; |
| | | comment on column lf.sys_apply.tabs is '表名'; |
| | | comment on column lf.sys_apply.entities is '实体名'; |
| | | comment on column lf.sys_apply.wkt is 'WKT'; |
| | | comment on column lf.sys_apply.pwd is '密码'; |
| | | comment on column lf.sys_apply.status is '状态:-10-作废,-1-打回,0-申请中,1~9,审核中,10-通过'; |
| | | comment on column lf.sys_apply.count is '审核总数'; |
| | | comment on column lf.sys_apply.descr is '描述'; |