0810

Tables (3)

PART (Untitled2)

  • parserialno (Key) — Primary key — NOT NULL
  • pardescription (Field)

PRODUCT (Untitled3)

  • prodserialno (Key) — Primary key — NOT NULL
  • proddescription (Field)
  • prodprice (Field2)
  • parserialno (Key2) — Foreign key → PART.parserialno — NOT NULL

PROVIDER (Untitled)

  • provserialno (Key) — Primary key — NOT NULL
  • provname (Field)
  • provaddress (Field2)
  • provcontactno (Field3)
  • parserialno (Key2) — Foreign key → PART.parserialno — NOT NULL