Exercise1
Tables (3)
Idem (Untitled3)
- idemID (Key) — int — Primary key — NOT NULL
- idemACC (Field) — char(1000)
- partID (Key2) — int — Foreign key → Part.partID — NOT NULL
Maker (Untitled2)
- maketID (Key) — int — Primary key — NOT NULL
- makerName (Field) — char(30)
- makerADD (Field2) — char(50)
- makerPhone (Field3) — int
Part (Untitled)
- partID (Key) — int — Primary key — NOT NULL
- partACC (Field) — chat(100)
- idemID (Key2) — int — Foreign key → Idem.idemID — NOT NULL
- maketID (Key3) — int — Foreign key → Maker.maketID — NOT NULL