school
Tables (4)
class (Untitled)
- class_id (key) — Primary key — NOT NULL
- grade (Field)
- class_number (Field2)
major (Untitled4)
- major_id (Key) — Primary key — NOT NULL
- name (Field)
student (Untitled2)
- id (Key) — Primary key — NOT NULL
- class_id (id) — Foreign key → class.class_id — NOT NULL
- major_id (Key2) — Foreign key → major.major_id — NOT NULL
- name (Field)
- number (Field2)
teacher (Untitled3)
- teacher_id (Key) — Primary key — NOT NULL
- class_id (key) — Foreign key → class.class_id — NOT NULL
- name (Field)
- type (Field2)