/******************************************
 * Çлý ±âº» Á¤º¸
 ******************************************/
CREATE TABLE TB_STUDENT (
  STUDENT_IDX    INT            IDENTITY(1,1)     NOT NULL,     /* ÇлýÅ×ÀÌºí °íÀ¯Å° */
  KORNAME        VARCHAR(50)                      NOT NULL,     /* ÇѱÛÀ̸§ */
  ENGNAME        VARCHAR(50),                                   /* ¿µ¹®À̸§ */ 
  BIRTHDAY       CHAR(10),                                      /* »ýÀÏ (Çü½Ä:1999-01-01) */
  SEX            CHAR(01)       DEFAULT 'M'       NOT NULL,     /* ¼ºº° */
  INTRODUCE      TEXT,                                          /* ÀÚ±â¼Ò°³ */
  REGDATE        DATETIME       DEFAULT GETDATE() NOT NULL,     /* µî·ÏÀÏ */
  PRIMARY KEY(STUDENT_IDX)
)

/******************************************
 * ÇлýÀÇ Á¡¼ö Á¤º¸
 ******************************************/
CREATE TABLE TB_JUMSU (
  JUMSU_IDX      INT            IDENTITY(1,1)     NOT NULL,     /* Á¡¼öÅ×ÀÌºí °íÀ¯Å° */
  STUDENT_IDX    INT                              NOT NULL,     /* ÇлýÅ×ÀÌºí °íÀ¯Å° */
  COURSE         VARCHAR(255)                     NOT NULL,     /* °úÁ¤¸í */
  JUMSU          INT            DEFAULT '0'       NOT NULL,     /* Á¡¼ö */
  REGDATE        DATETIME       DEFAULT GETDATE() NOT NULL,     /* µî·ÏÀÏ */
  PRIMARY KEY(JUMSU_IDX, STUDENT_IDX)
)