SSAFY_fesw

Tables (6)

Class (Untitled4)

  • id (PK) — int — Primary key — NOT NULL
  • location (지역) — char(100)
  • class_number (반 번호) — int
  • consultant_id (배정 컨설턴트(FK)) — int

Coach (Untitled3)

  • id (PK) — int — Primary key — NOT NULL
  • name (이름) — char(100)
  • task (담당업무) — char(100)
  • class_id (배정 반(FK)) — int
  • id (PK2) — int — Foreign key → Class.id — NOT NULL

Consultant (Untitled2)

  • id (PK) — int — Primary key — NOT NULL
  • id (PK2) — int — Foreign key → Class.id — NOT NULL
  • name (이름) — char(100)
  • task (담당업무) — char(100)
  • class_id (배정 반(FK)) — int

Course (Untitled5)

  • id (PK) — int — Primary key — NOT NULL
  • name (과정 이름) — char(100)
  • id (PK2) — int — Foreign key → StudentCourse.id — NOT NULL

Student (Untitled)

  • id (PK) — int — Primary key — NOT NULL
  • id (PK2) — int — Foreign key → Class.id — NOT NULL
  • batch (Field) — int
  • is_major (전공자 여부) — boolom
  • Fielde (퇴소 여부) — boolom
  • id (PK3) — int — Foreign key → StudentCourse.id — NOT NULL

StudentCourse (Untitled6)

  • id (PK) — int — Primary key — NOT NULL
  • student_id (교육생(FK)) — int
  • course_id (교육과정(FK)) — int