기말고사 ERD

테이블 (4)

Untitled (ORGANIZATION)

  • Key (OrganiId) — Int — 기본 키 — NOT NULL
  • Field (name) — char(50)
  • Field2 (location) — char(50)
  • Field (address) — char(100)
  • Field (contect) — char(50)
  • Field (type) — char(50)

Untitled (TRAINEE)

  • Key (TraineeId) — Int — 기본 키 — NOT NULL
  • Field (name) — char(50)
  • Field (gender) — char(2)
  • Field (contact) — char(50)

Untitled (INSTRUCTOR)

  • Key (InstructorId) — Int — 기본 키 — NOT NULL
  • Field (name) — char(50)
  • Field (gender) — char(2)
  • Field (contact) — char(50)
  • Field (email) — char(50)

Untitled (EducationProgram)

  • Key (ProgramId) — Int — 기본 키 — NOT NULL
  • Field (name) — char(50)
  • Field (description) — text