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