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