| | |
| | | -- insert into lf.sys_meta_pub (metaid,pubid) values (1399,1); |
| | | |
| | | select * from lf.sys_meta_pub; |
| | | ----------------------------------------------------------------------------------------------------- 38.数据发布-下载表 |
| | | -- drop table if exists lf.sys_pub_down; |
| | | create table lf.sys_pub_down( |
| | | id serial primary key, |
| | | pubid integer, |
| | | downid integer, |
| | | create_user integer default 1, |
| | | create_time timestamp(6) without time zone default now() |
| | | ); |
| | | comment on table lf.sys_pub_down is '数据发布-下载表'; |
| | | comment on column lf.sys_pub_down.id is '主键ID'; |
| | | comment on column lf.sys_pub_down.pubid is '数据发布ID'; |
| | | comment on column lf.sys_pub_down.downid is '下载ID'; |
| | | comment on column lf.sys_pub_down.create_user is '创建人ID'; |
| | | comment on column lf.sys_pub_down.create_time is '创建时间'; |
| | | |
| | | select * from lf.sys_pub_down; |
| | | ----------------------------------------------------------------------------------------------------- |