123
Tables (5)
Customer
- customer_id — NUMBER
- name — VARCHAR2(100)
- address — VARCHAR2(200)
- contact_number — VARCHAR2(20)
Order
- order_id — NUMBER
- order_date — DATE
- customer_id — NUMBER
OrderItem
- order_item_id — NUMBER
- order_id — NUMBER
- product_id — NUMBER
- quantity — NUMBER
- price — NUMBER
Order_Product
- order_id — NUMBER
- product_id — NUMBER
Product
- product_id — NUMBER
- name — VARCHAR2(100)
- description — VARCHAR2(200)
- price — NUMBER