CREATE TABLE goukei (
	turisenn	NUMBER DEFAULT 0 NOT NULL,
	azukari	NUMBER DEFAULT 0 NOT NULL,
	nyuukinn	NUMBER DEFAULT 0 NOT NULL,
	shukkinn	NUMBER DEFAULT 0 NOT NULL,
	zeikinn	NUMBER DEFAULT 0 NOT NULL,
	uchizei	NUMBER DEFAULT 0 NOT NULL,
	hikazei	NUMBER DEFAULT 0 NOT NULL,
	uchizeitaishou	NUMBER DEFAULT 0 NOT NULL,
	sotozeitaishou	NUMBER DEFAULT 0 NOT NULL,
	goukeiid	NUMBER DEFAULT 0 NOT NULL,
	hikazeiwaribiki	NUMBER DEFAULT 0 NOT NULL,
	uchizeitaishouwaribiki	NUMBER DEFAULT 0 NOT NULL,
	sotozeitaishouwaribiki		NUMBER DEFAULT 0 NOT NULL,
	point	NUMBER DEFAULT 0 NOT NULL,
	kakinn	NUMBER DEFAULT 0 NOT NULL,
	waribikiritsu	NUMBER DEFAULT 0 NOT NULL
);

CREATE TABLE kakeurishori (
	kakeurishoriid	NUMBER PRIMARY KEY,
	maindate	DATE,
	tanntoushaid	NUMBER DEFAULT 0 NOT NULL,
	nyushukkaid	NUMBER DEFAULT 0 NOT NULL
);

CREATE TABLE sethannbai (
	sethannbaiid	NUMBER PRIMARY KEY,
	shouhinnid	NUMBER DEFAULT 0 NOT NULL,
	groupid	NUMBER DEFAULT 0 NOT NULL,
	groupmei	VARCHAR2(50),
	nebikigaku	NUMBER DEFAULT 0 NOT NULL,
	barcodeno	VARCHAR2(50),
	priority	NUMBER DEFAULT 0 NOT NULL
);


CREATE TABLE kokyaku (
	kokyakuid	NUMBER PRIMARY KEY,
	cardid	VARCHAR2(50),
	nyuukaidate	DATE,
	kokyakumei	VARCHAR2(50),
	kokyakumeikana	VARCHAR2(50),
	email	VARCHAR2(50),
	tel	VARCHAR2(50),
	fax	VARCHAR2(50),
	postcode	VARCHAR2(50),
	address	VARCHAR2(100),
	birthday	DATE,
	sex	VARCHAR2(50),
	pointstartdate	DATE,
	bunnrui	VARCHAR2(50),
	memo1	VARCHAR2(50),
	memo2	VARCHAR2(50),
	yuukoukigenn	DATE,
	nebiki	NUMBER DEFAULT 0 NOT NULL,
	pointtaishou	NUMBER DEFAULT 0 NOT NULL
);

CREATE TABLE nyushukkamain (
	nyushukkaid	NUMBER PRIMARY KEY,
	category	VARCHAR2(50),
	maindate	DATE,
	shainnid	NUMBER DEFAULT 0 NOT NULL,
	kionn	NUMBER DEFAULT 0 NOT NULL,
	dennpyouno	NUMBER DEFAULT 0 NOT NULL,
	olddennpyouno	NUMBER DEFAULT 0 NOT NULL,
	kokyakuid	NUMBER DEFAULT 0 NOT NULL,
	tennki	VARCHAR2(50),
	sex	VARCHAR2(50),
	age	NUMBER DEFAULT 0 NOT NULL,
	registerno	NUMBER DEFAULT 0 NOT NULL,
	shiiresakiid NUMBER DEFAULT 0 NOT NULL,
	idounyushukkotennpo NUMBER DEFAULT 0 NOT NULL,
	subcategoryid NUMBER DEFAULT 0 NOT NULL,
	ichijihojigyoumuuketoridate	DATE,
	ichibunyuukinn	NUMBER  DEFAULT 0 NOT NULL,
	kyakusuu NUMBER DEFAULT 0 NOT NULL,
	ichijihojigyoumuhannbai	NUMBER  DEFAULT 0 NOT NULL,
	seisannno	NUMBER DEFAULT 0 NOT NULL,
	koumoku	VARCHAR2(50),
	memo	VARCHAR2(50)
);

CREATE TABLE nyushukkasub (
	nyushukkaid	NUMBER DEFAULT 0 NOT NULL,
	shouhinnid	NUMBER DEFAULT 0 NOT NULL,
	shouhinnmei	VARCHAR2(100),
	nyuukasuu	NUMBER DEFAULT 0 NOT NULL,
	shukkasuu	NUMBER DEFAULT 0 NOT NULL,
	shoukei	NUMBER DEFAULT 0 NOT NULL,
	nebikigaku	NUMBER DEFAULT 0 NOT NULL,
	tanaoroshisuu	NUMBER DEFAULT 0 NOT NULL
);

