dd
Tables (5)
CARTS
- CART_ID — NUMBER — Primary key — NOT NULL
- USER_ID — VARCHAR2(50) — Foreign key → USERS.USER_ID
- PRODUCT_ID — NUMBER — Foreign key → PRODUCT.PRODUCT_ID
- QUANTITY — NUMBER
- CREATED_AT — DATE
ORDERS
- ORDER_ID — VARCHAR2(20) — Primary key — NOT NULL
- PRODUCT_ID — NUMBER — Foreign key → PRODUCT.PRODUCT_ID
- USER_ID — VARCHAR2(50) — Foreign key → USERS.USER_ID
- ORDER_DATE — DATE — NOT NULL
PRODUCT
- PRODUCT_ID — NUMBER — Primary key — NOT NULL
- PRODUCT_NAME — VARCHAR2(100) — NOT NULL
- BRAND — VARCHAR2(50) — NOT NULL
- PRICE — NUMBER — NOT NULL
- CATEGORY — VARCHAR2(30) — NOT NULL
- STOCK — NUMBER — NOT NULL
- RATING — NUMBER(2,1)
REVIEWS
- REVIEW_ID — VARCHAR2(20) — Primary key — NOT NULL
- USER_ID — VARCHAR2(50) — Foreign key → USERS.USER_ID — NOT NULL
- PRODUCT_ID — NUMBER — Foreign key → PRODUCT.PRODUCT_ID — NOT NULL
- R_CONTENT — VARCHAR2(500) — NOT NULL
- REVIEW_DATE — DATE
USERS
- USER_ID — VARCHAR2(50) — Primary key — NOT NULL
- USER_PW — VARCHAR2(50) — NOT NULL
- USER_NAME — VARCHAR2(30) — NOT NULL
- USER_PHONE — VARCHAR2(20) — NOT NULL
- USER_GRADE — VARCHAR2(10) — NOT NULL
- Field