Seoin Software Academy

Tables (5)

Class

  • PK — Integer — Primary key — NOT NULL
  • Curriculum_id — Integer — Foreign key → Curriculum.PK — NOT NULL
  • Consultant_id — Integer — Foreign key → Consultant.PK — NOT NULL
  • Coach_id — Integer — Foreign key → Coach.PK — NOT NULL
  • Region — Char(Choices)
  • ClassNum — Char(Choices)

Coach

  • PK — Integer — Primary key — NOT NULL
  • Name — Char(50)
  • Phone — Text
  • JobDescription — Text

Consultant

  • PK — Integer — Primary key — NOT NULL
  • Name — Char(50)
  • Phone — Text
  • JobDescription — Text

Curriculum

  • PK — Integer — Primary key — NOT NULL
  • Description — Text

Student

  • PK — Integer — Primary key — NOT NULL
  • Class_id — Integer — Foreign key → Class.PK — NOT NULL
  • Curriculum_id — Integer — Foreign key → Class.Curriculum_id — NOT NULL
  • Consultant_id — Integer — Foreign key → Class.Consultant_id — NOT NULL
  • Coach_id — Integer — Foreign key → Class.Coach_id — NOT NULL
  • Name — Char(50)
  • Phone — Text
  • Address — Text
  • Birthday — Datetime
  • Protector Phone — Text
  • Session — Char(Choices)
  • IsCSMajor — Boolean
  • IsRetirement — Boolean