shop2
Tables (7)
customers
- customer_id — NUMBER
- customer_name — VARCHAR2(100)
departments
- dept_id — NUMBER
- dept_name — VARCHAR2(100)
employees
- emp_id — NUMBER
- emp_name — VARCHAR2(100)
- department_id — NUMBER
order_items
- CREATE — TABLE
orders
- order_id — NUMBER
- customer_id — NUMBER
- order_date — DATE
products
- product_id — NUMBER
- product_name — VARCHAR2(100)
- supplier_id — NUMBER
suppliers
- supplier_id — NUMBER
- supplier_name — VARCHAR2(100)