School Achievement

Tables (3)

Class (강좌)

  • SEQ (Primary Key) — int — Primary key — NOT NULL
  • SCH_ID (Primary Key2) — int — Foreign key → Student Information.SCH_ID — NOT NULL
  • SUBJECT (Field) — varchar
  • PROFES (Field2) — varchar
  • SCORE (Field3) — float
  • CLS_ROOM (Field4) — varchar

Major (학부)

  • SEQ1 (Primary Key) — int — Primary key — NOT NULL
  • MJR_NM (Field) — varchar

Student Information (학생정보)

  • SCH_ID (Primary Key) — int — Primary key — NOT NULL
  • SEQ (Primary Key2) — int — Foreign key → Major.SEQ1 — NOT NULL
  • STD_NM (Field) — varchar
  • ID_NUM (Field2) — int
  • PH_NUM (Field3) — varchar