DROP TABLE IF EXISTS city;

CREATE TABLE city
(
    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,
    province_id bigint       DEFAULT 0   NOT NULL
);

COMMENT ON TABLE city IS '城市表';

COMMENT ON COLUMN city.name IS '名称';
COMMENT ON COLUMN city.province_id IS '省id';
create unique index on city (name, province_id);