« PostgreSQL鐃緒申鐃緒申存鐃塾テ￥申鐃瞬ワ申鐃緒申鐃緒申鐃緒申鐃術刻申鐃緒申ALTER TABLE | 鐃潤イ鐃緒申 | PostgreSQL鐃緒申鐃銃￥申鐃瞬ワ申鐃緒申鐃緒申鐃�DROP TABLE »
2006年12鐃緒申20鐃緒申
PostgreSQL鐃緒申鐃銃￥申鐃瞬ワ申鐃緒申鐃緒申鐃緒申CREATE TABLE
鐃銃￥申鐃瞬ワ申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申砲蓮鐃�CREATE TABLE鐃緒申鐃緒申僂鐃緒申泙鐃緒申鐃�
鐃緒申鐃銃￥申鐃瞬ワ申鐃緒申鐃緒申鐃緒申鐃�NOT NULL鐃緒申鐃緒申UNIQUE鐃緒申鐃緒申DEFAULT鐃緒申鐃緒申鐃緒申鐃緒申鐃淑どわ申鐃緒申鐃緒申能鐃叔わ申鐃緒申
鐃緒申複鐃緒申腑�鐃緒申鐃淑プライ鐃殉リー鐃緒申鐃緒申鐃祝はテ￥申鐃瞬ワ申鐃緒申鐃緒申鐃緒申砲里鐃緒申鐃粛随申鐃緒申襪鰹申箸鐃緒申任鐃緒申泙鐃緒申鐃�
鐃緒申鐃縮常申離董鐃緒申屮鐃緒申鐃緒申
create table sglog(
"shop_id" integer,
"fullname" varchar(100) not null,
"ip" varchar(100) not null,
"log_date" timestamp DEFAULT "timestamp"('now'::text) not null
);
鐃緒申鐃竣ライ鐃殉リー鐃緒申鐃緒申鐃緒申鐃緒申法鐃緒申鐃緒申鐃緒申鐃淑どわ申鐃春わ申鐃緒申
create table area(
"area_id" integer primary key,
"area_name" varchar(100) not null,
"ordernum" integer UNIQUE not null,
"registday" timestamp DEFAULT "timestamp"('now'::text) not null,
"parent_areaid" integer,
"rank" integer
);
鐃緒申複鐃緒申腑�鐃緒申鐃緒申鐃春わ申鐃緒申
create table rcmenu(
"rcmenuid" integer DEFAULT nextval('"rcmenu_rcmenuid_seq"'::text) not null,
"title" varchar(100) not null,
"list" text,
"must" boolean DEFAULT 'f' not null,
"ordernum" integer UNIQUE not null,
Constraint "rcmenu_pkey" Primary Key (rcmenuid, title)
);
鐃緒申複鐃緒申鐃塾ワ申鐃緒申鐃叔ワ申法鐃緒申鐃緒申砲鐃緒申鐃�
create table r_access_i(
"shop_id" integer not null references sginfo(shop_id) on update cascade on delete cascade,
"inout" varchar(10) not null,
"ym" varchar(10) not null,
"count" integer not null,
Constraint "raccess_i_ukey" UNIQUE (shop_id, inout, ym)
);
鐃緒申ID鐃塾よう鐃淑ワ申法鐃緒申鐃緒申鐃緒申佑鐃緒申鐃獣わ申鐃銃￥申鐃瞬ワ申両鐃順、鐃緒申鐃緒申鐃緒申鐃緒申鐃竣ライ鐃殉リー鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鬚靴鐃緒申曚鐃緒申鐃緒申鐃緒申鐃緒申任鐃緒申鐃緒申廛薀わ申泪蝓種申鐃緒申鐃緒申鐃緒申鐃緒申蠅刻申襪鰹申箸砲鐃緒申鐃緒申鐃緒申淵鐃緒申鐃叔ッワ申鐃緒申鐃祝わ申鐃緒申鐃緒申鐃緒申鐃曙、SELECT文鐃渋行誌申鐃淑どのレス鐃楯ンスわ申速鐃緒申鐃祝鰹申鐃淑に削申鐃緒申鐃出まわ申鐃緒申
鐃緒申銅鐃� wing : 2006年12鐃緒申20鐃緒申 23:13