pjt_1

Tables (4)

Student

  • Key — Integer — Primary key — NOT NULL
  • Key (Key2) — Foreign key → class.pk — NOT NULL
  • 교육과정 (education) — String — Foreign key → class.교육과정
  • 전공여부 (ismajor) — boolean
  • 퇴소여부 (Field2) — boolean

class

  • pk — integer — Primary key — NOT NULL
  • 교육과정 (education) — String — Primary key
  • 지역 (region) — String
  • 반 (class_num) — integer

coach

  • pk — integer — Primary key — NOT NULL
  • pk (pk2) — integer — Foreign key → class.pk — NOT NULL
  • 교육과정 (education) — String — Foreign key → class.교육과정

consultant

  • pk — integer — Primary key — NOT NULL
  • pk (pk2) — integer — Foreign key → class.pk — NOT NULL
  • 교육과정 (education) — String — Foreign key → class.교육과정