daily_1 엔티티추출 - 2024-06-25 11:32:49

테이블 (5)

Student (교육생)

  • StudentId (student_id) — int — 기본 키 — NOT NULL
  • FirstName (first_name) — Varchar(10)
  • LastName (last_name) — Varchar(10)
  • Course (course) — Char(2)
  • IsMajor (is_major) — Boolean
  • IsLeave (is_leave) — Boolean

Untitled

    class (반)

    • StudentId (student_id) — int — 외래 키 — NOT NULL
    • ConsultantId (consultant_id) — int — 외래 키 — NOT NULL
    • CoachId (coach_id) — int — 외래 키 — NOT NULL
    • Area (area) — Varchar(255)
    • ClassNumber (class_number) — int

    coach (코치)

    • CoachId (coach_id) — int — 기본 키 — NOT NULL
    • FirstName (first_name) — Varchar(10)
    • LastName (last_name) — Varchar(10)
    • Role (role) — Varchar(255)

    consultant (컨설턴트)

    • ConsultantId (consultant_id) — int — 기본 키 — NOT NULL
    • FirstName (first_name) — Varchar(10)
    • LastName (last_name) — Varchar(10)
    • Role (role) — Varchar(255)