sql btcamp 2

Tables (4)

COMPONENT (Untitled)

  • componentID (Key) — Primary key — NOT NULL
  • product (Field)
  • producerID (Key2) — Foreign key → PRODUCER.producerID — NOT NULL

COMPONENT_PRODUCT (Untitled3)

  • componentID (Key) — Foreign key → COMPONENT.componentID — NOT NULL
  • productID (Key2) — Foreign key → PRODUCT.productID — NOT NULL

PRODUCER (Untitled4)

  • producerID (Key) — Primary key — NOT NULL

PRODUCT (Untitled2)

  • productID (Key) — Primary key — NOT NULL
  • producer (Field)