SSAFY

Tables (8)

Classes

  • ClassID — INT — Primary key — NOT NULL
  • Region — ENUM('서울', '대전', '구미', '광주', '부울경') — NOT NULL
  • ClassNumber — INT — NOT NULL
  • ConsultantID — INT — Foreign key → Consultants.ConsultantID — NOT NULL
  • CoachID — INT — Foreign key → Coaches.CoachID

Coaches

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

Consultants

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

Courses

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

Managers

  • ManagerID — INT — Primary key — NOT NULL
  • Name — VARCHAR(100) — NOT NULL
  • Phone — VARCHAR(15) — NOT NULL
  • Region — VARCHAR(100)
  • Class — VARCHAR(100)
  • Team — VARCHAR(100)

ProjectParticipants

  • ProjectID — INT — Foreign key → Projects.ProjectID — NOT NULL
  • StudentID — INT — Foreign key → Students.StudentID — NOT NULL

Projects

  • ProjectID — INT — Primary key — NOT NULL
  • CourseID — INT — Foreign key → Courses.CourseID — NOT NULL
  • Title — VARCHAR(255) — NOT NULL

Students

  • StudentID — INT — Primary key — NOT NULL
  • Name — VARCHAR(100) — NOT NULL
  • Phone — VARCHAR(15) — NOT NULL
  • CampusRegion — VARCHAR(100) — NOT NULL
  • ClassID — INT — Foreign key → Classes.ClassID
  • Term — INT — NOT NULL
  • Major — ENUM('전공자', '비전공자') — NOT NULL
  • Dropout — BOOLEAN — NOT NULL
  • ManagerID — INT — Foreign key → Managers.ManagerID