Requirement
Tables (6)
TBL_CLASSROOM
- classroom_seq — BIGINT — Primary key — NOT NULL
- legion_seq — BIGINT — Foreign key → TBL_LEGION.legion_seq — NOT NULL
- education_course_sequence — BIGINT — Foreign key → TBL_EDUCATION_COURSE.education_course_sequence — NOT NULL
- classroom_number — INTEGER
- classroom_people_number — INTEGER
TBL_COACH
- coach_seq — BIGINT — Primary key — NOT NULL
- classroom_seq — BIGINT — Foreign key → TBL_CLASSROOM.classroom_seq — NOT NULL
- coach_responsibilites (coach_responsibilities) — VARCHAR
TBL_CONSULTANT (CONSULTANT)
- consultant_seq — BIGINT — Primary key — NOT NULL
- classroom_seq — BIGINT — Foreign key → TBL_CLASSROOM.classroom_seq — NOT NULL
- consultant_responsibilities — VARCHAR
TBL_EDUCATION_COURSE
- education_course_sequence — BIGINT — Primary key — NOT NULL
- education_course_name — VARCHAR
- education_course_description — VARCHAR
TBL_LEGION
- legion_seq — BIGINT — Primary key — NOT NULL
- legion_name — VARCHAR
TBL_TRAINEE
- trainee_seq — BIGINT — Primary key — NOT NULL
- classroom_seq — BIGINT — Foreign key → TBL_CLASSROOM.classroom_seq — NOT NULL
- trainee_year — INTEGER
- trainee_major_status — VARCHAR
- trainee_discharge_status — VARCHAR
- trainee_name — VARCHAR
- trainee_age — VARCHAR