D
Tables (29)
ADMIN
- ADMINSEQ — NUMBER(7,0)
- ADMINID — VARCHAR2(50 BYTE)
- ADMINPW — VARCHAR2(50 BYTE)
- LOGINTYPE — VARCHAR2(15 BYTE)
BANNERIMGSAVE
- IMGSEQ — NUMBER
- PATHNAME — VARCHAR2(1000 BYTE)
- DBNAME — VARCHAR2(1000 BYTE)
- ORIGNAME — VARCHAR2(1000 BYTE)
- BANNERNUMBER — NUMBER
DELEVERY
- DELEVERYSEQ — NUMBER(7,0)
- NAME — VARCHAR2(50 BYTE)
- PHONE — NUMBER(15,0)
- ADDRESS — VARCHAR2(50 BYTE)
EVENT
- EVENTSEQ — NUMBER(7,0)
- TITLE — VARCHAR2(50 BYTE)
- EVENTCONTENT — VARCHAR2(2000 BYTE)
- INDATE — DATE
- USERSEQ — NUMBER(7,0)
- SELLERSEQ — NUMBER(7,0)
- ADMINSEQ — NUMBER(7,0)
EVENTBOARD
- EVENTBOARDSEQ — NUMBER(7,0)
- BOARDNAME — VARCHAR2(50 BYTE)
- STARTDATE — VARCHAR2(50 BYTE)
- ENDDATE — VARCHAR2(500 BYTE)
- PATHNAME — VARCHAR2(500 BYTE)
- DBNAME — VARCHAR2(500 BYTE)
- ORIGNAME — VARCHAR2(500 BYTE)
- BDBNAME — VARCHAR2(500 BYTE)
- BORIGNAME — VARCHAR2(500 BYTE)
HASHTAG
- SNSSEQ — NUMBER(7,0)
- FIRSTTAG — VARCHAR2(50 BYTE)
- SECONDTAG — VARCHAR2(50 BYTE)
- THIRDTAG — VARCHAR2(50 BYTE)
KNOWHOW
- KNOWHOWSEQ — NUMBER(7,0)
- TITLE — VARCHAR2(200 BYTE)
- INDATE — DATE
- USERSEQ — NUMBER(7,0)
- ADMINSEQ — NUMBER(7,0)
- RECOMMEND — NUMBER
KNOWHOWCOMMENT
- KNOWHOWCOMMENTSEQ — NUMBER(7,0)
- KNOWHOWSEQ — NUMBER(7,0)
- KNOWHOWCOMMENT — VARCHAR2(2000 BYTE)
- INDATE — DATE
- USERSEQ — NUMBER(7,0)
- SELLERSEQ — NUMBER(7,0)
- ADMINSEQ — NUMBER(7,0)
KNOWHOWIMGSAVE
- IMGSEQ — NUMBER(7,0)
- KNOWHOWSEQ — NUMBER(7,0)
- PATHNAME — VARCHAR2(100 BYTE)
- DBNAME — VARCHAR2(100 BYTE)
- INDATE — DATE
- KNOWHOWCONTENT — VARCHAR2(2000 BYTE)
LIKEFLAG
- SNSSEQ — NUMBER(7,0)
- USERSEQ — NUMBER(7,0)
- FLAG — NUMBER(1,0)
LIKENUM
- LIKESEQ — NUMBER(7,0)
- SNSSEQ — NUMBER(7,0)
- HEARTNUM — NUMBER
ORDEREDPRODUCT
- ORDERSEQ — NUMBER(7,0)
- PRODUCTSEQ — NUMBER(7,0)
- AMOUNT — NUMBER
ORDERTABLE
- ORDERSEQ — NUMBER(7,0)
- USERSEQ — NUMBER(7,0)
- DELEVERYSEQ — NUMBER(7,0)
- BUYDATE — DATE
- ADDRESS — VARCHAR2(50 BYTE)
- PHONE — NUMBER(30,0)
- REALTIME — VARCHAR2(20 BYTE)
- PRICE — NUMBER
- INDATE — DATE
PRODUCT
- PRODUCTSEQ — NUMBER(7,0)
- SELLERSEQ — NUMBER(7,0)
- PRODUCTNAME — VARCHAR2(50 BYTE)
- PRICE — NUMBER
- COUNTOFPRODUCTS — NUMBER(5,0)
- PRODUCTCONTENT — VARCHAR2(2000 BYTE)
- INDATE — DATE
- SALERATE — NUMBER
- BIGTYPE — VARCHAR2(50 BYTE)
- MIDDLETYPE — VARCHAR2(50 BYTE)
- SMALLTYPE — VARCHAR2(50 BYTE)
- RANKSEQ — NUMBER
- SELLCOUNT — NUMBER
- YESORNO — VARCHAR2(20 BYTE)
PRODUCTIMGSAVE
- IMGSEQ — NUMBER(7,0)
- PRODUCTSEQ — NUMBER(7,0)
- PATHNAME — VARCHAR2(100 BYTE)
- DBNAME — VARCHAR2(100 BYTE)
QUESTION
- QUESTIONSEQ — NUMBER(7,0)
- TITLE — VARCHAR2(50 BYTE)
- EVENTCONTENT — VARCHAR2(2000 BYTE)
- INDATE — DATE
- USERID — VARCHAR2(50 BYTE)
- SELLERSEQ — NUMBER(7,0)
- ADMINSEQ — NUMBER(7,0)
QUESTIONCOMMENT
- QUESTIONCOMMENTSEQ — NUMBER(7,0)
- QUESTIONSEQ — NUMBER(7,0)
- QUESTIONCOMMENT — VARCHAR2(2000 BYTE)
- INDATE — DATE
- USERSEQ — NUMBER(7,0)
- SELLERID — VARCHAR2(30 BYTE)
- ADMINSEQ — NUMBER(7,0)
SCRAB
- SCRABSEQ — NUMBER(7,0)
- SNSSEQ — NUMBER(7,0)
- USERSEQ — NUMBER(7,0)
- INDATE — DATE
SEARCHWORD
- SEARCHWORD — VARCHAR2(50 BYTE)
- INCREASENUM — NUMBER
- SEARCHTYPE — VARCHAR2(50 BYTE)
SELLBOARD
- SELLBOARDSEQ — NUMBER(7,0)
- TITLE — VARCHAR2(50 BYTE)
- CONTENT — VARCHAR2(2000 BYTE)
- COUNT — NUMBER
- INDATE — DATE
- SELLERSEQ — NUMBER(7,0)
- ADMINSEQ — NUMBER(7,0)
- PRODUCTSEQ — NUMBER(7,0)
SELLCOMMENT
- SELLCOMMENTSEQ — NUMBER(7,0)
- SELLBOARDSEQ — NUMBER(7,0)
- SELLCOMMENT — VARCHAR2(200 BYTE)
- INDATE — DATE
- USERSEQ — NUMBER(7,0)
- SELLERSEQ — NUMBER(7,0)
- ADMINSEQ — NUMBER(7,0)
SELLER
- SELLERSEQ — NUMBER(7,0)
- LOGINTYPE — VARCHAR2(15 BYTE)
- CONTRACTNAME — VARCHAR2(50 BYTE)
- CONTRACTPW — VARCHAR2(50 BYTE)
- COMPANYINFO — VARCHAR2(30 BYTE)
- PHONE — NUMBER
- EMAIL — VARCHAR2(50 BYTE)
- POSTALNUM — VARCHAR2(50 BYTE)
- ACCOUNT — VARCHAR2(50 BYTE)
- INDATE — DATE
- ABLE — NUMBER
- COUNTRY — VARCHAR2(30 BYTE)
SHOPPINGCART
- CARTSEQ — NUMBER(7,0)
- USERSEQ — NUMBER(7,0)
- PRODUCTSEQ — NUMBER(7,0)
- AMOUNT — NUMBER
- INDATE — DATE
SNS
- SNSSEQ — NUMBER(7,0)
- USERSEQ — NUMBER(7,0)
- SNSCONTENT — VARCHAR2(2000 BYTE)
- COUNT — NUMBER
- INDATE — DATE
SNSCOMMENT
- COMMENTSEQ — NUMBER(7,0)
- SNSSEQ — NUMBER(7,0)
- SNSCOMMENT — VARCHAR2(200 BYTE)
- INDATE — DATE
- USERSEQ — NUMBER(7,0)
- SELLERSEQ — NUMBER(7,0)
- ADMINSEQ — NUMBER(7,0)
SNSIMGSAVE
- IMGSEQ — NUMBER(7,0)
- SNSSEQ — NUMBER(7,0)
- PATHNAME — VARCHAR2(100 BYTE)
- DBNAME — VARCHAR2(100 BYTE)
USERIMG
- IMGSEQ — NUMBER(7,0)
- USERSEQ — NUMBER(7,0)
- PATHNAME — VARCHAR2(100 BYTE)
- DBNAME — VARCHAR2(100 BYTE)
USERS
- USERSEQ — NUMBER(7,0)
- USERID — VARCHAR2(50 BYTE)
- USERPW — VARCHAR2(50 BYTE)
- USERNAME — VARCHAR2(15 BYTE)
- USERGENDER — VARCHAR2(9 BYTE)
- USERBIRTH — DATE
- USERADDRESS — VARCHAR2(50 BYTE)
- USERPHONE — NUMBER(11,0)
- USERNATIONALITY — VARCHAR2(15 BYTE)
- USERGRADE — VARCHAR2(9 BYTE)
- INDATE — DATE
- USERCHOICE — VARCHAR2(15 BYTE)
- POINT — NUMBER
- LOGINTYPE — VARCHAR2(15 BYTE)
- ABLE — NUMBER
WISHLIST
- WISHSEQ — NUMBER(7,0)
- USERSEQ — NUMBER(7,0)
- PRODUCTSEQ — NUMBER(7,0)
- INDATE — DATE