test

Tables (9)

CLASS

  • Room — INT — Primary key — NOT NULL
  • Time — DateTime — Primary key — NOT NULL
  • Date — Date — Primary key — NOT NULL

COURSE

  • Code — INT — Primary key — NOT NULL
  • Name — INT — NOT NULL

COURSE_EDITION

  • StartDate — INT — Primary key — NOT NULL
  • EndDate — INT — NOT NULL
  • NoOfPart — INT — NOT NULL
  • Code — INT — NOT NULL
  • Type — Int — NOT NULL
  • SSN — INT

EMPLOYER

  • Name — INT — Primary key — NOT NULL
  • Address — INT — NOT NULL
  • Phone — INT — NOT NULL

INSTRUCTOR (강사)

  • SSN — INT — Primary key — NOT NULL
  • Surname — INT — NOT NULL
  • Phone — INT — NOT NULL
  • Age — INT — NOT NULL
  • TownOfBirth — INT — NOT NULL

PASTATTENDANCE

  • SSN — INT — Primary key — NOT NULL
  • StartDate — INT — Primary key — NOT NULL

PASTEMPLOYMENT

  • Name — INT — Primary key — NOT NULL
  • SSN — INT — Primary key — NOT NULL
  • Name (Name2) — INT — Foreign key → EMPLOYER.Name — NOT NULL

QUALIFICATION

  • Code — INT — Primary key — NOT NULL
  • SSN — INT — Primary key — NOT NULL

TRAINEE

  • SSN — INT — Primary key — NOT NULL
  • Surname — INT — NOT NULL
  • Sex — INT — NOT NULL
  • Code — INT — NOT NULL
  • Age — INT — NOT NULL
  • TownOfBirth — INT — NOT NULL