¾È³çÇϼ¼¿ä



´Ù¿ìÀÎÅ¥ºê ½Ã½ºÅÛ°³¼±ÆÀ ¹ÚÁöÈÆÀÔ´Ï´Ù.





¿ì¼±  Å×À̺í Ãß°¡ ¿Í Àε¥½º ÀÔ´Ï´Ù.



  CREATE TABLE "TEACHER"."ACT_KOREA_SCHEDULE"
 (    OPEN_CD VARCHAR2(20 BYTE) NOT NULL ENABLE,
     CLASS_CD VARCHAR2(10 BYTE) NOT NULL ENABLE,
     COURSE_CD VARCHAR2(10 BYTE) NOT NULL ENABLE,
     START_YMDHMS1 VARCHAR2(14 BYTE),
    END_YMDHMS1 VARCHAR2(14 BYTE),    
    START_YMDHMS2 VARCHAR2(14 BYTE),
    END_YMDHMS2 VARCHAR2(14 BYTE),
     START_YMDHMS3 VARCHAR2(14 BYTE),
     END_YMDHMS3 VARCHAR2(14 BYTE),
     START_YMDHMS4 VARCHAR2(14 BYTE),
     END_YMDHMS4 VARCHAR2(14 BYTE),
     REG_DATE DATE DEFAULT SYSDATE,
     MOD_DATE DATE DEFAULT SYSDATE, 
 PRIMARY KEY ("OPEN_CD")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  TABLESPACE "USERS"  ENABLE
     ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  TABLESPACE "USERS" ;









  CREATE INDEX "TEACHER"."ACT_KOREA_SCHEDULE_N1" ON "TEACHER"."ACT_KOREA_SCHEDULE" ("CLASS_CD") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  TABLESPACE "USERS" ;


  CREATE INDEX "TEACHER"."ACT_KOREA_SCHEDULE_N2" ON "TEACHER"."ACT_KOREA_SCHEDULE" ("COURSE_CD") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  TABLESPACE "USERS" ;











CREATE TABLE "TEACHER"."ACT_KOREA_ANSWER"
 (    OPEN_CD VARCHAR2(20 BYTE) NOT NULL ENABLE,
     CLASS_CD VARCHAR2(10 BYTE) NOT NULL ENABLE,
     COURSE_CD VARCHAR2(10 BYTE) NOT NULL ENABLE,
     USER_NO NUMBER(10,0) ,
     USER_ID VARCHAR2(20 BYTE) ,
     USER_NM VARCHAR2(30 BYTE) ,
    "STUDY_FLG1" CHAR(1 BYTE) DEFAULT 'S',
    "STUDY_FLG2" CHAR(1 BYTE) DEFAULT 'S',
    "STUDY_FLG3" CHAR(1 BYTE) DEFAULT 'S',
    "STUDY_FLG4" CHAR(1 BYTE) DEFAULT 'S',
    "STUDY_FLG5" CHAR(1 BYTE) DEFAULT 'S',
    "END_YN" CHAR(1 BYTE) DEFAULT 'N', 
 PRIMARY KEY ("OPEN_CD")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  TABLESPACE "USERS"  ENABLE
 ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  TABLESPACE "USERS" ;






   CREATE INDEX "TEACHER"."ACT_KOREA_ANSWER_N1" ON "TEACHER"."ACT_KOREA_ANSWER" ("CLASS_CD") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  TABLESPACE "USERS" ;


  CREATE INDEX "TEACHER"."ACT_KOREA_ANSWER_N2" ON "TEACHER"."ACT_KOREA_ANSWER" ("COURSE_CD") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  TABLESPACE "USERS" ;









2. Ä÷³ Ãß°¡ÀÔ´Ï´Ù.



ALTER TABLE ACT_SCHEDULE ADD (WEEK6_YMDHMS VARCHAR2(14BYTE));

ALTER TABLE ACT_SCHEDULE ADD (WEEK7_YMDHMS VARCHAR2(14BYTE));





  ALTER TABLE ADT_CMASS_SCHEDULE04 ADD (WEEK6_YMDHMS VARCHAR2(14BYTE));

  ALTER TABLE ADT_CMASS_SCHEDULE04 ADD (WEEK7_YMDHMS VARCHAR2(14BYTE));





ÀÔ´Ï´Ù



°¨»çÇÕ´Ï´Ù.