2023_webDB_ex03

Tables (6)

Untitled (CUSTOMER)

  • Key (customerSsn) — char(14) — Primary key — NOT NULL
  • Field (customerName) — char(20)
  • Field (customerAddress) — char(200)
  • Field (customerPhone) — char(13)

Untitled (FAMILY)

  • Key (familySsn) — char(14) — Primary key — NOT NULL
  • Field (familyName) — char(20)
  • Field (familyAge) — int
  • Key (customerSsn) — char(14) — Foreign key → Untitled.Key — NOT NULL

Untitled (SERVICE)

  • Key (serviceCode) — char(10) — Primary key — NOT NULL
  • Field (serviceDescription) — text
  • Key (agentID) — char(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (SERVICE_AGENT)

  • Key (agentID) — char(10) — Primary key — NOT NULL
  • Field (agentName) — char(20)
  • Field (agentAddress) — char(200)
  • Field (agentPhone) — char(13)

Untitled (PROVIDE_SERVICE)

  • Key (customerSsn) — char(14) — Foreign key → Untitled.Key — NOT NULL
  • Key (serviceCode) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Field (provideDate) — date

Untitled (NOTE)

  • Key (noteId) — char(10) — Primary key — NOT NULL
  • Field (description) — text
  • Key (serviceCode) — char(10) — Foreign key → Untitled.Key — NOT NULL