data.sqlの中身

-- Generated by Ora2Pg, the Oracle database Schema converter, version 1.12

--

-- This program is free software; you can redistribute it and/or modify it under

-- the same terms as Perl itself.

BEGIN TRANSACTION;

INSERT INTO "担当者マスタ" ("担当者id","担当者名","ふりがな","mgr_id","生年月日","性別") VALUES (1,'鈴木','すずき',NULL,'1960-01-23 00:00:00',1);

INSERT INTO "担当者マスタ" ("担当者id","担当者名","ふりがな","mgr_id","生年月日","性別") VALUES (2,'小野','おの',NULL,'1960-08-02 00:00:00',1);

INSERT INTO "担当者マスタ" ("担当者id","担当者名","ふりがな","mgr_id","生年月日","性別") VALUES (3,'斎藤','さいとう',NULL,'1963-10-15 00:00:00',1);

INSERT INTO "担当者マスタ" ("担当者id","担当者名","ふりがな","mgr_id","生年月日","性別") VALUES (4,'藤本','ふじもと',3,'1972-07-18 00:00:00',1);

INSERT INTO "担当者マスタ" ("担当者id","担当者名","ふりがな","mgr_id","生年月日","性別") VALUES (5,'小林','こばやし',3,'1971-02-11 00:00:00',0);

INSERT INTO "担当者マスタ" ("担当者id","担当者名","ふりがな","mgr_id","生年月日","性別") VALUES (6,'伊藤','いとう',2,'1972-04-01 00:00:00',0);

INSERT INTO "担当者マスタ" ("担当者id","担当者名","ふりがな","mgr_id","生年月日","性別") VALUES (7,'佐瀬','させ',2,'1975-02-21 00:00:00',1);

INSERT INTO "担当者マスタ" ("担当者id","担当者名","ふりがな","mgr_id","生年月日","性別") VALUES (8,'宇賀神','うがじん',1,'1975-12-22 00:00:00',1);

INSERT INTO "担当者マスタ" ("担当者id","担当者名","ふりがな","mgr_id","生年月日","性別") VALUES (9,'岡田','おかだ',4,'1972-03-18 00:00:00',1);

INSERT INTO "顧客マスタ" ("顧客id","顧客名","連絡先") VALUES (1,'(株)ワイキキソフト','090-AAAA-AAAA');

INSERT INTO "顧客マスタ" ("顧客id","顧客名","連絡先") VALUES (2,'鈴木商事','090-BBBB-BBBB');

INSERT INTO "顧客マスタ" ("顧客id","顧客名","連絡先") VALUES (3,'斎藤模型店','090-CCCC-CCCC');

INSERT INTO "顧客マスタ" ("顧客id","顧客名","連絡先") VALUES (4,'マクロハード','090-DDDD-DDDD');INSERT INTO "顧客マスタ" ("顧客id","顧客名","連絡先") VALUES (5,'(株)ランヌ','090-EEEE-EEEE');

INSERT INTO "売上データ" ("伝票番号","行番号","処理日","商品id","担当者id","顧客id","数量") VALUES (1,1,'2000-04-06 00:00:00',1,1,2,3);

INSERT INTO "売上データ" ("伝票番号","行番号","処理日","商品id","担当者id","顧客id","数量") VALUES (1,2,'2000-04-06 00:00:00',4,1,2,3);

INSERT INTO "売上データ" ("伝票番号","行番号","処理日","商品id","担当者id","顧客id","数量") VALUES (2,1,'2000-04-12 00:00:00',1,2,1,1);

INSERT INTO "売上データ" ("伝票番号","行番号","処理日","商品id","担当者id","顧客id","数量") VALUES (3,1,'2000-04-18 00:00:00',1,2,2,1);

INSERT INTO "売上データ" ("伝票番号","行番号","処理日","商品id","担当者id","顧客id","数量") VALUES (4,1,'2000-04-26 00:00:00',2,3,4,1);

INSERT INTO "売上データ" ("伝票番号","行番号","処理日","商品id","担当者id","顧客id","数量") VALUES (4,2,'2000-04-26 00:00:00',7,3,4,1);

INSERT INTO "売上データ" ("伝票番号","行番号","処理日","商品id","担当者id","顧客id","数量") VALUES (4,3,'2000-04-26 00:00:00',8,3,4,1);

INSERT INTO "売上データ" ("伝票番号","行番号","処理日","商品id","担当者id","顧客id","数量") VALUES (5,1,'2000-05-08 00:00:00',3,6,1,3);

INSERT INTO "売上データ" ("伝票番号","行番号","処理日","商品id","担当者id","顧客id","数量") VALUES (6,1,'2000-05-12 00:00:00',1,2,5,1);

INSERT INTO "売上データ" ("伝票番号","行番号","処理日","商品id","担当者id","顧客id","数量") VALUES (6,2,'2000-05-12 00:00:00',3,2,5,2);

