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