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