CREATE TABLE sethannbaisub (
	nyushukkaid	NUMBER DEFAULT 0 NOT NULL,
	groupid	NUMBER DEFAULT 0 NOT NULL,
	nyuukasuu	NUMBER DEFAULT 0 NOT NULL,
	shukkasuu	NUMBER DEFAULT 0 NOT NULL,
	shoukei	NUMBER DEFAULT 0 NOT NULL,
	nebikigaku	NUMBER DEFAULT 0 NOT NULL
);

CREATE TABLE seisann (
	souuriagekosuu	NUMBER DEFAULT 0 NOT NULL,
	souuriagekinngaku	NUMBER DEFAULT 0 NOT NULL,
	jyunnuriagekennsuu	NUMBER DEFAULT 0 NOT NULL,
	jyunnuriagekinngaku	NUMBER DEFAULT 0 NOT NULL,
	waribikigoukei	NUMBER DEFAULT 0 NOT NULL,
	nebikigoukei	NUMBER DEFAULT 0 NOT NULL,
	uchizeikinngaku	NUMBER DEFAULT 0 NOT NULL,
	uchizeitaishou	NUMBER DEFAULT 0 NOT NULL,
	sotozeikinngaku	NUMBER DEFAULT 0 NOT NULL,
	sotozeitaishou	NUMBER DEFAULT 0 NOT NULL,
	hikazeitaishou	NUMBER DEFAULT 0 NOT NULL,
	hennpinnkennsuu	NUMBER DEFAULT 0 NOT NULL,
	hennpinnkinngaku	NUMBER DEFAULT 0 NOT NULL,
	gennkinnuriagekennsuu	NUMBER DEFAULT 0 NOT NULL,
	gennkinnuriagekinngaku	NUMBER DEFAULT 0 NOT NULL,
	kakeuriagekennsuu	NUMBER DEFAULT 0 NOT NULL,
	kakeuriagekinngaku	NUMBER DEFAULT 0 NOT NULL,
	carduriagekennsuu	NUMBER DEFAULT 0 NOT NULL,
	carduriagekennsuu1	NUMBER DEFAULT 0 NOT NULL,
	carduriagekennsuu2	NUMBER DEFAULT 0 NOT NULL,
	carduriagekennsuu3	NUMBER DEFAULT 0 NOT NULL,
	carduriagekennsuu4	NUMBER DEFAULT 0 NOT NULL,
	carduriagekennsuu5	NUMBER DEFAULT 0 NOT NULL,
	carduriagekennsuu6	NUMBER DEFAULT 0 NOT NULL,
	carduriagekennsuu7	NUMBER DEFAULT 0 NOT NULL,
	carduriagekennsuu8	NUMBER DEFAULT 0 NOT NULL,
	carduriagekennsuu9	NUMBER DEFAULT 0 NOT NULL,
	carduriagekennsuu10	NUMBER DEFAULT 0 NOT NULL,
	carduriagekennsuu11	NUMBER DEFAULT 0 NOT NULL,
	carduriagekennsuu12	NUMBER DEFAULT 0 NOT NULL,
	carduriagekennsuu13	NUMBER DEFAULT 0 NOT NULL,
	carduriagekennsuu14	NUMBER DEFAULT 0 NOT NULL,
	carduriagekennsuu15	NUMBER DEFAULT 0 NOT NULL,
	carduriagekennsuu16	NUMBER DEFAULT 0 NOT NULL,
	carduriagekennsuu17	NUMBER DEFAULT 0 NOT NULL,
	carduriagekennsuu18	NUMBER DEFAULT 0 NOT NULL,
	carduriagekennsuu19	NUMBER DEFAULT 0 NOT NULL,
	carduriagekennsuu20	NUMBER DEFAULT 0 NOT NULL,
	carduriagekinngaku	NUMBER DEFAULT 0 NOT NULL,
	carduriagekinngaku1	NUMBER DEFAULT 0 NOT NULL,
	carduriagekinngaku2	NUMBER DEFAULT 0 NOT NULL,
	carduriagekinngaku3	NUMBER DEFAULT 0 NOT NULL,
	carduriagekinngaku4	NUMBER DEFAULT 0 NOT NULL,
	carduriagekinngaku5	NUMBER DEFAULT 0 NOT NULL,
	carduriagekinngaku6	NUMBER DEFAULT 0 NOT NULL,
	carduriagekinngaku7	NUMBER DEFAULT 0 NOT NULL,
	carduriagekinngaku8	NUMBER DEFAULT 0 NOT NULL,
	carduriagekinngaku9	NUMBER DEFAULT 0 NOT NULL,
	carduriagekinngaku10	NUMBER DEFAULT 0 NOT NULL,
	carduriagekinngaku11	NUMBER DEFAULT 0 NOT NULL,
	carduriagekinngaku12	NUMBER DEFAULT 0 NOT NULL,
	carduriagekinngaku13	NUMBER DEFAULT 0 NOT NULL,
	carduriagekinngaku14	NUMBER DEFAULT 0 NOT NULL,
	carduriagekinngaku15	NUMBER DEFAULT 0 NOT NULL,
	carduriagekinngaku16	NUMBER DEFAULT 0 NOT NULL,
	carduriagekinngaku17	NUMBER DEFAULT 0 NOT NULL,
	carduriagekinngaku18	NUMBER DEFAULT 0 NOT NULL,
	carduriagekinngaku19	NUMBER DEFAULT 0 NOT NULL,
	carduriagekinngaku20	NUMBER DEFAULT 0 NOT NULL,
	shouhinnkennuriagekennsuu	NUMBER DEFAULT 0 NOT NULL,
	shouhinnkennuriagekennsuu1	NUMBER DEFAULT 0 NOT NULL,
	shouhinnkennuriagekennsuu2	NUMBER DEFAULT 0 NOT NULL,
	shouhinnkennuriagekennsuu3	NUMBER DEFAULT 0 NOT NULL,
	shouhinnkennuriagekennsuu4	NUMBER DEFAULT 0 NOT NULL,
	shouhinnkennuriagekennsuu5	NUMBER DEFAULT 0 NOT NULL,
	shouhinnkennuriagekennsuu6	NUMBER DEFAULT 0 NOT NULL,
	shouhinnkennuriagekennsuu7	NUMBER DEFAULT 0 NOT NULL,
	shouhinnkennuriagekennsuu8	NUMBER DEFAULT 0 NOT NULL,
	shouhinnkennuriagekennsuu9	NUMBER DEFAULT 0 NOT NULL,
	shouhinnkennuriagekennsuu10	NUMBER DEFAULT 0 NOT NULL,
	shouhinnkennuriagekennsuu11	NUMBER DEFAULT 0 NOT NULL,
	shouhinnkennuriagekennsuu12	NUMBER DEFAULT 0 NOT NULL,
	shouhinnkennuriagekennsuu13	NUMBER DEFAULT 0 NOT NULL,
	shouhinnkennuriagekennsuu14	NUMBER DEFAULT 0 NOT NULL,
	shouhinnkennuriagekennsuu15	NUMBER DEFAULT 0 NOT NULL,
	shouhinnkennuriagekennsuu16	NUMBER DEFAULT 0 NOT NULL,
	shouhinnkennuriagekennsuu17	NUMBER DEFAULT 0 NOT NULL,
	shouhinnkennuriagekennsuu18	NUMBER DEFAULT 0 NOT NULL,
	shouhinnkennuriagekennsuu19	NUMBER DEFAULT 0 NOT NULL,
	shouhinnkennuriagekennsuu20	NUMBER DEFAULT 0 NOT NULL,
	shouhinnkennuriagekinngaku	NUMBER DEFAULT 0 NOT NULL,
	shouhinnkennuriagekinngaku1	NUMBER DEFAULT 0 NOT NULL,
	shouhinnkennuriagekinngaku2	NUMBER DEFAULT 0 NOT NULL,
	shouhinnkennuriagekinngaku3	NUMBER DEFAULT 0 NOT NULL,
	shouhinnkennuriagekinngaku4	NUMBER DEFAULT 0 NOT NULL,
	shouhinnkennuriagekinngaku5	NUMBER DEFAULT 0 NOT NULL,
	shouhinnkennuriagekinngaku6	NUMBER DEFAULT 0 NOT NULL,
	shouhinnkennuriagekinngaku7	NUMBER DEFAULT 0 NOT NULL,
	shouhinnkennuriagekinngaku8	NUMBER DEFAULT 0 NOT NULL,
	shouhinnkennuriagekinngaku9	NUMBER DEFAULT 0 NOT NULL,
	shouhinnkennuriagekinngaku10	NUMBER DEFAULT 0 NOT NULL,
	shouhinnkennuriagekinngaku11	NUMBER DEFAULT 0 NOT NULL,
	shouhinnkennuriagekinngaku12	NUMBER DEFAULT 0 NOT NULL,
	shouhinnkennuriagekinngaku13	NUMBER DEFAULT 0 NOT NULL,
	shouhinnkennuriagekinngaku14	NUMBER DEFAULT 0 NOT NULL,
	shouhinnkennuriagekinngaku15	NUMBER DEFAULT 0 NOT NULL,
	shouhinnkennuriagekinngaku16	NUMBER DEFAULT 0 NOT NULL,
	shouhinnkennuriagekinngaku17	NUMBER DEFAULT 0 NOT NULL,
	shouhinnkennuriagekinngaku18	NUMBER DEFAULT 0 NOT NULL,
	shouhinnkennuriagekinngaku19	NUMBER DEFAULT 0 NOT NULL,
	shouhinnkennuriagekinngaku20	NUMBER DEFAULT 0 NOT NULL,
	nyuukinn	NUMBER DEFAULT 0 NOT NULL,
	shukkinn	NUMBER DEFAULT 0 NOT NULL,
	gennkinnaridaka	NUMBER DEFAULT 0 NOT NULL,
	regiaridaka	NUMBER DEFAULT 0 NOT NULL,
	gennkinnkabusoku	NUMBER DEFAULT 0 NOT NULL,
	currency1yen	NUMBER DEFAULT 0 NOT NULL,
	currency5yen	NUMBER DEFAULT 0 NOT NULL,
	currency10yen	NUMBER DEFAULT 0 NOT NULL,
	currency50yen	NUMBER DEFAULT 0 NOT NULL,
	currency100yen	NUMBER DEFAULT 0 NOT NULL,
	currency500yen	NUMBER DEFAULT 0 NOT NULL,
	currency1000yen	NUMBER DEFAULT 0 NOT NULL,
	currency2000yen	NUMBER DEFAULT 0 NOT NULL,
	currency5000yen	NUMBER DEFAULT 0 NOT NULL,
	currency10000yen	NUMBER DEFAULT 0 NOT NULL,
	checkdate	DATE,
	seisannid	NUMBER DEFAULT 0 NOT NULL,
	kakinngaku	NUMBER DEFAULT 0 NOT NULL,
	ryougaekaisuu	NUMBER DEFAULT 0 NOT NULL,
	registerno	VARCHAR2(50),
	memo	VARCHAR2(255),
	seisannno	NUMBER DEFAULT 0 NOT NULL
);

