shop2

Tables (7)

CWHRS_DEPARTMENTS

  • DEPT_ID — NUMBER
  • DEPT_NAME — VARCHAR2(60 BYTE)

CWHRS_ORDERS

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

CWHRS_ORDER_ITEMS

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

CWHRS_PAYMENTS

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

CWHRS_PRODUCTS

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

CWHRS_SHIPPING

  • SHIPPING_ID — NUMBER
  • ORDER_ID — NUMBER
  • STATUS — VARCHAR2(60 BYTE)
  • SHIP_DATE — DATE

CWHRS_USERS

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