2023_webDB_week3_ex3

Tables (5)

Untitled (FAMILY)

  • Key (famSsn) — char(14) — Primary key — NOT NULL
  • Field (famName) — char(30)
  • Field (famAge) — int
  • Key (customerSsn) — char(14) — Foreign key → Untitled.Key — NOT NULL

Untitled (SERVICE)

  • Key (serviceCode) — char(2꙼̈0) — Primary key — NOT NULL
  • Field (description) — text

Untitled (PROVIDER)

  • Key (provNo) — int — Primary key — NOT NULL
  • Field (provName) — char(2꙼̈0)
  • Field (address) — char(70)
  • Field (phone) — char(13)
  • Key (serviceCode) — char(2꙼̈0) — Foreign key → Untitled.Key — NOT NULL

Untitled (CUSTOMER)

  • Key (customerSsn) — char(14) — Primary key — NOT NULL
  • Field (customerName) — char(30)
  • Field (address) — char(70)
  • Field (phone) — char(13)

Untitled (PROVIDED SERVICE)

  • Key (serviceDate) — date — Primary key — NOT NULL
  • Key (customerSsn) — char(14) — Foreign key → Untitled.Key — NOT NULL
  • Key (serviceCode) — char(2꙼̈0) — Foreign key → Untitled.Key — NOT NULL