ERD Exercise3

Tables (8)

Untitled (CUSTOMER)

  • Key (customerID) — char(10) — Primary key — NOT NULL
  • Field (customerName) — char(10)
  • Field (phone) — char(12)
  • Field (adress) — char(30)
  • Field (resistrationNum) — char(13)

Untitled (CUSTOMER_FAMILLY)

  • Key (customerID) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Field (resistrationNum) — char(13)
  • Field (name) — char(10)
  • Field (phone) — char(12)
  • Field (adress) — char(30)
  • Field (FamilltRelation) — char(6)

Untitled (LOCAL_COMMUNITY)

  • Key (communityID) — char(10) — Primary key — NOT NULL
  • Field (Name) — char(20)
  • Field (adress) — char(30)
  • Field (phone) — char(12)
  • Field (description) — text

Untitled (MAIN_SERVICE)

  • Key (serviceCord) — char(10) — Primary key — NOT NULL
  • Key (communityID) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Field (description) — text
  • Key (serverID) — char(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (SERVER)

  • Key (serverID) — char(10) — Primary key — NOT NULL
  • Field (serverName) — char(10)
  • Field (adress) — char(30)
  • Field (phone) — char(12)

Untitled (SERVICE)

  • Key (serviceCord) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Field (serviceDay) — date
  • Field (description) — text
  • Key (customerID) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (customerID2) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (communityID) — char(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (PRIVATE_SERVICE)

  • Key (serviceCord) — char(10) — Primary key — NOT NULL
  • Key (communityID) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Field (description) — text
  • Field (adress) — char(30)
  • Field (phone) — char(12)
  • Field (seviceName) — char(20)

Untitled (SERVICE_2)

  • Key (customerID) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (customerID2) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (serviceCord) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (communityID) — char(10) — Foreign key → Untitled.Key — NOT NULL