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