INSERT INTO "売上データ" ("伝票番号","行番号","処理日","商品id","担当者id","顧客id","数量") VALUES (7,1,'2000-05-19 00:00:00',2,5,4,1);

INSERT INTO "売上データ" ("伝票番号","行番号","処理日","商品id","担当者id","顧客id","数量") VALUES (8,1,'2000-05-22 00:00:00',2,6,1,1);

INSERT INTO "売上データ" ("伝票番号","行番号","処理日","商品id","担当者id","顧客id","数量") VALUES (9,1,'2000-05-25 00:00:00',5,8,2,5);

INSERT INTO "売上データ" ("伝票番号","行番号","処理日","商品id","担当者id","顧客id","数量") VALUES (10,1,'2000-06-02 00:00:00',5,2,1,1);

INSERT INTO "売上データ" ("伝票番号","行番号","処理日","商品id","担当者id","顧客id","数量") VALUES (11,1,'2000-06-06 00:00:00',2,3,3,2);

INSERT INTO "売上データ" ("伝票番号","行番号","処理日","商品id","担当者id","顧客id","数量") VALUES (11,2,'2000-06-06 00:00:00',10,3,3,1);

INSERT INTO "売上データ" ("伝票番号","行番号","処理日","商品id","担当者id","顧客id","数量") VALUES (12,1,'2000-06-12 00:00:00',2,6,2,1);

INSERT INTO "売上データ" ("伝票番号","行番号","処理日","商品id","担当者id","顧客id","数量") VALUES (13,1,'2000-06-15 00:00:00',9,7,5,5);

INSERT INTO "売上データ" ("伝票番号","行番号","処理日","商品id","担当者id","顧客id","数量") VALUES (13,2,'2000-06-15 00:00:00',2,7,5,2);

INSERT INTO "支店担当者マスタ" ("支店担当者id","支店担当者名","ふりがな","mgr_id","生年月日","性別") VALUES (4,'藤本','ふじもと',NULL,'1972-07-18 00:00:00',1);

INSERT INTO "支店担当者マスタ" ("支店担当者id","支店担当者名","ふりがな","mgr_id","生年月日","性別") VALUES (9,'岡田','おかだ',4,'1972-03-18 00:00:00',1);

INSERT INTO "支店担当者マスタ" ("支店担当者id","支店担当者名","ふりがな","mgr_id","生年月日","性別") VALUES (10,'田中','たなか',9,'1975-05-23 00:00:00',1);

INSERT INTO "支店担当者マスタ" ("支店担当者id","支店担当者名","ふりがな","mgr_id","生年月日","性別") VALUES (11,'井上','いのうえ',9,'1980-02-18 00:00:00',1);

INSERT INTO "支店担当者マスタ" ("支店担当者id","支店担当者名","ふりがな","mgr_id","生年月日","性別") VALUES (12,'佐々木','ささき',9,'1968-10-10 00:00:00',1);

INSERT INTO "商品マスタ" ("商品id","商品名","グループ名","仕入単価","卸単価") VALUES (1,'デスクトップ型パソコン','パソコン本体',150000,180000);

INSERT INTO "商品マスタ" ("商品id","商品名","グループ名","仕入単価","卸単価") VALUES (2,'ノート型パソコン','パソコン本体',230000,270000);

INSERT INTO "商品マスタ" ("商品id","商品名","グループ名","仕入単価","卸単価") VALUES (3,'17型_ディスプレイ','周辺機器',40000,50000);

INSERT INTO "商品マスタ" ("商品id","商品名","グループ名","仕入単価","卸単価") VALUES (4,'19型_ディスプレイ','周辺機器',80000,95000);

INSERT INTO "商品マスタ" ("商品id","商品名","グループ名","仕入単価","卸単価") VALUES (5,'15型_液晶ディスプレイ','周辺機器',100000,120000);

INSERT INTO "商品マスタ" ("商品id","商品名","グループ名","仕入単価","卸単価") VALUES (6,'デジタルカメラ','周辺機器',NULL,NULL);

INSERT INTO "商品マスタ" ("商品id","商品名","グループ名","仕入単価","卸単価") VALUES (7,'プリンタ','周辺機器',20000,25000);

INSERT INTO "商品マスタ" ("商品id","商品名","グループ名","仕入単価","卸単価") VALUES (8,'スキャナ','周辺機器',25000,30000);

INSERT INTO "商品マスタ" ("商品id","商品名","グループ名","仕入単価","卸単価") VALUES (9,'HUB','ネットワーク機器',5000,7000);

INSERT INTO "商品マスタ" ("商品id","商品名","グループ名","仕入単価","卸単価") VALUES (10,'ターミナルアダプタ','ネットワーク機器',15000,20000);

END TRANSACTION;