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