test1

Tables (3)

Customer

  • customer_id (Key) — Primary key — NOT NULL

Order

  • ord_id (Key) — Primary key — NOT NULL
  • customer_id (Key2) — Foreign key → Customer.customer_id — NOT NULL
  • Prd_id (Key3) — Foreign key → Product.Prd_id — NOT NULL
  • ord_date (Field) — NOT NULL
  • ord_price (Field2) — NOT NULL

Product

  • Prd_id (Key) — Primary key — NOT NULL