ERD EXCERCISE 3

Tables (7)

Untitled (고객)

  • Key (clientID) — INTEGER — Primary key — NOT NULL
  • Field (name) — char(20)
  • Field (address) — char(50)

Untitled (service)

  • Key (serid) — integer — Primary key — NOT NULL
  • Field (description) — text
  • Key (proviID) — integer — Foreign key → Untitled2.Key — NOT NULL
  • Key (subjID) — integer — Foreign key → Untitled.Key — NOT NULL
  • Key (managerID) — integer — Foreign key → Untitled.Key — NOT NULL

Untitled (DEPENDENT)

  • Key (depenID) — integer — Primary key — NOT NULL
  • Field (name) — char(20)
  • Field (age) — char(10)
  • Key (clientID) — INTEGER — Foreign key → Untitled.Key — NOT NULL

Untitled (client-service)

  • Key (clieID) — integer — Primary key — NOT NULL
  • Field (grade) — char(20)
  • Key (clientID) — INTEGER — Foreign key → Untitled.Key — NOT NULL
  • Key (serid) — integer — Foreign key → Untitled.Key — NOT NULL
  • Field (date) — date

Untitled (정책)

  • Key (subjID) — integer — Primary key — NOT NULL
  • Field

Untitled (manager)

  • Key (managerID) — integer — Primary key — NOT NULL

Untitled2 (제공자)

  • Key (proviID) — integer — Primary key — NOT NULL
  • Field (name) — char(20)
  • Field