2010年8月18日水曜日

posgreSQL テーブルサンプル

-- 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 件のコメント:

コメントを投稿