product
Tables (4)
ProductPart (Untitled3)
- product id (Key2) — char — Foreign key → product.product id — NOT NULL
- PartID (Key) — char — Foreign key → part.PartID — NOT NULL
- PartID (Field) — char
- Quantity (Field2) — int
part (Untitled2)
- PartID (Key) — char — Primary key — NOT NULL
- Description (Field) — text
- partModelNumber (Field2) — char
- partName (Field3) — char
- producer id (Key2) — char — Foreign key → producer.producer id — NOT NULL
producer (Untitled4)
- producer id (Key) — char — Primary key — NOT NULL
- producerName (Field) — char
- PhoneNumber (Field2) — char
- email (Field3) — email
- address (Field4) — char
product (Untitled)
- product id (Key) — char — Primary key — NOT NULL
- Description (Field2) — text
- Price (Field3) — int
- productName (Field) — char