test

Tables (3)

Customer (customer)

  • custoer_id (Key) — Primary key — NOT NULL
  • Field

Order (order)

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

Product (product)

  • prd_id (Key) — Primary key — NOT NULL