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