daily1_1

Tables (9)

ClassCoaches

  • coach_id — INT — Foreign key → Coaches.coach_id
  • class_id — INT — Foreign key → Classes.class_id

ClassConsultants

  • consultant_id — INT — Foreign key → Consultants.consultant_id
  • class_id — INT — Foreign key → Classes.class_id

Classes

  • class_id — INT — Primary key
  • region — ENUM('서울', '대전', '구미', '광주', '부울경')
  • class_number — INT

Coaches

  • coach_id — INT — Primary key
  • name — VARCHAR(100)
  • task — VARCHAR(255)

Consultants

  • consultant_id — INT — Primary key
  • name — VARCHAR(100)
  • task — VARCHAR(255)

Courses

  • course_id — INT — Primary key
  • course_type — ENUM('공통', '특화', '자율')

TraineeClasses

  • trainee_id — INT — Foreign key → Trainees.trainee_id
  • class_id — INT — Foreign key → Classes.class_id

TraineeCourses

  • trainee_id — INT — Foreign key → Trainees.trainee_id
  • course_id — INT — Foreign key → Courses.course_id

Trainees

  • trainee_id — INT — Primary key
  • name — VARCHAR(100)
  • batch — INT
  • major — ENUM('전공자', '비전공자')
  • status — ENUM('재학', '퇴소')