DROP TABLE IF EXISTS district;
|
|
CREATE TABLE district
|
(
|
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,
|
city_id bigint DEFAULT 0 NOT NULL
|
);
|
|
COMMENT ON TABLE district IS '区表';
|
|
COMMENT ON COLUMN district.name IS '名称';
|
COMMENT ON COLUMN district.city_id IS '城市id';
|
|
create unique index on district (name, city_id);
|
