shop2

Tables (6)

CATEGORIES

  • CATEGORY_ID — NUMBER
  • NAME — VARCHAR2(100)

ORDERS

  • ORDER_ID — NUMBER
  • USER_ID — NUMBER
  • ORDER_DATE — DATE

ORDER_ITEMS

  • ORDER_ITEM_ID — NUMBER
  • ORDER_ID — NUMBER
  • PRODUCT_ID — NUMBER
  • QUANTITY — NUMBER

PAYMENTS

  • PAYMENT_ID — NUMBER
  • ORDER_ID — NUMBER
  • AMOUNT — NUMBER
  • PAYMENT_DATE — DATE

PRODUCTS

  • PRODUCT_ID — NUMBER
  • NAME — VARCHAR2(100)
  • PRICE — NUMBER
  • CATEGORY_ID — NUMBER

USERS

  • USER_ID — NUMBER
  • NAME — VARCHAR2(100)
  • EMAIL — VARCHAR2(100)