SSAFY

Tables (5)

Class (Entity4)

  • ClassID (KEY) — INT — Primary key
  • Region (attr1) — VARCHAR(20)
  • ClassNumber (attr2) — INT

Coach (Entity3)

  • CoachID (KEY) — INT — Primary key
  • ClassID (KEY2) — INT — Foreign key → Class.ClassID
  • Name (attr1) — VARCHAR(50)
  • Task (attr2) — VARCHAR(100)

Consultant (Entity2)

  • ConsultantID (KEY) — INT — Primary key
  • ClassID (KEY2) — INT — Foreign key → Class.ClassID
  • Name (attr1) — VARCHAR(50)
  • Task (attr2) — VARCHAR(100)

Curriculum (Entity5)

  • curriculumID (KEY) — INT — Primary key
  • Field2 (attr1) — VARCHAR(20)

Student (Entity1)

  • StudentID (KEY) — INT — Primary key
  • curriculumID (KEY2) — INT — Foreign key → Curriculum.curriculumID
  • ClassID (KEY3) — INT — Foreign key → Class.ClassID
  • Name (attr1) — VARCHAR(50)
  • ClassYear (attr2) — INT
  • Major (attr3) — BOOLEAN
  • Graduated (attr4) — BOOLEAN