1
Tables (16)
Admin
- adminID — varchar(10) — Primary key — NOT NULL
- adminPW — varchar(100) — NOT NULL
- adminName — varchar(100)
- adminDate — datetime
Banking
- bnkID — int — Primary key — NOT NULL — 0: 없음 1: 신한 2: 국민 3: 하나
- bnkName — varchar(100) — NOT NULL
- bnkNum — varchar(100) — NOT NULL
Cart
- cartID — int — Primary key — NOT NULL
- memID — varchar(100) — NOT NULL
Cart_item
- cartItemID — int — Primary key — NOT NULL
- cartID — int — Foreign key → Cart.cartID — NOT NULL
- pID — int — Foreign key → Product.pID — NOT NULL
- cartItemQty — int — NOT NULL
Category_main
- cateMainID — int — Primary key — NOT NULL
- cateMainName — varchar(100) — NOT NULL
Category_sub
- cateSubID — int — Primary key — NOT NULL
- cateMainID — int — Foreign key → Category_main.cateMainID — NOT NULL
- cateSubName — varchar(100) — NOT NULL
Faq
- faqID — int — Primary key — NOT NULL
- faqCate — int
- faqTitle — varchar(100)
- faqContent — varchar(5000)
- faqDate1 (faqDate) — datetime
Member
- memID — varchar(100) — Primary key — NOT NULL
- memType — int — NOT NULL — 1: 개인 2: 사업자
- memPW — varchar(20) — NOT NULL
- memName — varchar(100) — NOT NULL
- memPhone — varchar(20) — NOT NULL
- memEmail — varchar(100) — NOT NULL
- memRecID — varchar(100)
- memAgr1_1 — int — NOT NULL
- memAgr1_2 — int — NOT NULL
- memAgr1_3 — int — NOT NULL
- memAgr2_1 — int
- memAgr2_2 — int
- memAgr2_3 — int
Member_company
- compNum — varchar(10) — Primary key — NOT NULL
- memID — varchar(100) — Foreign key → Member.memID — NOT NULL
- compName — varchar(100) — NOT NULL
- compCondition — varchar(100) — NOT NULL
- compType — varchar(100) — NOT NULL
- compAddr1 — varchar(500) — NOT NULL
- compAddr2 — varchar(500) — NOT NULL
Notice
- noticeID — int — Primary key — NOT NULL
- noticeTitle — varchar(100) — NOT NULL
- noticeContent — varchar(5000)
- noticeDate — datetime
- noticeHit — int
- noticeFile — varchar(4000)
Order
- orderID — int — Primary key — NOT NULL
- memID — varchar(100) — Foreign key → Member.memID — NOT NULL
- cartID — int — Foreign key → Cart.cartID — NOT NULL
- orderDate — datetime
- shippingID — int — Foreign key → Shipping.shippingID — NOT NULL
- orderPrice — int
- orderPayment — int — 1: 현금 입금 2: 카드 3: 카카오페이
- orderInvoice — int
- orderDelivery — int — 0: 무료 1: 일반 2: 특수
- orderCardType — varchar(20)
- orderCardNo — varchar(20)
- bnkID — int — Foreign key → Banking.bnkID — NOT NULL — 0: 없음 1: 신한 2: 국민 3: 하나
Product
- pID — int — Primary key — NOT NULL
- cateSubID — int — Foreign key → Category_sub.cateSubID — NOT NULL
- pName — varchar(100) — NOT NULL
- pPrice — int — NOT NULL
- pDiscount — int
- pStock — int — NOT NULL
- pIMG — varchar(4000)
- pDetail — varchar(4000)
- pDate — datetime
- pDelivery — int — 1: 새벽배송 2: 일반택배 3: 둘 다
Product_detail
- pdID — int — Primary key — NOT NULL
- pID — int — Foreign key → Product.pID — NOT NULL
- pdName — varchar(100)
- pdType — varchar(100)
- pdManufacturer — varchar(1000)
- pdExpDate — varchar(100)
- pdWeight — varchar(100)
- pdIngredient — varchar(1000)
- pdStore — varchar(100)
- pdWarning — varchar(1000)
- pdPhone — varchar(20)
- pdNutrition — varchar(1000)
- pdGenetic — varchar(100)
- pdImport — varchar(100)
Qna
- qnaID — int — Primary key — NOT NULL
- qnaCate — int — 1: 주문/취소, 2: 배송, 3: 쿠폰/기타, 4: 회원정보, 5: 제품
- memID — varchar(100) — Foreign key → Member.memID — NOT NULL
- qnaTitle — varchar(100)
- qnaContent — varchar(4000)
- qnaFile — varchar(4000)
- qnaDate — datetime
- qnaAnswer — varchar(4000)
- qnaStatus — int — 0: 접수, 1: 답변중, 2: 답변완료
Review
- reviewID — int — Primary key — NOT NULL
- orderID — int — Foreign key → Order.orderID — NOT NULL
- pID — int — Foreign key → Product.pID — NOT NULL
- memID — varchar(100) — Foreign key → Member.memID — NOT NULL
- reviewRating — int
- reviewDate — datetime
- reviewContent — varchar(1000)
- reviewFile1 — varchar(4000)
- reviewFile2 — varchar(4000)
- reviewFile3 — varchar(4000)
- reviewHelpful — int
Shipping
- shippingID — int — Primary key — NOT NULL
- memID — varchar(100) — Foreign key → Member.memID — NOT NULL
- shippingAddr1 — varchar(500) — NOT NULL
- shippingAddr2 — varchar(500) — NOT NULL
- shippingName — varchar(100) — NOT NULL
- shippingPhone — varchar(20) — NOT NULL