ERD ex

Tables (13)

Report

  • Key (repID) — int(10) — Primary key — NOT NULL
  • Key (classID) — int(10) — Foreign key → Untitled2.Key — NOT NULL
  • Field (repNAME) — char(30)
  • Field (repDESC) — longtext

Untitled (Product)

  • Key (proID) — int(10) — Primary key — NOT NULL
  • Field (proDESC) — longtext
  • Field (proPRICE) — int()
  • Key (parID) — int(10) — Foreign key → Untitled2.Key — NOT NULL
  • Field (parCOUNT) — int(3)

Untitled (Level)

  • Key (classID) — int(10) — Foreign key → Untitled2.Key — NOT NULL
  • Key (memID) — int(10) — Foreign key → Untitled3.Key — NOT NULL
  • Field (levelINFO) — char(8)

Untitled (Customer)

  • Key (cusID) — int(13) — Primary key — NOT NULL
  • Field (cusNAME) — char(30)
  • Field (cusADDRESS) — longtext
  • Field (cusTEL) — int(11)
  • Field

Untitled (Service)

  • Key (serCODE) — int(8) — Primary key — NOT NULL
  • Field (serDESC) — longtext

Untitled (Provider)

  • Key (preID) — int(8) — Primary key — NOT NULL
  • Key (serCODE) — int(8) — Foreign key → Untitled.Key — NOT NULL
  • Field (proNAME) — char(30)
  • Field (proADDRESS) — longtext
  • Field (proTEL) — int(11)

Untitled (DependFamily)

  • Key (depID) — int(13) — Primary key — NOT NULL
  • Key (cusID) — int(13) — Foreign key → Untitled.Key — NOT NULL
  • Field (depNAME) — char(30)
  • Field (depAGE) — int(3)
  • Field

Untitled (Trade)

  • Key (serCODE) — int(8) — Foreign key → Untitled.Key — NOT NULL
  • Key (preID) — int(8) — Foreign key → Untitled.Key — NOT NULL
  • Field (orgaID)

Untitled (Provide)

  • Key (cusID) — int(13) — Foreign key → Untitled.Key — NOT NULL
  • Key (serCODE) — int(8) — Foreign key → Untitled.Key — NOT NULL
  • Key (preID) — int(8) — Foreign key → Untitled.Key — NOT NULL
  • Field (provDATE)

Untitled2 (Partition)

  • Key (parID) — int(10) — Primary key — NOT NULL
  • Field (parDESC) — longtext

Untitled2 (Class)

  • Key (classID) — int(10) — Primary key — NOT NULL
  • Field (classTIME) — int(2)
  • Field (classLimit) — int(2)
  • Field (classRegister) — int(2)

Untitled3 (Manufacturer)

  • Key (manID) — int(10) — Primary key — NOT NULL
  • Field (manNAME) — char(30)
  • Field (manADRRESS) — longtext
  • Field (manTEL) — int(11)
  • Field (companyID) — int(10)
  • Key (parID) — int(10) — Foreign key → Untitled2.Key — NOT NULL

Untitled3 (Member)

  • Key (memID) — int(10) — Primary key — NOT NULL
  • Field (memNAME) — char(30)
  • Field (memADDRESS) — longtext
  • Field (memAGE) — int(3)