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