ERD Exercise1
Tables (6)
Untitled (PRODUCTOR)
- prodID (Key) — int(15) — Primary key — NOT NULL
- prodName (Field) — char(15)
- prodAddress (Field2) — char(20)
- prodPH (Field3) — int(12)
- pdtcompID (Key2) — int(15) — Foreign key → Untitled.pdtcompID — NOT NULL
Untitled (COMPONENT)
- compNumber (Key) — int(15) — Primary key — NOT NULL
- compExplanation (Field) — text
- compID (Key3) — int(15) — Foreign key → Untitled.compID — NOT NULL
- prodID (Key2) — int(15) — Foreign key → Untitled.prodID — NOT NULL
Untitled (PRODUCT)
- pdtNum (Key) — int(15) — Primary key — NOT NULL
- pdtExp (Field) — text
- pdtPrice (Field2) — int
- compID (Key2) — int(15) — Foreign key → Untitled.compID — NOT NULL
Untitled (COMPANY)
- compID (Key) — int(15) — Primary key — NOT NULL
- compName (Field) — char(15)
- compAddress (Field2) — char(15)
- compPH (Field3) — int(12)
- pdtcompID (Key2) — int(15) — Foreign key → Untitled.pdtcompID — NOT NULL
Untitled (MAKE)
- compNumber (Key) — int(15) — Foreign key → Untitled.compNumber — NOT NULL
- pdtNum (Key2) — int(15) — Foreign key → Untitled.pdtNum — NOT NULL
- compNumber (Field) — int(15)
- pdtNum (Field2) — int(15)
- amount (Field3) — int
Untitled (PRODUCT COMPANY)
- pdtcompID (Key) — int(15) — Primary key — NOT NULL
- pdtcompName (Field) — char(15)
- pdtcompAddress (Field2) — char(15)
- pdtcompPH (Field3) — int(12)