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