exercise5

Tables (6)

Untitled (ORGANIZATION)

  • Key (orgaId) — Primary key — NOT NULL
  • Field (orgaName)

Untitled (PRODUCTOR)

  • Key (prodId) — Primary key — NOT NULL
  • Field (prodName)
  • Field (prodAddress)
  • Field2 (prodPhone)
  • Key (orgaId) — Foreign key → Untitled.Key — NOT NULL

Untitled (SERVICE)

  • Key (serviceCode) — Primary key — NOT NULL
  • Key (prodId) — Foreign key → Untitled.Key — NOT NULL
  • Field (serviceContent)
  • Field (serviceDate)

Untitled (CUSTOMER)

  • Key (custId) — Primary key — NOT NULL
  • Field (custName)
  • Field (custAddress)
  • Field (custPhone)
  • Key (orgaId) — Foreign key → Untitled.Key — NOT NULL

Untitled (DEPENDENT)

  • Key (dependId) — Primary key — NOT NULL
  • Field (dependName)
  • Field (dependAge)
  • Key (custId) — Foreign key → Untitled.Key — NOT NULL

Untitled (PER_SERVICE)

  • Key (custId) — Foreign key → Untitled.Key — NOT NULL
  • Key (serviceCode) — Foreign key → Untitled.Key — NOT NULL
  • Key (prodId) — Foreign key → Untitled.Key — NOT NULL