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