english of Shopping mall and menu

테이블 (16)

Authority

  • Id (authorityId) — varchar2(20) not null — 기본 키 — NOT NULL
  • Name (authorityName) — varchar2(20) not null — 기본 키 — NOT NULL

BarMenu (CopyOf장바구니)

  • 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

  • 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

  • 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

  • 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

  • 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 (카테고리(대분류))

  • Code (categoryCode) — varchar2(30) not null — 기본 키 — NOT NULL
  • Name (categoryName) — varchar2(30) not null

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 (상품 후기)

  • 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 (공지사항)

  • 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 (주문 상세)

  • 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

  • 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

  • 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

  • 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