aerd
Tables (10)
A
- aId — number(38) — Primary key — NOT NULL
- qId — number(38) — Foreign key → Q.qId — NOT NULL
- aTitle — varchar2(100) — NOT NULL
- aContent — varchar2(4000) — NOT NULL
- aWriter — varchar2(100) — NOT NULL
- aDate — date
ADMIN
- aID — VARCHAR2(10)
- aPW — VARCHAR2(100)
- aNAME — VARCHAR2(100)
- aLEVEL — NUMBER(1)
MEMBER
- mId — VARCHAR2(50)
- mPw — VARCHAR2(100) — NOT NULL
- mName — VARCHAR2(30) — NOT NULL
- mPhone — VARCHAR2(100) — NOT NULL
- mEmail — VARCHAR2(100) — NOT NULL
- mAddr — VARCHAR2(200) — NOT NULL
- mPost — VARCHAR2(10) — NOT NULL
NOTICE
- nID — NUMBER(4)
- nWRITER — VARCHAR2(100)
- nPW — VARCHAR2(100)
- nTITLE — VARCHAR2(100)
- nCONTENT — VARCHAR2(4000)
- nDATE — DATE
- nHIT — NUMBER(4)
ORDERS
- oId — number(38)
- mId — VARCHAR2(50) — Foreign key → MEMBER.mId
- oDate — DATE — NOT NULL
- oNmae — VARCHAR2(100) — NOT NULL
- oPhone — VARCHAR2(100) — NOT NULL
- oAddr — VARCHAR2(200) — NOT NULL
- oPost — VARCHAR2(10) — NOT NULL
- oAmount — NUMBER(10) — NOT NULL
PRODUCT
- pId — NUMBER(38)
- pName — VARCHAR2(100) — NOT NULL
- pPrice — NUMBER(10) — NOT NULL
- pStock — NUMBER(10) — NOT NULL
- pImage — VARCHAR2(4000) — NOT NULL
- pDetail — VARCHAR2(4000) — NOT NULL
- pDate — DATE — NOT NULL
- pSell — NUMBER(10) — NOT NULL
- pHit — NUMBER(10) — NOT NULL
Q
- qId — number(38) — Primary key — NOT NULL
- mId — VARCHAR2(50) — Foreign key → MEMBER.mId
- qWriter — varchar2(50)
- qTitle — varchar2(100) — NOT NULL
- qContent — varchar2(4000) — NOT NULL
- qDate — date
- status — number(1) — NOT NULL
- secret — number(1) — NOT NULL
REVIEW
- rID — NUMBER(10)
- pId — NUMBER(38) — Foreign key → PRODUCT.pId
- oId — number(38) — Foreign key → ORDERS.oId
- rWRITER — VARCHAR2(100)
- rPW — VARCHAR2(100)
- rTITLE — VARCHAR2(300)
- rCONTENT — VARCHAR2(4000)
- rRDATE — DATE
WISHLIST
- mId — VARCHAR2(50) — Foreign key → MEMBER.mId
- pId — NUMBER(38) — Foreign key → PRODUCT.pId
- wNum — NUMBER(38)
cart
- cId — NUMBER(10)
- mId — VARCHAR2(50) — Foreign key → MEMBER.mId
- pId — NUMBER(38) — Foreign key → PRODUCT.pId
- cQTY — NUMBER(3)
- cResult — number(2) — NOT NULL
- cDate — date