ㅂㅈㄷ
Tables (6)
address
- addr_key — NUMBER
- user_id — NUMBER — NOT NULL
- zipcode — VARCHAR2(100) — NOT NULL
- addr — VARCHAR2(200) — NOT NULL
- addrDetail — VARCHAR2(300) — NOT NULL
- req — VARCHAR2(300)
cart
- cart_id — NUMBER
- user_id — NUMBER
- product_id — NUMBER
- quantity — NUMBER
category
- category_key — NUMBER
- category_name — VARCHAR2(100)
product
- product_id — NUMBER
- category_key — NUMBER — NOT NULL
- product_name — VARCHAR2(200) — NOT NULL
- description — VARCHAR2(300)
- thumb — VARCHAR2(200)
- review — NUMBER
review
- product_id — NUMBER
- star — NUMBER
- detailReview — VARCHAR2(300)
- simpleReview — VARCHAR2(200)
- photo — VARCHAR2(200)
users
- user_id — NUMBER
- usertype — VARCHAR2(10)
- username — VARCHAR2(150) — NOT NULL
- password — VARCHAR2(150) — NOT NULL
- email — VARCHAR2(100) — NOT NULL
- phone — VARCHAR2(100) — NOT NULL