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