Shopping mall

Tables (15)

Authority (권한)

  • Id (authorityId) — varchar2(20) not null — Primary key — NOT NULL
  • Name (authorityName) — varchar2(20) not null — Primary key — NOT NULL

Board (게시판)

  • No (boardNo) — number(5) not null — Primary key — 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 — Primary key — NOT NULL
  • No (boardNo) — number(5) not null — Foreign key → 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 — Primary key — NOT NULL
  • Id (userId) — varchar2(20) not null — Foreign key → User.Id — NOT NULL
  • Number (goodsNum) — number(5) not null — Foreign key → Goods.Number — NOT NULL
  • Stock (cartStock) — number(5) not null
  • RegDate (cartRegDate) — date default sysdate

Event (이벤트)

  • No (eventNo) — number(5) not null — Primary key — 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 — Primary key — NOT NULL
  • Code (categoryCode) — varchar2(30) not null — Foreign key → GoodsDivision.Code — NOT NULL
  • Code (divisionCode) — varchar2(30) not null — Foreign key → 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 — Primary key — NOT NULL
  • Name (categoryName) — varchar2(30) not null

GoodsDivision (카테고리(중분류))

  • Code (divisionCode) — varchar2(30) not null — Primary key — NOT NULL
  • Code (categoryCode) — varchar2(30) not null — Foreign key → GoodsCategory.Code — NOT NULL
  • Name (divisionName) — varchar2(30) not null

GoodsReply (상품 후기)

  • Number (goodsReplyNum) — number(5) not null — Primary key — NOT NULL
  • Number (goodsNum) — number(5) not null — Foreign key → 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 — Primary key — 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 — Primary key — NOT NULL
  • Id (orderId) — varchar2(20) not null — Foreign key → Orders.Id — NOT NULL
  • Number (goodsNum) — number(5) not null
  • Stock (cartStock) — number(5) not null

Orders (주문)

  • Id (orderId) — varchar2(20) not null — Primary key — NOT NULL
  • Id (userId) — varchar2(20) not null — Foreign key → 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 — Primary key — 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 — Primary key — NOT NULL
  • No (qnaNo) — number(5) not null — Foreign key → 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 — Primary key — 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