\c basic

SELECT setval('seq', 100);

DELETE FROM sales_details;
DELETE FROM sales;
DELETE FROM product;
DELETE FROM category;
DELETE FROM customer;

-- customer•\‚Ιƒf[ƒ^‘}“ό
insert into customer values(1000,'ŽR“c@‘Ύ˜Y',null,null);
insert into customer values(1001,'‘卂@ˆκ˜Y','“Œ‹ž“s',36);
insert into customer values(1015,'ŽR–{@ŽO˜Y','–kŠC“Ή',28);
insert into customer values(1020,'“c’†@–ΎŽq','“Œ‹ž“s',20);
insert into customer values(1025,'’†“c@”ό’qŽq','‘εγ•{',35);
insert into customer values(1030,'ŽR–{@_','‘εγ•{',20);
insert into customer values(1010,'–Ψ‰Ί@”ό—’','“Œ‹ž“s',25);
insert into customer values(1100,'‚“c@‹žŽq','•Ÿ‰ͺŒ§',27);
insert into customer values(1200,'‚‹΄@Lˆκ','‘εγ•{',22);

-- categoryƒf[ƒ^‚π‘}“ό
insert into category values 
   ('AN','ƒAƒjƒ'); 

insert into category values 
   ('SF','‚r‚e'); 

insert into category values 
   ('SU','ƒTƒXƒyƒ“ƒX'); 

-- productƒf[ƒ^‚π‘}“ό
insert into product values
  (10011,'‚r‚e@‰F’ˆ','SF','2011/04/01',300);
insert into product values
  (10012,'‚r‚e@‹β‰Ν','SF','2010/06/01',260);
insert into product values
  (10013,'‚r‚e@‚R‚c','SF','2011/09/01',230);
insert into product values
  (10021,'ƒAƒjƒ@Šw‰€','AN','2009/04/01',220);
insert into product values
  (10022,'ƒAƒjƒ@–`Œ―','AN','2010/09/01',320);
insert into product values
  (20031,'ƒTƒXƒyƒ“ƒX@ŒYŽ–','SU','2008/06/01',140);
insert into product values
  (20032,'ƒTƒXƒyƒ“ƒX@—·s','SU','2010/04/01',210);
insert into product values
  (20033,'ƒTƒXƒyƒ“ƒX@‰f‰ζ','SU','2011/04/01',200);

-- salesƒf[ƒ^‚π‘}“ό
insert into sales values 
   (1,1001,'2011/02/01');

insert into sales values 
  ( 2,1200,'2011/02/10');

insert into sales values 
  ( 3,1030,'2011/02/12');

-- sales_detailsƒf[ƒ^‚π‘}“ό
insert into sales_details values 
   (1,10012,'2011/02/01','2011/02/08');

insert into sales_details values 
  ( 1,20032,'2011/02/02','2011/02/08');

insert into sales_details values 
  ( 2,10013,'2011/02/10','2011/02/15');

insert into sales_details values 
   (2,10012,'2011/02/12',null);

insert into sales_details values 
  ( 3,20032,'2011/02/12','2011/02/19');

insert into sales_details values 
  ( 3,10013,'2011/02/14','2011/02/20');


-- ƒIƒvƒVƒ‡ƒ“‰‰KDB4—p’Η‰Αƒf[ƒ^
INSERT INTO sales VALUES (8, '1020', '2012/03/31');
INSERT INTO sales_details VALUES (8, '10011', '2012/04/01', '2012/04/07');
INSERT INTO sales_details VALUES (8, '10012', '2012/04/01', '2012/04/07');
INSERT INTO sales_details VALUES (8, '10013', '2012/04/01', '2012/04/07');

INSERT INTO sales VALUES (9, '1020', '2012/04/14');
INSERT INTO sales_details VALUES (9, '20031', '2012/04/15', '2012/04/22');
INSERT INTO sales_details VALUES (9, '20032', '2012/04/15', '2012/04/22');