English Shopping mall and menu
테이블 (16)
Authority / 권한 (Authority)
- Id (authorityId) — varchar2(20) not null — 기본 키 — NOT NULL
- Name (authorityName) — varchar2(20) not null — 기본 키 — NOT NULL
BarMenu / 메뉴 정의 (BarMenu)
- Id (userId) — varchar2(20) not null — 외래 키 → User / 고객.Id — NOT NULL
- MenuID (menuId) — number(5) not null
- MenuName (menuName) — varchar2(30) not nul
- MenuDesc (menuDesc) — varchar2(200)
- WebPageLink (webPageLink) — varchar2(200)
Board / 게시판 (Board)
- No (boardNo) — number(5) not null — 기본 키 — NOT NULL
- Title (boardTitle) — varchar2(50) not null
- Content (boardContent) — varchar2(1000) not null
- Writer (boardWriter) — varchar2(30) not null
- File (boardFile) — varchar2(200)
- RegDate (boardRegDate) — date default sysdate
- ReadCnt (boardReadCnt) — number(5) default 0
- ReportCnt (boardReportCnt) — number(5) default 0
- ReplyCnt (boardReplyCnt) — number(5) default 0
- Delete (boardDel) — number(1) default 1
BoardReply / 게시판 댓글 (BoardReply)
- No (boardReplyNo) — number(5) not null — 기본 키 — NOT NULL
- No (boardNo) — number(5) not null — 외래 키 → Board / 게시판.No — NOT NULL
- Content (boardReplyContent) — varchar2(1000) not null
- Writer (boardReplyWriter) — varchar2(30) not null
- RegDate (boardReplyRegDate) — date default sysdate
- ReportCnt (boardReplyReportCnt) — number(5) default 0
- Delete (boardReplyDel) — number(1) default 1
Cart / 장바구니 (Cart)
- Number (cartNum) — number(5) not null — 기본 키 — NOT NULL
- Id (userId) — varchar2(20) not null — 외래 키 → User / 고객.Id — NOT NULL
- Number (goodsNum) — number(5) not null — 외래 키 → Goods / 상품.Number — NOT NULL
- Stock (cartStock) — number(5) not null
- RegDate (cartRegDate) — date default sysdate
Event / 이벤트 (Event)
- No (eventNo) — number(5) not null — 기본 키 — NOT NULL
- Title (eventTitle) — varchar2(50) not null
- Content (eventContent) — varchar2(1000) not null
- Writer (eventWriter) — varchar2(30) not null
- File (eventFile) — varchar2(200)
- StartDate (eventStartDate) — date not null
- EndDate (eventEndDate) — date not null
- RegDate (eventRegDate) — date default sysdate
- ReadCnt (eventReadCnt) — number(5) default 0
- Delete (eventDel) — number(1) default 1
Goods / 상품 (Goods)
- Number (goodsNum) — number(5) not null — 기본 키 — NOT NULL
- Code (categoryCode) — varchar2(30) not null — 외래 키 → GoodsDivision / 카테고리(중분류).Code — NOT NULL
- Code (divisionCode) — varchar2(30) not null — 외래 키 → GoodsDivision / 카테고리(중분류).Code — NOT NULL
- Name (goodsName) — varchar2(50) not null
- Image (goodsImage) — varchar2(200)
- Content (goodsContent) — varchar2(1000) not null
- Stock (goodsStock) — number(5) not null
- Price (goodsPrice) — number(10) not null
- RegDate (goodsRegDate) — date default sysdate
GoodsCategory / 카테고리(대분류) (GoodsCategory)
- Code (categoryCode) — varchar2(30) not null — 기본 키 — NOT NULL
- Name (categoryName) — varchar2(30) not null
GoodsDivision / 카테고리(중분류) (GoodsDivision)
- Code (divisionCode) — varchar2(30) not null — 기본 키 — NOT NULL
- Code (categoryCode) — varchar2(30) not null — 외래 키 → GoodsCategory / 카테고리(대분류).Code — NOT NULL
- Name (divisionName) — varchar2(30) not null
GoodsReply / 상품 후기 (GoodsReply)
- Number (goodsReplyNum) — number(5) not null — 기본 키 — NOT NULL
- Number (goodsNum) — number(5) not null — 외래 키 → Goods / 상품.Number — NOT NULL
- Content (goodsReplyContent) — varchar2(1000) not null
- Writer (goodsReplyWriter) — varchar2(30) not null
- RegDate (goodsReplyRegDate) — date default sysdate
- Delete (goodsReplyDel) — number(1) default 1
Notice / 공지사항 (Notice)
- No (noticeNo) — number(5) not null — 기본 키 — NOT NULL
- Title (noticeTitle) — varchar2(50) not null
- Content (noticeContent) — varchar2(1000) not null
- Writer (noticeWriter) — varchar2(30) not null
- File (noticeFile) — varchar2(200)
- RegDate (noticeRegDate) — date default sysdate
- ReadCnt (noticeReadCnt) — number(5) default 0
- Delete (noticeDel) — number(1) default 1
OrderDetails / 주문 상세 (OrderDetails)
- Number (orderDetailNum) — number(5) not null — 기본 키 — NOT NULL
- Id (orderId) — varchar2(20) not null — 외래 키 → Orders / 주문.Id — NOT NULL
- Number (goodsNum) — number(5) not null
- Stock (cartStock) — number(5) not null
Orders / 주문 (Orders)
- Id (orderId) — varchar2(20) not null — 기본 키 — NOT NULL
- Id (userId) — varchar2(20) not null — 외래 키 → User / 고객.Id — NOT NULL
- Name (orderRec) — varchar2(50) not null
- Address (orderAddr1) — varchar2(20) not null
- Address (orderAddr2) — varchar2(50) not null
- Address (orderAddr3) — varchar2(50) not null
- Tel (orderTel) — varchar2(20) not null
- Account (orderAccount) — number(10) not null
- RegDate (orderRegDate) — date default sysdate
- State (orderState) — varchar2(20) default '배송 준비'
Qna / 문의사항 (Qna)
- No (qnaNo) — number(5) not null — 기본 키 — NOT NULL
- Title (qnaTitle) — varchar2(50) not null
- Content (qnaContent) — varchar2(1000) not null
- Writer (qnaWriter) — varchar2(30) not null
- File (qnaFile) — varchar2(200)
- RegDate (qnaRegDate) — date default sysdate
- Public (qnaPublic) — number(1) default 1
- Delete (qnaDel) — number(1) default 1
QnaReply / 문의사항 답변 (QnaReply)
- No (qnaReplyNo) — number(5) not null — 기본 키 — NOT NULL
- No (qnaNo) — number(5) not null — 외래 키 → Qna / 문의사항.No — NOT NULL
- Content (qnaReplyContent) — varchar2(1000) not null
- Writer (qnaReplyWriter) — varchar2(30) not null
- RegDate (qnaReplyRegDate) — date default sysdate
- Delete (qnaReplyDel) — number(1) default 1
User / 고객 (User)
- Id (userId) — varchar2(20) not null — 기본 키 — NOT NULL
- Email (userEmail) — varchar2(50) not null
- Password (userPassword) — varchar2(100) not null
- Name (userName) — varchar2(30) not null
- Nickname (userNickname) — varchar2(30) not null
- Profile (userProfile) — varchar2(200) — NOT NULL
- Address (userAddr1) — varchar2(20) not null
- Address (userAddr2) — varchar2(50) not null
- Address (userAddr3) — varchar2(50) not null
- Tel (userTel) — varchar2(20) not null
- RegDate (userRegDate) — date default sysdate
- Grade (userGrade) — number(1) default 1
- PurchaseCnt (userPurchaseCnt) — number(5) default 0
- PurchasePrice (userPurchasePrice) — number(10) default 0
- LoginFailureCnt (userLoginFailureCnt) — number(1) default 0
- Block (userBlock) — number(1) default 1
- Blacklist (userBlacklist) — number(1) default 1
- BlacklistCnt (userBlacklistCnt) — number(1) default 0
- Delete (userDel) — number(1) default 1