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