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);