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