r

Tables (10)

category

  • cateCode — Primary key — NOT NULL
  • cateName — varchar2(20) — NOT NULL
  • cateCodeRef — varchar2(30)

likeitem

  • mcode (mcode2) — number — Foreign key → mem.mcode — NOT NULL
  • pcode (pcode2) — number — Foreign key → product.pcode — NOT NULL
  • regdate — DATE
  • updateupdate — DATE

mem

  • mcode — number — Primary key — NOT NULL
  • mname — varchar2(15) — NOT NULL
  • mid — varchar2(50) — NOT NULL
  • mpw — varchar2(50) — NOT NULL
  • maddress — varchar2(150)
  • maddress1 — varchar2(150)
  • maddress2 — varchar2(150)
  • maddress3 — varchar2(150)
  • maddress4 — varchar2(150)
  • maddress5 — varchar2(150)
  • mphone — varchar2(20) — NOT NULL
  • memail — varchar2(50) — NOT NULL
  • regdate — DATE
  • updatedate — DATE

order_detail

  • onum — number — Primary key — NOT NULL
  • ocode (ocode2) — number — Foreign key → orderlist.ocode — NOT NULL
  • pcode (pcode2) — number — Foreign key → product.pcode — NOT NULL
  • amount — number — NOT NULL
  • p_detail — varchar2(20) — NOT NULL
  • state — varchar2(20)
  • total — NUMBER — NOT NULL
  • regdate — DATE
  • updatedate — DATE

orderlist

  • ocode — number — Primary key — NOT NULL
  • mcode (mcode2) — number — Foreign key → mem.mcode — NOT NULL
  • totalprice — number — NOT NULL
  • state — varchar2(20)
  • regdate — DATE
  • updatedate — DATE

p_basket

  • mcode (mcode2) — number — Foreign key → mem.mcode — NOT NULL
  • pcode (pcode2) — number — Foreign key → product.pcode — NOT NULL
  • bamount — NUMBER — NOT NULL
  • btotal — NUMBER — NOT NULL
  • bsize — varchar2(20) — NOT NULL
  • bcolor — varchar2(20) — NOT NULL
  • regdate — DATE
  • updateupdate — DATE

product

  • pcode — number — Primary key — NOT NULL
  • scode (scode2) — number — Foreign key → store_mem.scode — NOT NULL
  • cateCode (cateCode2) — Foreign key → category.cateCode — NOT NULL
  • pname — varchar2(100) — NOT NULL
  • pimg — varchar2(1000) — NOT NULL
  • pThumbImg — varchar2(1000) — NOT NULL
  • pprice — number — NOT NULL
  • today — NUMBER
  • best — NUMBER
  • regdate — DATE
  • updatedate — DATE

product_detail

  • pcode (pcode2) — number — Foreign key → product.pcode — NOT NULL
  • psize — varchar2(10)
  • pcolor — varchar2(50)
  • amount — number

review

  • rcode — number — Primary key — NOT NULL
  • ocode (ocode2) — number — Foreign key → orderlist.ocode — NOT NULL
  • mcode (mcode22) — number — Foreign key → orderlist.mcode — NOT NULL
  • pcode (pcode2) — number — Foreign key → product.pcode — NOT NULL
  • scode (scode22) — number — Foreign key → product.scode — NOT NULL
  • review — varchar2(1000) — NOT NULL
  • regdate — DATE
  • updatedate — DATE

store_mem

  • scode — number — Primary key — NOT NULL
  • sname — varchar2(100) — NOT NULL
  • sid — varchar2(50) — NOT NULL
  • spw — varchar2(50) — NOT NULL
  • sphone — varchar2(20) — NOT NULL
  • semail — varchar2(50) — NOT NULL
  • sowner — varchar2(15) — NOT NULL
  • regdate — DATE
  • updatedate — DATE