Vuerly

Tables (14)

Announcement (공지사항)

  • num (annou_num) — NOT NULL — Primary key — NOT NULL
  • title (제목) — NOT NULL
  • writer (작성자) — NOT NULL
  • content (내용) — NOT NULL
  • created_at (작성일) — NOT NULL

Brand (브랜드)

  • num (brand_num) — NOT NULL — Primary key — NOT NULL
  • brand (브랜드명) — NOT NULL
  • brand_logo (브랜드로고) — NOT NULL
  • brand_desc (브랜드설명) — NOT NULL

Cart (장바구니)

  • idx (cart인덱스) — NOT NULL — Primary key — NOT NULL
  • num (cart번호) — NOT NULL
  • count (상품수량) — NOT NULL
  • member_num — NOT NULL — Foreign key → Member.num — NOT NULL
  • product_num — NOT NULL — Foreign key → Product.num — NOT NULL

Faq (자주묻는질문)

  • num (faq_num) — NOT NULL — Primary key — NOT NULL
  • title (제목) — NOT NULL
  • answer (답변) — NOT NULL
  • num (faqType_num) — NOT NULL — Foreign key → FaqType.num — NOT NULL

FaqType (질문유형)

  • num (faqType_num) — NOT NULL — Primary key — NOT NULL
  • category (질문유형) — NOT NULL

Member (회원)

  • num (member_num) — NOT NULL — Primary key — NOT NULL
  • Id (아이디) — NOT NULL
  • password (비밀번호) — NOT NULL
  • name (이름) — NOT NULL
  • email (이메일) — NOT NULL
  • phone_num (핸드폰번호) — NOT NULL
  • birth (생일)
  • sex (성별) — NOT NULL
  • addr (주소) — NOT NULL
  • point (포인트) — NOT NULL
  • created_at (등록일) — NOT NULL
  • updated_at (수정일) — NOT NULL
  • secret_key (시크릿키) — NOT NULL

Order (주문)

  • num (order_num) — NOT NULL — Primary key — NOT NULL
  • status (주문상태(주문,취소)) — NOT NULL
  • point (포인트) — NOT NULL
  • addr (배송지 주소) — NOT NULL
  • shopping_option (옵션)
  • created_at (주문날짜) — NOT NULL
  • member_num — NOT NULL — Foreign key → Member.num — NOT NULL

Order_Product (주문상품 중간테이블)

  • num (order_product_num) — NOT NULL — Primary key — NOT NULL
  • product_num — NOT NULL — Foreign key → Product.num — NOT NULL
  • order_num — NOT NULL — Foreign key → Order.num — NOT NULL
  • review_status (리뷰 작성 상태) — NOT NULL

Payment (결제)

  • num (payment_num) — NOT NULL — Primary key — NOT NULL
  • total_price (총 가격) — NOT NULL
  • discount_fee (할인가격) — NOT NULL
  • delivery_fee (배송비) — NOT NULL
  • final_price (최종가격) — NOT NULL
  • used_point (사용포인트) — NOT NULL
  • created_at (결제날짜) — NOT NULL
  • order_num — NOT NULL — Foreign key → Order.num — NOT NULL
  • type_num — NOT NULL — Foreign key → PaymentType.num — NOT NULL

PaymentType (결제타입)

  • num (type_num) — NOT NULL — Primary key — NOT NULL
  • type (결제타입) — NOT NULL

Product (상품)

  • num (product_num) — NOT NULL — Primary key — NOT NULL
  • name (상품명) — NOT NULL
  • subtitle (소제목) — NOT NULL
  • price (상품가격) — NOT NULL
  • stock (재고) — NOT NULL
  • desc_image (설명 이미지) — NOT NULL
  • detail_image (상세설명이미지) — NOT NULL
  • sale (할인금액) — NOT NULL
  • thumbnail (썸네일이미지) — NOT NULL
  • readcount (조회수) — NOT NULL
  • shipping_option (배송유형) — NOT NULL
  • created_at (등록일) — NOT NULL
  • updated_at (수정일) — NOT NULL
  • brand_num — NOT NULL — Foreign key → Brand.num — NOT NULL
  • category (상품카테고리) — NOT NULL

Qna (문의)

  • num (qna_num) — NOT NULL — Primary key — NOT NULL
  • title (문의제목) — NOT NULL
  • content (문의내용) — NOT NULL
  • created_at (등록일) — NOT NULL
  • member_num — NOT NULL — Foreign key → Member.num — NOT NULL
  • qnaType_num — NOT NULL — Foreign key → QnaType.num — NOT NULL

QnaType (문의유형)

  • num (qnaType_num) — NOT NULL — Primary key — NOT NULL
  • type (문의유형) — NOT NULL

Review (리뷰)

  • num (review_num) — NOT NULL — Primary key — NOT NULL
  • content (후기 내용) — NOT NULL
  • photo (후기사진)
  • created_at (등록일) — NOT NULL
  • product_num — NOT NULL — Foreign key → Product.num — NOT NULL
  • member_num — NOT NULL — Foreign key → Member.num — NOT NULL