CREATE TABLE shainn (
	shainnid	NUMBER PRIMARY KEY,
	shainnmei	VARCHAR2(50),
	shainnmeikana	VARCHAR2(50),
	barcodeno	VARCHAR2(50),
	password	VARCHAR2(50)
);

CREATE TABLE shiiresaki (
	shiiresakiid	NUMBER PRIMARY KEY,
	shiiresakimei	VARCHAR2(100),
	shiiresakimeikana	VARCHAR2(100),
	email	VARCHAR2(50),
	tel	VARCHAR2(50),
	fax	VARCHAR2(50),
	postcode	VARCHAR2(50),
	address	VARCHAR2(50),
	memo1	VARCHAR2(50),
	memo2	VARCHAR2(50),
	memo3	VARCHAR2(50)
);

CREATE TABLE shouhinn (
	shouhinnid	NUMBER PRIMARY KEY,
	shouhinnmei	VARCHAR2(100),
	zaikokijyunn	NUMBER DEFAULT 0 NOT NULL,
	shiirekakaku	NUMBER DEFAULT 0 NOT NULL,
	shouhinnmeikana	VARCHAR2(100),
	memo	VARCHAR2(50),
	barcodeno	VARCHAR2(50),
	shortcutkey	NUMBER DEFAULT 0 NOT NULL,
	hannbaikakaku	NUMBER DEFAULT 0 NOT NULL,
	bumonn	VARCHAR2(50),
	shiiresaki	VARCHAR2(50),
	tax	VARCHAR2(50),
	kosuutanni	VARCHAR2(50),
	tourokudate	DATE,
	memo1	VARCHAR2(50),
	memo2	VARCHAR2(50),
	memo3	VARCHAR2(50),
	memo4	VARCHAR2(50),
	memo5	VARCHAR2(50),
	tennpono	NUMBER DEFAULT 0 NOT NULL,
	nebikiwaribikitaishou	NUMBER DEFAULT 0 NOT NULL,
	pointtaishou	NUMBER DEFAULT 0 NOT NULL,
	macrofilepath	VARCHAR2(50),
	picture	BLOB,
	picturename	VARCHAR2(50)
);

CREATE SEQUENCE goukei_id;
CREATE SEQUENCE kakeurishori_id;
CREATE SEQUENCE sethannbai_id;
CREATE SEQUENCE kokyaku_id;
CREATE SEQUENCE nyushukkamain_id;
CREATE SEQUENCE seisann_id;
CREATE SEQUENCE shainn_id;
CREATE SEQUENCE shiiresaki_id;
CREATE SEQUENCE shouhinn_id;