Comp
Tables (3)
Customer (customer)
- customer_id (Key2) — Primary key — NOT NULL
Order (order)
- order_id (Key) — Primary key — NOT NULL
- customer_id (Key2) — Foreign key → Customer.customer_id — NOT NULL
- prod_id (Key3) — Foreign key → Product.prod_id — NOT NULL
- order_date (Field)
- ord_price (Field2)
Product (product)
- prod_id (Key) — Primary key — NOT NULL