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)