title_1
Tables (3)
Customer (customer)
- customer_id (Key) — Primary key — NOT NULL
Order (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)
- ord_price (Field2)
Product (product)
- prd_id (Key) — Primary key — NOT NULL