School-System
Tables (5)
Lecture (Untitled4)
- L_id (Key) — int — Primary key — NOT NULL
- P_id (PK2) — int — Foreign key → Professor.P_id — NOT NULL
- M_id (PK) — int — Foreign key → Major.M_id — NOT NULL
- name (Field) — varchar(20) — NOT NULL
- L_info (Field2) — varchar(50)
- date (Field3) — date
List (Untitled5)
- L_id (Key) — int — Foreign key → Lecture.L_id — NOT NULL
- P_id (PK2) — int — Foreign key → Lecture.P_id — NOT NULL
- S_id (PK) — int — Foreign key → Student.S_id — NOT NULL
- attendance (Field) — int — NOT NULL
- First_point (Field2) — int — NOT NULL
- Last_point (Field3) — int — NOT NULL
- etc_point (Field4) — int
- sum_point (Field5) — int — NOT NULL
- avg_point (Field6) — int — NOT NULL
Major (학과)
- M_id (PK) — int — Primary key — NOT NULL
- M_name (Field) — varchar(20) — NOT NULL
- M_phone (Field2) — varchar(20)
Professor (교수)
- P_id (PK) — int — Primary key — NOT NULL
- name (Field) — varchar(10) — NOT NULL
- ID_CARD (Field2) — varchar(20)
- P_address (Field3) — varchar(40)
- P_phone (Field4) — varchar(20) — NOT NULL
- P_e_mail (Field5) — varchar(40)
- P_photo (Field6) — block
- M_id (PK2) — int — Foreign key → Major.M_id — NOT NULL
Student (Untitled)
- S_id (PK) — int — Primary key — NOT NULL
- S_name (Field) — varchar(10) — NOT NULL
- ID_CARD (Field2) — varchar(20) — NOT NULL
- S_address (Field3) — varchar(40) — NOT NULL
- S_phone (Field4) — varchar(20) — NOT NULL
- S_e_mail (Field5) — varchar(40)
- S_photo (Field6) — block
- M_id (PK2) — int — Foreign key → Major.M_id — NOT NULL
- P_id (PK3) — int — Foreign key → Professor.P_id — NOT NULL