엔티티 추출

테이블 (6)

Class (Untitled5)

  • ClassID (PK) — CharField — 기본 키 — NOT NULL
  • Location (Field) — CharField
  • ClassNum (Field2) — IntegerField
  • CohortIID (FK) — CharField

Coach (Untitled4)

  • CoachID (PK) — CharField — 기본 키 — NOT NULL
  • ClassID (PK2) — CharField — 외래 키 → Class.ClassID — NOT NULL
  • Name (Field) — CharField
  • AssignedClassID (FK) — CharField

Cohort (Untitled2)

  • CohortID (PK) — CharField — 기본 키 — NOT NULL
  • CohortNum (Field) — IntegerField

Consultant (Untitled3)

  • ConsultantID (PK) — CharField — 기본 키 — NOT NULL
  • ClassID (PK2) — CharField — 외래 키 → Class.ClassID — NOT NULL
  • Name (Field) — CharField
  • AssignedClassID (FK) — CharField

Course (Untitled6)

  • CourseID (PK) — CharField — 기본 키 — NOT NULL
  • ClassID (PK2) — CharField — 외래 키 → Class.ClassID — NOT NULL
  • StudentID (PK3) — CharField — 외래 키 → Student.StudentID — NOT NULL
  • CohortID (PK22) — CharField — 외래 키 → Student.CohortID — NOT NULL
  • ClassID (PK32) — CharField — 외래 키 → Student.ClassID — NOT NULL
  • CourseType (Field) — CharField

Student (Untitled)

  • StudentID (PK) — CharField — 기본 키 — NOT NULL
  • CohortID (PK2) — CharField — 외래 키 → Cohort.CohortID — NOT NULL
  • ClassID (PK3) — CharField — 외래 키 → Class.ClassID — NOT NULL
  • Name (Field) — CharField
  • Major (Field2) — CharField
  • ExitStatus (Field3) — CharField