SSAFY

Tables (7)

ClassCoach

  • ClassCoachID — INT — Primary key
  • ClassID — INT — NOT NULL
  • CoachID — INT
  • ConsultantID — INT — Foreign key → Consultant.ConsultantID

ClassConsultant

  • ClassConsultantID — INT — Primary key
  • ClassID — INT — NOT NULL
  • ConsultantID — INT — NOT NULL

Classes

  • ClassID — INT — Primary key
  • Region — ENUM('서울', '대전', '구미', '광주', '부울경') — NOT NULL
  • ClassNumber — INT — NOT NULL

Coach

  • CoachID — INT — Primary key
  • Name — VARCHAR(100) — NOT NULL
  • Duty — VARCHAR(255) — NOT NULL
  • TraineeID — INT — Foreign key → Trainee.TraineeID

Consultant

  • ConsultantID — INT — Primary key
  • Name — VARCHAR(100) — NOT NULL
  • Duty — VARCHAR(255) — NOT NULL

Course

  • CourseID — INT — Primary key
  • ClassCoachID — INT — Foreign key → ClassCoach.ClassCoachID
  • CourseType — ENUM('공통', '특화', '자율') — NOT NULL

Trainee

  • TraineeID — INT — Primary key
  • Name — VARCHAR(100) — NOT NULL
  • Batch — INT — NOT NULL
  • MajorStatus — ENUM('전공자', '비전공자') — NOT NULL
  • ExitStatus — ENUM('재학', '퇴소') — NOT NULL
  • ClassID (ClassID2) — INT — Foreign key → Classes.ClassID