joo
Tables (16)
BASKET
- id — number(10)
- u_id — number(10) — NOT NULL
- estimated_price — number(10)
BASKET_PRODUCTS
- id — number(10)
- b_id — number(10) — NOT NULL
- p_id — number(10) — NOT NULL
- pcount — number(2)
BOARDS
- id — number(10)
- u_id — number(10) — NOT NULL
- btitle — varchar2(100) — NOT NULL
- bcontent — varchar2(1000) — NOT NULL
- bimage1 — varchar2(200)
- bimage2 — varchar2(200)
- btype — varchar2(10) — NOT NULL
- bviewed — number(6)
- bcreated_time — timestamp
- bmodified_time — timestamp
- bstart_time — timestamp
- bend_time — timestamp
DELIVERIES
- id — number(10)
- o_id — number(10) — NOT NULL
- dcode — varchar2(10) — NOT NULL
- dstreet — varchar2(500) — NOT NULL
- ddetail_address — varchar2(500) — NOT NULL
- dpostcode — number(5) — NOT NULL
- rname — varchar2(50) — NOT NULL
- rphone — varchar2(20) — NOT NULL
- dmessage — varchar2(500)
- dprice — number(5)
- dtype — number(1)
- dstatus — varchar2(20)
- dcreated_time — timestamp
- dmodified_time — timestamp
ORDERS
- id — number(10)
- u_id — number(10) — NOT NULL
- oinitial_price — number(8) — NOT NULL
- odiscount_price — number(6) — NOT NULL
- ofinal_price — number(8) — NOT NULL
- opoint — number(5) — NOT NULL
- ostatus — varchar2(20)
- ocreated_time — timestamp
ORDER_PRODUCTS
- id — number(10)
- p_id — number(10) — NOT NULL
- o_id — number(10) — NOT NULL
- pcount — number(2) — NOT NULL
- pprice — number(6) — NOT NULL
PAYMENTS
- id — number(10)
- o_id — number(10) — NOT NULL
- pcreated_time — timestamp
- payment_status — varchar2(20)
PRODUCTS
- id — number(10)
- pname — varchar2(100) — NOT NULL
- pcategory — varchar2(20)
- pdetail_image — varchar2(2000)
- palc — number(2) — NOT NULL
- ptitle_image — varchar2(100) — NOT NULL
- psold — number(5) — NOT NULL
- pregion — varchar2(20) — NOT NULL
- pvolume — varchar2(20) — NOT NULL
- pprice — number(6) — NOT NULL
- pstock — number(5) — NOT NULL
- pcreated_time — timestamp
- pmodified_time — timestamp
P_OPTION
- id — number(10)
- p_id — number(10) — NOT NULL
- pvolume — varchar2(50) — NOT NULL
- price — number(6) — NOT NULL
- stock — number(2)
QUESTIONS
- id — number(10)
- u_id — number(10) — NOT NULL
- p_id — number(10) — NOT NULL
- qtitle — varchar2(100)
- qcontent — varchar2(1000) — NOT NULL
- qtype — varchar2(20)
- qcreated_time — timestamp
- qmodified_time — timestamp
QUESTION_REPLIES
- id — number(10)
- q_id — number(10) — NOT NULL
- reply_content — varchar2(1000) — NOT NULL
- rcreated_time — timestamp
- rmodified_time — timestamp
RECENTLY_VIEWED_PRODUCTS
- id — number(10)
- p_id — number(10) — NOT NULL
- u_id — number(10) — NOT NULL
- created_time — timestamp
REVIEWS
- id — number(10)
- p_id — number(10) — NOT NULL
- o_id — number(10) — NOT NULL
- u_id — number(10) — NOT NULL
- rcontent — varchar2(1000) — NOT NULL
- rratings — number(1) — NOT NULL
- review_image — varchar2(100)
- rcreated_time — timestamp
- rmodified_time — timestamp
REVIEW_REPLIES
- id — number(10)
- r_id — number(10) — NOT NULL
- reply_content — varchar2(1000) — NOT NULL
- rcreated_time — timestamp
- rmodified_time — timestamp
SELECTED_PRODUCTS
- id — number(10)
- u_id — number(10) — NOT NULL
- p_id — number(10) — NOT NULL
- created_time — timestamp
USERS
- id — number(10)
- login_id — varchar2(50) — NOT NULL
- upassword — varchar2(100) — NOT NULL
- uemail — varchar2(100) — NOT NULL
- uphone — varchar2(50) — NOT NULL
- uname — varchar2(50) — NOT NULL
- ugrade — varchar2(50)
- ucurrent_point — number(10)
- utotal_point — number(10)
- ustreet — varchar2(500) — NOT NULL
- udetail_address — varchar2(500) — NOT NULL
- upostcode — number(5) — NOT NULL
- role — varchar2(20) — NOT NULL
- is_authenticated — number(1)
- created_time — timestamp
- modified_time — timestamp