dd

Tables (6)

class (강의 정보)

  • class_idx (PK) — int — Primary key — NOT NULL
  • teacher_id (Field) — varchar
  • class_name (Field2) — varchar
  • class_day (Field3) — varchar
  • str_day (Field4) — varchar
  • end_day (Field5) — varchar

class_time (강의 시간)

  • class_week (PK1) — Primary key — NOT NULL
  • Key2 (PK2) — Primary key — NOT NULL
  • Key3 (PK3) — Primary key — NOT NULL

enrollment (수강 내역)

    room (강의실 정보)

    • room_idx (PK) — int — Primary key — NOT NULL
    • room_nm (Field) — varchar
    • room_max (Field2) — int
    • Field3

    school_code (학교정보)

    • schl_idx (PK) — int — Primary key — NOT NULL
    • SCHL_NM (Field) — varchar
    • CTPV_EDU_NM (Field2) — varchar
    • SCHL_ROSD_ADDR (Field3) — int
    • SCHL_ADDR (Field4) — varchar
    • Field5

    tb_user (사용자)

    • user_id (PK) — varchar — Primary key — NOT NULL
    • schl_idx (FK) — int — Foreign key → school_code.schl_idx — NOT NULL
    • user_password (Field) — varchar
    • user_nm (Field2) — varchar
    • stud_adventage (Field3) — int
    • sutd_disadvantage (Field4) — int
    • user_type (Field5) — varchar
    • stud_nick_name (Field6) — varchar