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