2023_사서교육원_준사서C반_김종우_예제3

테이블 (4)

Untitled (Supplier)

  • Key (SupNo) — int — 기본 키 — NOT NULL
  • Field (supName) — char(30)
  • Field (supAddress) — char(30)
  • Field (supPhoneNumber) — char(11)
  • Field (belonging) — char(30)

Untitled (Service)

  • Key (serviceCode) — char(30) — 기본 키 — NOT NULL
  • Field (serviceExplanation) — char(30)
  • Field (suppliedDate) — date
  • Key (SupNo) — int — 외래 키 → Untitled.Key — NOT NULL
  • Key (customerSsn) — char(30) — 외래 키 → Untitled.Key — NOT NULL

Untitled (Customer)

  • Key (customerSsn) — char(30) — 기본 키 — NOT NULL
  • Field (customerName) — char(30)
  • Field (customerAddress) — char(30)
  • Field (customerPhoneNumber) — char(11)
  • Field (customerAge) — int
  • Field (Job) — char(30)
  • Field (Income) — int

Untitled (Family)

  • Key (famillySsn) — char(30) — 기본 키 — NOT NULL
  • Field (familyName) — char(30)
  • Field (familyAge) — int
  • Field (familyGender) — char(30)
  • Field (familyAddress) — char(30)
  • Field (Relationship) — char(30)
  • Key (customerSsn) — int — 외래 키 → Untitled.Key — NOT NULL