ssafy_1227
Tables (7)
Copy Of Copy Of Copy Of Untitled2 (Curriculums)
- Key (curriculum_id) — NOT NULL — Primary key — NOT NULL
- Field (Common) — NOT NULL
- Field (Specialized) — NOT NULL
- Field (Voluntary) — NOT NULL
Copy Of Copy Of Untitled2 (Classes)
- Key (class_id) — NOT NULL, CONSTRAINT chk_class_id_range CHECK (class_id BETWEEN 1 AND 6) — Primary key — NOT NULL
- Key (campus_id) — NOT NULL — Foreign key → Copy Of Untitled2.Key — NOT NULL
- Key (consultant_id) — NOT NULL — Foreign key → Untitled.Key — NOT NULL
- Field (Class) — NOT NULL
- Key (coach_id) — NOT NULL — Foreign key → Copy Of Untitled.Key — NOT NULL
Copy Of Untitled (Coaches)
- Key (coach_id) — NOT NULL — Primary key — NOT NULL
- Field (Name) — NOT NULL
Copy Of Untitled2 (Campuses)
- Key (campus_id) — NOT NULL — Primary key — NOT NULL
- Field (Location) — NOT NULL
Untitled (Trainees)
- Key (trainee_id) — NOT NULL — Primary key — NOT NULL
- Key (class_id) — NOT NULL, CONSTRAINT chk_class_id_range CHECK (class_id BETWEEN 1 AND 6) — Foreign key → Copy Of Copy Of Untitled2.Key — NOT NULL
- Key (campus_id) — NOT NULL — Foreign key → Copy Of Copy Of Untitled2.Key — NOT NULL
- Key (consultant_id) — NOT NULL — Foreign key → Copy Of Copy Of Untitled2.Key — NOT NULL
- Field (Name) — NOT NULL
- Field (Computer Major) — NOT NULL
- Field (Retired) — NOT NULL
Untitled (Consultants)
- Key (consultant_id) — NOT NULL — Primary key — NOT NULL
- Field (Name) — NOT NULL
Untitled (Assignments)
- Key (assignment_id) — NOT NULL — Primary key — NOT NULL
- Key (consultant_id) — NOT NULL — Foreign key → Untitled.Key — NOT NULL
- Key (coach_id) — NOT NULL — Foreign key → Copy Of Untitled.Key — NOT NULL
- Field (assigenment_info) — NOT NULL