xxx
Tables (16)
Authority
- authorityId — varchar2(20) — NOT NULL
- authorityName — varchar2(20) — NOT NULL
BarMenu
- userId — varchar2(20) — NOT NULL
- menuId — number(5) — NOT NULL
- menuName — varchar2(30)
- menuDesc — varchar2(200)
- webPageLink — varchar2(200)
Board
- boardNo — number(5) — NOT NULL
- boardTitle — varchar2(50) — NOT NULL
- boardContent — varchar2(1000) — NOT NULL
- boardWriter — varchar2(30) — NOT NULL
- boardFile — varchar2(200)
- boardRegDate — date
- boardReadCnt — number(5)
- boardReportCnt — number(5)
- boardReplyCnt — number(5)
- boardDel — number(1)
BoardReply
- boardReplyNo — number(5) — NOT NULL
- boardNo — number(5) — NOT NULL
- boardReplyContent — varchar2(1000) — NOT NULL
- boardReplyWriter — varchar2(30) — NOT NULL
- boardReplyRegDate — date
- boardReplyReportCnt — number(5)
- boardReplyDel — number(1)
Cart
- cartNum — number(5) — NOT NULL
- userId — varchar2(20) — NOT NULL
- goodsNum — number(5) — NOT NULL
- cartStock — number(5) — NOT NULL
- cartRegDate — date
Event
- eventNo — number(5) — NOT NULL
- eventTitle — varchar2(50) — NOT NULL
- eventContent — varchar2(1000) — NOT NULL
- eventWriter — varchar2(30) — NOT NULL
- eventFile — varchar2(200)
- eventStartDate — date — NOT NULL
- eventEndDate — date — NOT NULL
- eventRegDate — date
- eventReadCnt — number(5)
- eventDel — number(1)
Goods
- goodsNum — number(5) — NOT NULL
- categoryCode — varchar2(30) — NOT NULL
- divisionCode — varchar2(30) — NOT NULL
- goodsName — varchar2(50) — NOT NULL
- goodsImage — varchar2(200)
- goodsContent — varchar2(1000) — NOT NULL
- goodsStock — number(5) — NOT NULL
- goodsPrice — number(10) — NOT NULL
- goodsRegDate — date
GoodsCategory
- categoryCode — varchar2(30) — NOT NULL
- categoryName — varchar2(30) — NOT NULL
GoodsDivision
- divisionCode — varchar2(30) — NOT NULL
- categoryCode — varchar2(30) — NOT NULL
- divisionName — varchar2(30) — NOT NULL
GoodsReply
- goodsReplyNum — number(5) — NOT NULL
- goodsNum — number(5) — NOT NULL
- goodsReplyContent — varchar2(1000) — NOT NULL
- goodsReplyWriter — varchar2(30) — NOT NULL
- goodsReplyRegDate — date
- goodsReplyDel — number(1)
Notice
- noticeNo — number(5) — NOT NULL
- noticeTitle — varchar2(50) — NOT NULL
- noticeContent — varchar2(1000) — NOT NULL
- noticeWriter — varchar2(30) — NOT NULL
- noticeFile — varchar2(200)
- noticeRegDate — date
- noticeReadCnt — number(5)
- noticeDel — number(1)
OrderDetails
- orderDetailNum — number(5) — NOT NULL
- orderId — varchar2(20) — NOT NULL
- goodsNum — number(5) — NOT NULL
- cartStock — number(5) — NOT NULL
Orders
- orderId — varchar2(20) — NOT NULL
- userId — varchar2(20) — NOT NULL
- orderRec — varchar2(50) — NOT NULL
- orderAddr1 — varchar2(20) — NOT NULL
- orderAddr2 — varchar2(50) — NOT NULL
- orderAddr3 — varchar2(50) — NOT NULL
- orderTel — varchar2(20) — NOT NULL
- orderAccount — number(10) — NOT NULL
- orderRegDate — date
- orderState — varchar2(20)
Qna
- qnaNo — number(5) — NOT NULL
- qnaTitle — varchar2(50) — NOT NULL
- qnaContent — varchar2(1000) — NOT NULL
- qnaWriter — varchar2(30) — NOT NULL
- qnaFile — varchar2(200)
- qnaRegDate — date
- qnaPublic — number(1)
- qnaDel — number(1)
QnaReply
- qnaReplyNo — number(5) — NOT NULL
- qnaNo — number(5) — NOT NULL
- qnaReplyContent — varchar2(1000) — NOT NULL
- qnaReplyWriter — varchar2(30) — NOT NULL
- qnaReplyRegDate — date
- qnaReplyDel — number(1)
User
- userId — varchar2(20) — NOT NULL
- userEmail — varchar2(50) — NOT NULL
- userPassword — varchar2(100) — NOT NULL
- userName — varchar2(30) — NOT NULL
- userNickname — varchar2(30) — NOT NULL
- userProfile — varchar2(200) — NOT NULL
- userAddr1 — varchar2(20) — NOT NULL
- userAddr2 — varchar2(50) — NOT NULL
- userAddr3 — varchar2(50) — NOT NULL
- userTel — varchar2(20) — NOT NULL
- userRegDate — date
- userGrade — number(1)
- userPurchaseCnt — number(5)
- userPurchasePrice — number(10)
- userLoginFailureCnt — number(1)
- userBlock — number(1)
- userBlacklist — number(1)
- userBlacklistCnt — number(1)
- userDel — number(1)