2023_HAN3

Tables (10)

Untitled (CLIENT)

  • Key (clientID) — int(5) — Primary key — NOT NULL
  • Field (name) — char(10)
  • Field (address) — char(100)
  • Field (phone) — int(11)
  • Field (email) — char(100)
  • Field (Ssn) — char(13)

Untitled (DEPENDANT)

  • Key (dependantID) — int(5) — Primary key — NOT NULL
  • Field (name) — char(10)
  • Field (phone) — int(11)
  • Field (clientID) — int(5)
  • Field (Ssn) — char(13)
  • Key (clientID2) — int(5) — Foreign key → Untitled.Key — NOT NULL

Untitled (SERVICEPROVIDER)

  • Key (providerID) — int(100) — Primary key — NOT NULL
  • Field (name) — char(100)
  • Field (address) — char(100)
  • Field (phone) — char(12)
  • Field (grade) — float(3)
  • Field (memo) — longtext
  • Field (type)

Untitled (ENROLL)

  • Key (screID) — integer — Primary key — NOT NULL
  • Field (grade) — cher(2)
  • Field (review) — longtext
  • Field (clientid) — int(5)
  • Field (date) — date
  • Key (clientID) — int(5) — Foreign key → Untitled.Key — NOT NULL
  • Key (serviceID) — int(1000) — Foreign key → Untitled.Key — NOT NULL

Untitled (SERVICE)

  • Key (serviceID) — int(1000) — Primary key — NOT NULL
  • Field (name) — chae(3)
  • Field2 (descripition) — text
  • Field3 (year) — int(4)
  • Field4 (month) — int(2)
  • Field5 (fee) — integer
  • Field6 (subjetID) — int(10)
  • Field7 (projetID)
  • Key — Foreign key → Untitled.Key — NOT NULL
  • Key (providerID) — int(100) — Foreign key → Untitled.Key — NOT NULL

Untitled (SUBJET)

  • Key — Primary key — NOT NULL
  • Field2 (name) — char(30)
  • Field (memo) — longtext

Untitled (NOTE)

  • Key (noteID) — Primary key — NOT NULL
  • Field (serviceID) — int(1000)
  • Field2 (ceseription) — text
  • Field3 (mangerID) — int(100)
  • Field4 (clientID) — int((5)
  • Key (clientID2) — int(5) — Foreign key → Untitled.Key — NOT NULL
  • Key (serviceID2) — int(1000) — Foreign key → Untitled.Key — NOT NULL

Untitled

    Untitled2 (SERVICE_MANAGER)

    • Key (serviceID) — int(1000) — Primary key — NOT NULL
    • Key (mangerID) — int(100) — Foreign key → Untitled3.Key — NOT NULL
    • Key (serviceID2) — int(1000) — Foreign key → Untitled.Key — NOT NULL
    • Field (manegerID)

    Untitled3 (MANGER)

    • Key (mangerID) — int(100) — Primary key — NOT NULL
    • Field (nameID) — char(20)
    • Field2 (phone) — char(20)
    • Field3 (email) — char(30)
    • Field4 (descripition) — text