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