EX3 준사서A 2022911006

테이블 (9)

Untitled (ORGANIZATION)

  • Key (orID) — char(10) — 기본 키 — NOT NULL
  • Field (name) — char(30)
  • Field (description) — text
  • Field (matchingP) — char(20)

Untitled (SERVICE)

  • Key (serviceID) — char(10) — 기본 키 — NOT NULL
  • Field (s-name) — char(30)
  • Field (year) — integer(4)
  • Field (month) — integer(2)
  • Field (description) — text
  • Key (orID) — char(10) — 외래 키 → Untitled.Key — NOT NULL

Untitled (SERVICE_Time)

  • Key (serviceID) — char(10) — 외래 키 → Untitled.Key — NOT NULL
  • Key (timeID) — dhar(20) — 외래 키 → Untitled.Key — NOT NULL
  • Field (name) — char(30)

Untitled (Time)

  • Key (timeID) — dhar(20) — 기본 키 — NOT NULL
  • Field (time) — integer(20)

Untitled (LECTURER)

  • Key (lecturerID) — char(10) — 기본 키 — NOT NULL
  • Field (workplace) — char(20)
  • Field (name) — char(20)
  • Field (address) — char(30)
  • Field2 (phone) — char(11)
  • Field (description) — text

Untitled (LECTURER_S)

  • Key (lecturerID) — char(10) — 외래 키 → Untitled.Key — NOT NULL
  • Key (serviceID) — char(10) — 외래 키 → Untitled.Key — NOT NULL
  • Field (service) — char(20)
  • Field (time) — char(6)

Untitled (MATCHING_P)

  • Key (orID) — char(10) — 외래 키 → Untitled.Key — NOT NULL
  • wcID (ssn) — char(13) — 외래 키 → WOMEN_CRIENT.wcID — NOT NULL
  • Field (s-name) — char(30)

Untitled3 (FAMILY)

  • Key (ssn) — char(13) — 기본 키 — NOT NULL
  • Field (name) — char(20)
  • Field (age) — char(3)
  • wcID (ssn2) — char(13) — 외래 키 → WOMEN_CRIENT.wcID — NOT NULL

WOMEN_CRIENT

  • wcID (ssn) — char(13) — 기본 키 — NOT NULL
  • Field (name) — char(20)
  • Field (address) — char(30)
  • Field (phone) — char(11)