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)