망

테이블 (8)

company (Untitled7)

  • participant, employee (Key) — 기본 키 — NOT NULL

course participant (Untitled)

  • participant code (code) — not null — 기본 키 — NOT NULL
  • participant code (code2) — not null — 외래 키 → seminar.participant code — NOT NULL
  • edition code (Key) — 외래 키 → edition.edition code — NOT NULL
  • participant code (code3) — not null — 외래 키 → edition.participant code — NOT NULL
  • participant code (code22) — not null — 외래 키 → edition.participant code — NOT NULL
  • social security number — not null
  • surname — not null
  • age
  • sex
  • place of birth (Field2)
  • employer’s name (Field3)
  • address (Field4)
  • telephone number (Field5)
  • previous employers (Field6)
  • periods employed (Field7)
  • the courses attended (Field8)
  • final assessment for each course (Field9)

edition (Untitled5)

  • edition code (Key) — 기본 키 — NOT NULL
  • participant code (code) — not null — 외래 키 → course participant.participant code — NOT NULL
  • participant code (code2) — not null — 외래 키 → course participant.participant code — NOT NULL
  • edition code (Key2) — 외래 키 → course participant.edition code — NOT NULL
  • participant code (code3) — not null — 외래 키 → course participant.participant code — NOT NULL
  • participant code (code22) — not null — 외래 키 → course participant.participant code — NOT NULL
  • title (Field2)
  • start date (Field3)
  • end date (Field4)
  • the number of participants (Field5)

instructor (Untitled2)

  • participant code (code) — not null — 외래 키 → course participant.participant code — NOT NULL
  • participant code (code2) — not null — 외래 키 → course participant.participant code — NOT NULL
  • edition code (Key) — 외래 키 → course participant.edition code — NOT NULL
  • participant code (code3) — not null — 외래 키 → course participant.participant code — NOT NULL
  • participant code (code22) — not null — 외래 키 → course participant.participant code — NOT NULL
  • edition of the course taught (Field)
  • edition taught in the past (Field2)
  • courses that the tutor is qualified to teach (Field3)

non self-employed trainee (Untitled3)

  • participant code (code) — not null — 외래 키 → course participant.participant code — NOT NULL
  • participant code (code2) — not null — 외래 키 → course participant.participant code — NOT NULL
  • edition code (Key) — 외래 키 → course participant.edition code — NOT NULL
  • participant code (code3) — not null — 외래 키 → course participant.participant code — NOT NULL
  • participant code (code22) — not null — 외래 키 → course participant.participant code — NOT NULL

self-employed trainee (Untitled8)

  • participant code (code) — not null — 외래 키 → course participant.participant code — NOT NULL
  • participant code (code2) — not null — 외래 키 → course participant.participant code — NOT NULL
  • edition code (Key) — 외래 키 → course participant.edition code — NOT NULL
  • participant code (code3) — not null — 외래 키 → course participant.participant code — NOT NULL
  • participant code (code22) — not null — 외래 키 → course participant.participant code — NOT NULL
  • area of expertise (Field)
  • title (Field2)

seminar (Untitled4)

  • participant code (code) — not null — 외래 키 → course participant.participant code — NOT NULL
  • participant code (code2) — not null — 외래 키 → course participant.participant code — NOT NULL
  • edition code (Key) — 외래 키 → course participant.edition code — NOT NULL
  • participant code (code3) — not null — 외래 키 → course participant.participant code — NOT NULL
  • participant code (code22) — not null — 외래 키 → course participant.participant code — NOT NULL
  • place the classes are held (place)
  • time the classes are held (time)

somebody who works for a company (Untitled6)

  • participant, employee (Key) — 외래 키 → company.participant, employee — NOT NULL
  • level (Field)
  • position (Field2)