project
Tables (6)
Class (Untitled2)
- ClassID (classid) — int(PK) — Primary key — NOT NULL
- id (id2) — int(PK) — Foreign key → Consultant.id — NOT NULL
- id (id3) — int(PK) — Foreign key → Coach.id — NOT NULL
- Region (region) — text
- ClassNumber (classnumber) — int
- TrainingCourseID (training_course_id) — int
Coach (Untitled6)
- id — int(PK) — Primary key — NOT NULL
- WorkType (Field)
Consultant (Untitled5)
- id — int(PK) — Primary key — NOT NULL
- WorkType (Field)
Region (Untitled3)
- id — int(PK) — Primary key — NOT NULL
- id (id2) — int(PK) — Foreign key → Consultant.id — NOT NULL
- id (id3) — int(PK) — Foreign key → Coach.id — NOT NULL
- Region Name (Region_name) — text
Trainee (Untitled)
- id — int(PK) — Primary key — NOT NULL
- ClassID (classid2) — int — Foreign key → Class.ClassID — NOT NULL
- id (id22) — int(PK) — Foreign key → Class.id — NOT NULL
- id (id3) — int(PK) — Foreign key → Class.id — NOT NULL
- Generation (generation) — int
- MajorStatus (major_status) — text
- Dropout (dropout) — boolean
TrainingCourse (Untitled4)
- TrainingCourseID (Key) — int(PK) — Primary key — NOT NULL
- id — int(PK) — Foreign key → Consultant.id — NOT NULL
- id (id2) — int(PK) — Foreign key → Coach.id — NOT NULL
- CourserName (Field) — text