M_CITY

来源:互联网 发布:木工画图软件 编辑:程序博客网 时间:2024/06/05 16:56
-- Table: public."M_CITY"


-- DROP TABLE public."M_CITY";


CREATE TABLE public."M_CITY"
(
    "CODE" character(5) COLLATE pg_catalog."default" NOT NULL,
    "KIND" integer NOT NULL,
    "NAME" character varying(10) COLLATE pg_catalog."default" NOT NULL,
    "PARENT" character(5) COLLATE pg_catalog."default",
    CONSTRAINT "M_CITY_pkey" PRIMARY KEY ("CODE")
)
WITH (
    OIDS = FALSE
)
TABLESPACE pg_default;


ALTER TABLE public."M_CITY"
    OWNER to postgres;