/*
 System Name    :  TEST                                        
 Entity Name    :  휴가이력                                   
 Table  Name    :  T_GIFTPOINT , T_GIFTMEM
 작성자         :  노정환 					
 작성일         :  2003.12.25                             
 내용           :   선물 받기
 비고	    :  
*/
CREATE TABLE T_GIFTPOINT
(
GIFTID_VC VARCHAR2(5) NOT NULL,
NAME_VC VARCHAR2(20) NOT NULL,
POINT_NU NUMBER NOT NULL
)
/
CREATE TABLE T_GIFTMEM
(
MEMCD_VC VARCHAR2(9) NOT NULL,
NAME_VC  VARCHAR2(20) NOT NULL,
POINT_NU NUMBER NOT NULL
)
/
INSERT INTO T_GIFTPOINT (GIFTID_VC,NAME_VC,POINT_NU) VALUES ('A0001','문화상품권',5000 );
INSERT INTO T_GIFTPOINT (GIFTID_VC,NAME_VC,POINT_NU) VALUES ('A0002','영화티켓',15000);
INSERT INTO T_GIFTPOINT (GIFTID_VC,NAME_VC,POINT_NU) VALUES ('A0003','구두상품권',60000);
INSERT INTO T_GIFTPOINT (GIFTID_VC,NAME_VC,POINT_NU) VALUES ('B0001','한과세트',50000);
INSERT INTO T_GIFTPOINT (GIFTID_VC,NAME_VC,POINT_NU) VALUES ('B0002','과일바구니',30000);
INSERT INTO T_GIFTPOINT (GIFTID_VC,NAME_VC,POINT_NU) VALUES ('B0003','과자종합',20000);
INSERT INTO T_GIFTMEM  (MEMCD_VC,NAME_VC,POINT_NU) VALUES (10,'노정환',40208);
INSERT INTO T_GIFTMEM  (MEMCD_VC,NAME_VC,POINT_NU) VALUES (13,'김현식',100205);
INSERT INTO T_GIFTMEM  (MEMCD_VC,NAME_VC,POINT_NU) VALUES (16,'김선우',80204);
INSERT INTO T_GIFTMEM  (MEMCD_VC,NAME_VC,POINT_NU) VALUES (19,'김유신',50012);
INSERT INTO T_GIFTMEM  (MEMCD_VC,NAME_VC,POINT_NU) VALUES (22,'이순신',8500);
COMMIT;