이정윤-20202651
테이블 (9)
Courses
- course code (C_CODE) — INT — 기본 키 — NOT NULL
- title (C_TITLE) — TEXT
- edition number (EDITION_NUM) — INT
Courses related to Instructors (I_Courses)
- Instructor code (I_CODE) — INT — 기본 키 — NOT NULL
- course code (C_CODE) — INT — 기본 키 — NOT NULL
- edition number (EDITION_NUM) — INT — 기본 키 — NOT NULL
- Instructor code (I_CODE2) — INT — 외래 키 → Instructors.Instructor code — NOT NULL
- course code (C_CODE2) — INT — 외래 키 → Courses.course code — NOT NULL
- course type ("TAUGHT", "TAUGHT(PAST)", 'QUALIFIED") — VARCHAR(15)
Courses related to Trainees (T_Courses)
- trainee code (T_CODE) — INT — 기본 키 — NOT NULL
- final assessment (T_ASSESMENT) — TEXT — 기본 키 — NOT NULL
- trainee code (T_CODE2) — INT — 외래 키 → Trainees (=Participants).trainee code — NOT NULL
- course code (C_CODE) — INT
- course code (C_CODE2) — INT — 외래 키 → Courses.course code — NOT NULL
Edition number
- edition number (EDITION_NUM) — INT — 기본 키 — NOT NULL
- course code (C_CODE) — INT — 기본 키 — NOT NULL
- course code (C_CODE2) — INT — 외래 키 → Courses.course code — NOT NULL
- start date (START_DATE) — DATE
- end date (END_DATE) — DATE
- number of participants (PARTICIPANT_NUM) — INT
Instructors (Intructors)
- Instructor code (I_CODE) — INT — 기본 키 — NOT NULL
- surname (I_SURNAME) — TEXT
- age (I_AGE) — TINYINT
- telephone number (I_PNUM) — INT
- place of birth (I_BIRTH_PLACE) — TEXT
- employment type (I_EM_TYPE) — VARCHAR(10)
Self-employed
- trainee code (T_CODE) — INT — 기본 키 — NOT NULL
- trainee code (T_CODE2) — INT — 외래 키 → Trainees (=Participants).trainee code — NOT NULL
- area of expertise field (SE_EXPERTISE_FIELD) — TEXT
- title (SE_TITLE) — TEXT
- employment type (T_EM_TYPE) — VARCHAR(15)
Seminars
- trainee code (T_CODE) — INT — 기본 키 — NOT NULL
- trainee code (T_CODE2) — INT — 외래 키 → Trainees (=Participants).trainee code — NOT NULL
- seminar attendance (SEMINAR) — VARCHAR(5)
- attendance date (S_DATE) — DATE
- places (S_PLACES) — TEXT
- times (S_TIMES) — TEXT
Trainees (=Participants) (Trainees)
- trainee code (T_CODE) — INT — 기본 키 — NOT NULL
- surname (T_SURNAME) — VARCHAR(50)
- age (T_AGE) — TINYINT
- sex (T_SEX) — VARCHAR(10)
- place of birth (T_BIRTH_PLACE) — TEXT
- address (T_ADDRESS) — TEXT
- telephone number (T_PNUM) — INT
- social security number (T_SSNUM) — INT
- previous employer (T_PREVIOUS_EM) — TEXT
- seminar attendance (SEMINAR) — VARCHAR(5)
- employment type (T_EM_TYPE) — VARCHAR(15)
Works for company (Office worker)
- trainee code (T_CODE) — INT — 기본 키 — NOT NULL
- trainee code (T_CODE2) — INT — 외래 키 → Trainees (=Participants).trainee code — NOT NULL
- period employed (PERIOD_EM) — TEXT
- employer's name (EM_NAME) — TEXT
- level (LEVEL) — VARCHAR(30)
- position (POSITION) — TEXT
- employment type (T_EM_TYPE) — VARCHAR(15)