ERD Project

Tables (5)

Class (Untitled4)

  • Key — Primary key — NOT NULL
  • 반 (class_no) — int
  • Field

Coach (Untitled3)

  • Key — Primary key — NOT NULL
  • id (coach_id) — int
  • 담당업무 (coach_work) — varchar(50)
  • Field

Consultant (Untitled2)

  • Key — Primary key — NOT NULL
  • id (consultant_id) — int
  • 담당업무 (consultant_work) — varchar(50)

Program (Untitled5)

  • Key — Primary key — NOT NULL

Student (Untitled)

  • Key — Primary key — NOT NULL
  • id (student_id) — int
  • 기수 (order) — int
  • 전공여부 (major) — boolean
  • 퇴소여부 (active) — boolean
  • 지역 (city) — varchar(10)