정윤호_20163584
테이블 (8)
course (Untitled2)
- course_code (Key) — 기본 키 — NOT NULL
- title (Field)
course participant (Untitled)
- social security number (Key) — 기본 키 — NOT NULL
- participant_code (Key2) — 기본 키 — NOT NULL
- course_code (Key3) — 외래 키 → courses_attended.course_code — NOT NULL
- surname (Field)
- age (Field2)
- sex (Field3)
- place of birth (Field4)
- employer's name (Field5)
- address (Field6)
- telephone number (Field7)
- previous employers (Field8)
- periods employed (Field9)
courses_attended (Untitled8)
- course_code (Key) — 외래 키 → course.course_code — NOT NULL
- courses attended (Field)
- final assessment for each course (Field2)
edition (Untitled3)
- course_code (Key) — 외래 키 → course.course_code — NOT NULL
- start date (Field)
- end date (Field2)
- number of participants (Field3)
instructor (Untitled5)
- course_code (Key) — 외래 키 → instructor_course.course_code — NOT NULL
- surname (Field)
- place of birth (Field2)
- telephone numbers (Field3)
- freelance or working for company (Field4)
instructor_course (Untitled7)
- course_code (Key) — 외래 키 → edition.course_code — NOT NULL
- the edition of the course taught (Field)
- courses taught in the past (Field2)
- courses that tutor is qualified to teach (Field3)
trainee_self-employed (Untitled4)
- social security number (Key) — 외래 키 → course participant.social security number — NOT NULL
- participant_code (Key2) — 외래 키 → course participant.participant_code — NOT NULL
- course_code (Key3) — 외래 키 → course participant.course_code — NOT NULL
- area of expertise (Field)
- title (Field2)
trainee_works for company (Untitled6)
- social security number (Key) — 외래 키 → course participant.social security number — NOT NULL
- participant_code (Key2) — 외래 키 → course participant.participant_code — NOT NULL
- course_code (Key3) — 외래 키 → course participant.course_code — NOT NULL
- level (Field)
- position (Field2)