/*
 System Name    :  TEST                                        
 Entity Name    : 
 Table  Name    :  T_WORKTIME
 ÀÛ¼ºÀÚ         :  ³ëÁ¤È¯ 					
 ÀÛ¼ºÀÏ         :  2004.03.21                             
 ³»¿ë            :  SQL Á¾ÇÕ¹®Á¦
 ºñ°í	     :  
*/
CREATE TABLE T_WORKTIME
(
SEQ_VC VARCHAR2(9) NOT NULL,
WORKCD_VC VARCHAR2(4) NOT NULL,
TIME_NU NUMERIC(5,2) NOT NULL
)
/
INSERT INTO T_WORKTIME (SEQ_VC,WORKCD_VC,TIME_NU) VALUES (35,'A001',1.17);
INSERT INTO T_WORKTIME (SEQ_VC,WORKCD_VC,TIME_NU) VALUES (42,'B003',0.11);
INSERT INTO T_WORKTIME (SEQ_VC,WORKCD_VC,TIME_NU) VALUES (49,'B004',0.83);
INSERT INTO T_WORKTIME (SEQ_VC,WORKCD_VC,TIME_NU) VALUES (56,'A001',0.89) ;
INSERT INTO T_WORKTIME (SEQ_VC,WORKCD_VC,TIME_NU) VALUES (63,'B004',4.13);
INSERT INTO T_WORKTIME (SEQ_VC,WORKCD_VC,TIME_NU) VALUES (70,'B003',0.28);
INSERT INTO T_WORKTIME (SEQ_VC,WORKCD_VC,TIME_NU) VALUES (77,'C002',2.14);
INSERT INTO T_WORKTIME (SEQ_VC,WORKCD_VC,TIME_NU) VALUES (84,'A001',0.77);
INSERT INTO T_WORKTIME (SEQ_VC,WORKCD_VC,TIME_NU) VALUES (91,'B003',4.01);
INSERT INTO T_WORKTIME (SEQ_VC,WORKCD_VC,TIME_NU) VALUES (98,'A001',1.01);
INSERT INTO T_WORKTIME (SEQ_VC,WORKCD_VC,TIME_NU) VALUES (105,'A001',2.34);
INSERT INTO T_WORKTIME (SEQ_VC,WORKCD_VC,TIME_NU) VALUES (112,'C002',1.18);
INSERT INTO T_WORKTIME (SEQ_VC,WORKCD_VC,TIME_NU) VALUES (119,'B004',0.49);
INSERT INTO T_WORKTIME (SEQ_VC,WORKCD_VC,TIME_NU) VALUES (126,'B004',0.24);
INSERT INTO T_WORKTIME (SEQ_VC,WORKCD_VC,TIME_NU) VALUES (133,'C002',1.13);
COMMIT;