-- Table: k_kind
-- DROP TABLE k_kind;
CREATE TABLE k_kind
(
"kindID" integer NOT NULL DEFAULT nextval('public."k_kind_kindID_seq"'::text),
"kNO" character(10),
"kindName" character varying(100),
CONSTRAINT kind_key PRIMARY KEY ("kindID")
)
WITHOUT OIDS;
ALTER TABLE k_kind OWNER TO postgres;
-- Table: kokyaku
-- DROP TABLE kokyaku;
CREATE TABLE kokyaku
(
"kID" integer NOT NULL DEFAULT nextval('public."kokyaku_kID_seq"'::text),
"name" character varying(255),
yubin character varying(100),
address character varying(255),
tel character varying(100),
kname character varying(255),
kind character(10),
CONSTRAINT kokyaku_key PRIMARY KEY ("kID")
)
WITHOUT OIDS;
ALTER TABLE kokyaku OWNER TO postgres;
0 件のコメント:
コメントを投稿