DROP TABLE IF EXISTS province;
|
|
CREATE TABLE province
|
(
|
id bigserial PRIMARY KEY,
|
create_time timestamp with time zone NOT NULL,
|
update_time timestamp with time zone NOT NULL,
|
name varchar(100) DEFAULT '' NOT NULL
|
);
|
|
COMMENT ON TABLE province IS '省表';
|
|
COMMENT ON COLUMN province.name IS '名称';
|
create unique index on province(name);
|
