3주차 연습문제 3번

테이블 (7)

Untitled (CUSTOMER)

  • Key (ssn) — char(14) — 기본 키 — NOT NULL
  • Field (cusName) — char(30)
  • Field (address) — char(70)
  • Field (phone) — int(20)

Untitled (DEPENDENT)

  • Key (depenSsn) — char(14) — 기본 키 — NOT NULL
  • Field (depenName) — char(30)
  • Field (birthDate) — date
  • Key (ssn) — char(14) — 외래 키 → Untitled.Key — NOT NULL

Untitled (PROVIDER)

  • Key (prvdNo) — int — 기본 키 — NOT NULL
  • Field (name) — char(30)
  • Field (phone) — int(20)
  • Field (job) — char(20)
  • Field (address) — char(70)

Untitled (SERVICE)

  • Key (serviceCode) — int — 기본 키 — NOT NULL
  • Field (serviceName) — char(15)
  • Field (description) — text

Untitled (APPLY)

  • Key (ssn) — char(14) — 외래 키 → Untitled.Key — NOT NULL
  • Key (serviceCode) — int — 외래 키 → Untitled.Key — NOT NULL

Untitled (ORGANIZATION)

  • Field (serviceDate) — date
  • Key (serviceCode) — int — 외래 키 → Untitled.Key — NOT NULL
  • Key (ssn) — char(14) — 외래 키 → Untitled.Key — NOT NULL

Untitled (SERVICE_PROVDER)

  • Key (prvdNo) — int — 외래 키 → Untitled.Key — NOT NULL
  • Key (serviceCode) — int — 외래 키 → Untitled.Key — NOT NULL