erd
Tables (6)
Class (Untitled2)
- no — INT — Primary key — NOT NULL
- num — INT
- track_no — INT — Foreign key → Track.no — NOT NULL
- no (no2) — INT — Foreign key → Region.no — NOT NULL
Class-coach (Untitled5)
- class_no — INT — Foreign key → Class.no — NOT NULL
Class-consultant (Untitled6)
- class_no — INT — Foreign key → Class.no — NOT NULL
- consultant_no (no2) — INT — Foreign key → Class.no — NOT NULL
Region (Untitled4)
- no — INT — Primary key — NOT NULL
- name — VARCHAR(10)
Track (Untitled3)
- no — INT — Primary key — NOT NULL
- name — VARCHAR(10)
Trainee (Untitled)
- no (Key) — INT — Primary key — NOT NULL
- generation (Field) — INT
- is_major (Field2) — VARCHAR(1)
- is_exit (Field3) — VARCHAR(1)