postgres创建表添加注释

create table bi_assets_outcome_fr(
date_id int not null,
company_id bigint not null,
staff_id bigint not null,
publish_value float not null,
publish_count int not null,
refresh_value float not null,
refresh_count int not null,
olive_value float not null,
olive_count int not null,
jobtop_value float not null,
jobtop_count int not null,
download_value float not null,
download_count int not null,
entry_datetime timestamptz)

create table bi_assets_fr2(entry_datetime timestamptz not null,
date_id bigint not null,
company_id bigint not null,
staff_id int not null,
bvalue float not null,
bvalue_type int not null)


comment on column bi_assets_outcome_fr.entry_datetime is '创建日期';
comment on column bi_assets_outcome_fr.date_id is '统计日期';
comment on column bi_assets_outcome_fr.publish_value is '发布职位消耗智联币数';
comment on column bi_assets_outcome_fr.publish_count is '发布职位数';
comment on column bi_assets_outcome_fr.refresh_value is '职位刷新消耗的智联币';
comment on column bi_assets_outcome_fr.refresh_count is '职位刷新数';
comment on column bi_assets_outcome_fr.olive_value is '橄榄枝发送消耗智联币';
comment on column bi_assets_outcome_fr.olive_count is '橄榄枝发送数';
comment on column bi_assets_outcome_fr.jobtop_value is '职位置顶消耗智联币';
comment on column bi_assets_outcome_fr.jobtop_count is '职位置顶数';
comment on column bi_assets_outcome_fr.download_value is '下载简历消耗智联币';
comment on column bi_assets_outcome_fr.download_count is '下载简历数';


comment on column bi_assets_fr2.entry_datetime is '录入时间';
comment on column bi_assets_fr2.date_id is '统计日期';
comment on column bi_assets_fr2.company_id is '公司id';
comment on column bi_assets_fr2.staff_id is '操作人id';
comment on column bi_assets_fr2.bvalue is '操作智联币数';
comment on column bi_assets_fr2.bvalue_type is '操作类型,1消费，2充值';
充值消费情况  使用情况
comment on table bi_assets_fr2 is '充值消费情况';
comment on table bi_assets_outcome_fr is '使用情况';

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29898569/viewspace-1847235/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29898569/viewspace-1847235/