이정윤-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)