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)