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)