Project MSM
Tables (10)
Authorities (Untitled2)
- AuthorityName — VARCHAR2 — Primary key — NOT NULL
- Authority — VARCHAR2
CART (Untitled9)
- CART_ID — NUMBER — Primary key — NOT NULL
- mId — VARCHAR2 — Foreign key → Member.mId — NOT NULL
- mgNum — NUMBER — Foreign key → Goods.mgNum — NOT NULL
- USER_ID — VARCHAR2
- MGNUM — NUMBER
- AMOUNT — NUMBER
CateGory (Untitled4)
- CATECODE — VARCHAR2 — Primary key — NOT NULL
- CATENAME — VARCHAR2
- CATECODEREF — VARCHAR2
Goods (Untitled3)
- mgNum — NUMBER — Primary key — NOT NULL
- CATECODE — VARCHAR2 — Foreign key → CateGory.CATECODE — NOT NULL
- mgName — VARCHAR2
- mgPrice — NUMBER
- mgContent — VARCHAR2
- mgImg — VARCHAR2
- mgStock — VARCHAR2
Member (Untitled)
- mId — VARCHAR2 — Primary key — NOT NULL
- AuthorityName — VARCHAR2 — Foreign key → Authorities.AuthorityName — NOT NULL
- mPw — VARCHAR2
- mName — VARCHAR2
- mEmail — VARCHAR2
- mPhone — VARCHAR2
- mZip_Code — VARCHAR2
- m_First_Addr — VARCHAR2
- m_Second_Addr — VARCHAR2
- Enabled — NUMBER
- REGDATE — DATE
NOTICE (Untitled6)
- BID — NUMBER — Primary key — NOT NULL
- BTITLE — VARCHAR2
- BDATE — DATE
- BCONTENT — VARCHAR2
- BVIEW — NUMBER
- MID — VARCHAR2
ORDER (Untitled10)
- ORDERNUM — VARCHAR2 — Primary key — NOT NULL
- mId — VARCHAR2 — Foreign key → Member.mId — NOT NULL
- mgNum — NUMBER — Foreign key → Goods.mgNum — NOT NULL
- ORDERDATE — DATE
- ORDERPRODUCTNAME — VARCHAR2
- ORDERAMOUNT — VARCHAR2
- ORDERPRICE — VARCHAR2
- TOTALMONEY — VARCHAR2
- ORDERNAME — VARCHAR2
- ORDERPHONE — VARCHAR2
- ORDERADDR1 — VARCHAR2
- ORDERADDR2 — VARCHAR2
- ORDERADDR3 (ORDERADD3) — VARCHAR2
- ORDERSTATE — VARCHAR2
QnA (Untitled7)
- QID — NUMBER — Primary key — NOT NULL
- QID (QID2) — NUMBER — Foreign key → QnA REPLY.QID — NOT NULL
- QTITLE — VARCHAR2
- QDATE — DATE
- QCONTENT — VARCHAR2
- QREPLY — VARCHAR2
- QPW — VARCHAR2
- QWRITER — VARCHAR2
- QVIEW — NUMBER
QnA REPLY (Untitled8)
- QID — NUMBER — Primary key — NOT NULL
- RID — NUMBER — Primary key — NOT NULL
- CONTENT — VARCHAR2
- WRITER — VARCHAR2
- RDATE — VARCHAR2
TABS (Untitled5)
- DETAILINFO — VARCHAR2
- DELIVERY — VARCHAR2
- REFUND — VARCHAR2
- TID — NUMBER