You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
18 lines
551 B
18 lines
551 B
create table advisory_notice
|
|
(
|
|
id serial
|
|
constraint advisory_notice_pk
|
|
primary key,
|
|
title varchar(300) not null,
|
|
publish_time timestamp without TIME ZONE,
|
|
state integer not null,
|
|
content text not null,
|
|
attachments text[]
|
|
|
|
);
|
|
|
|
comment on column advisory_notice.title is '公告标题';
|
|
|
|
comment on column advisory_notice.publish_time is '发布时间';
|
|
|
|
comment on column advisory_notice.state is '/*1.草稿，2.已发布，3.已下架*/';
|