Hobbyist

Tables (9)

Board (게시판)

  • No (num) — int(5) not null — Primary key — NOT NULL
  • Writer (name) — varchar(20) not null
  • Id (id) — varchar(20) not null
  • Pass (pass) — varchar(20) not null
  • Mail (mail) — varchar(30)
  • Title (title) — varchar(50)
  • Content (cont) — text
  • IpAddress (bip) — varchar(20)
  • Date (bdate) — varchar(20)
  • ReadCNT (readcnt) — number(5) default 0
  • Gnum (gnum) — int(5)
  • Onum (onum) — int(3)
  • Nested (nested) — int(3)
  • Category (hobby) — int not null

Cart (장바구니)

  • Number (cartNum) — int(11) not null — Primary key — NOT NULL
  • Id (userId) — varchar(20) not null — Foreign key → User.Id — NOT NULL
  • Number (goodsNum) — varchar(30) not null — Foreign key → Goods.Number — NOT NULL
  • Stock (cartStock) — int(11) not null
  • RegDate (cartRegDate) — timestamp default now()

Goods (상품)

  • Number (goodsNum) — int(11) not null — Primary key — NOT NULL
  • Name (goodsName) — varchar(50) not null
  • Content (goodsContent) — varchar(1000) not null
  • Stock (goodsStock) — int(11) not null
  • Price (goodsPrice) — int(11) not null
  • RegDate (goodsRegDate) — date default sysdate

OrderDetails (주문 상세)

  • Number (orderDetailNum) — int(11) not null — Primary key — NOT NULL
  • Number (goodsNum2) — int(11) not null — Foreign key → Goods.Number — NOT NULL
  • Id (orderId) — varchar(20) not null — Foreign key → Orders.Id — NOT NULL
  • Number (goodsNum) — int(11) not null
  • Stock (cartStock) — int(11) not null

Orders (주문)

  • Id (orderId) — varchar(20) not null — Primary key — NOT NULL
  • Id (userId) — varchar(20) not null — Foreign key → User.Id — NOT NULL
  • Name (orderRec) — varchar(50) not null
  • Address (orderAddr1) — varchar(20) not null
  • Address (orderAddr2) — varchar(50) not null
  • Address (orderAddr3) — varchar(50) not null
  • Tel (orderTel) — varchar(20) not null
  • Account (orderAccount) — int(11) not null
  • RegDate (orderRegDate) — date default sysdate
  • State (orderState) — varchar(20) default '배송 준비'

User (고객)

  • Id (id) — varchar(20) not null — Primary key — NOT NULL
  • Password (password) — varchar(20) not null
  • Name (name) — varchar(20) not null
  • Email (email) — varchar(50) not null
  • Age (age) — int(3) not null
  • Nickname (nickname) — varchar(30) not null
  • Address (addr1) — varchar(20) not null
  • Address (addr2) — varchar(50) not null
  • Tel (userTel) — varchar(20) not null
  • Birth (birth) — date not null
  • Grade (grade) — varchar(20)
  • Gender (gender) — varchar(10) not null
  • RegDate (regdate) — date not null
  • PurchaseCnt (cnt) — int(5)
  • PurchasePrice (price) — int

questions (문의사항)

  • No (qnaNo) — int(11) not null — Primary key — NOT NULL
  • Number (goodsNum) — int(11) not null — Foreign key → Goods.Number — NOT NULL
  • Title (qnaTitle) — varchar(50) not null
  • Content (qnaContent) — varchar(1000) not null
  • Writer (qnaWriter) — varchar(30) not null
  • RegDate (qnaRegDate) — date default sysdate
  • Public (qnaPublic) — int(11) default 1
  • Delete (qnaDel) — int(11) default 1

reply (문의사항 답변)

  • No (qnaNo) — int(11) not null — Foreign key → questions.No — NOT NULL
  • No (qnaReplyNo) — int(11) not null
  • Number (goodsNum) — int(11) not null
  • Content (qnaReplyContent) — varchar(1000) not null
  • Writer (qnaReplyWriter) — varchar(30) not null
  • RegDate (qnaReplyRegDate) — date
  • Delete (qnaReplyDel) — int(11) default 1

review (리뷰)

  • Number (goodsReplyNum) — int(11) not null — Primary key — NOT NULL
  • Number (goodsNum) — int(11) not null — Foreign key → Goods.Number — NOT NULL
  • Number (star) — int
  • Content (goodsReplyContent) — varchar(1000) not null
  • Writer (goodsReplyWriter) — varchar(30) not null
  • RegDate (goodsReplyRegDate) — date default sysdate
  • Delete (goodsReplyDel) — int(11) default 1