test1

Tables (3)

Customer (customer)

  • customer_id (Key) — Primary key — NOT NULL

Ouder (order)

  • od_id (Key) — Primary key — NOT NULL
  • customer_id (Key2) — Foreign key → Customer.customer_id — NOT NULL
  • pd_id (Key3) — Foreign key → Product.pd_id — NOT NULL
  • od_date (Field)
  • od_price (Field2)

Product (product)

  • pd_id (Key) — Primary key — NOT NULL