2023_webDB_ex3

Tables (6)

ORGANIZATION (CLIENT)

  • Key (memSsn) — char(13) — Primary key — NOT NULL
  • Field (memName) — char(30)
  • Field (memAddress) — char(50)
  • Field (memTel) — char(30)
  • Field (memAge) — int

Untitled (FAMILY)

  • Key (famSsn) — char(13) — Primary key — NOT NULL
  • Field (famName) — char(20)
  • Field (famAge) — int

Untitled (SERVICE)

  • Key (serviceId) — char(30) — Primary key — NOT NULL
  • Field (name) — char(30)
  • Field (description) — text
  • Field (year) — int(4)
  • Field (month) — int(2)
  • Field (fee) — integer

Untitled (SERVICE_PROVIDER)

  • Key (proCode) — char(30) — Primary key — NOT NULL
  • Field (proName) — char(30)
  • Field (proAddress) — char(50)
  • Field (proTel) — char(30)

Untitled (GETTING_SERVICE)

    Untitled (ENROLL)

    • Key (sereId) — integer — Primary key — NOT NULL
    • Field (grade) — char(3)
    • Field (review) — LONGTEXT
    • Field (date) — date
    • Field