SL VILLAGE CLONE

Tables (28)

address (배송지)

  • 배송지ID (Key) — Long — Primary key — NOT NULL
  • 기본배송지여부 (default_address) — boolean
  • 배송지 이름 (Field)
  • 회원ID (member_id) — Long — Foreign key → member.회원ID — NOT NULL
  • 주문ID (purchase_id) — Long — Foreign key → purchase.주문ID — NOT NULL

aggregate (정산)

  • aggregate_id (Key) — Long — Primary key — NOT NULL
  • total_puchase_cost (연간누적금액) — Integer
  • 회원ID (member_id) — Long — Foreign key → member.회원ID — NOT NULL
  • 등급ID (membership_id) — Long — Foreign key → membership.등급ID — NOT NULL

aggregate_stock (재고정산)

  • Key — Primary key — NOT NULL
  • 재고 (stock) — Integer
  • 상품ID (product_id) — Long — Foreign key → product.상품ID — NOT NULL

beauty_info (뷰티정보)

  • 뷰티정보ID (beauty_info_id) — Long — Primary key — NOT NULL
  • 피부타입 (skin_type) — Enum
  • 피부톤 (skin_tone) — Enum
  • 두피타입 (scalp_tone) — Enum
  • 뷰티키워드 (beauty_keyword) — Enum
  • Key — Foreign key → size_beauty_member.Key — NOT NULL

brand (브랜드)

  • 브랜드ID (brand_id) — Long — Primary key — NOT NULL
  • 이름 (name) — Varchar
  • 쿠폰ID (coupon_id) — Long — Foreign key → coupon.쿠폰ID — NOT NULL

brand_wish (브랜드찜목록)

  • 브램드찜목록_ID (brand_wish_id) — Long — Primary key — NOT NULL
  • 회원ID (member_id) — Long — Foreign key → member.회원ID — NOT NULL
  • 브랜드ID (brand_id) — Long — Foreign key → brand.브랜드ID — NOT NULL

cart (장바구니)

  • 장바구니ID (cart_id) — Long — Primary key — NOT NULL
  • 회원ID (member_id) — Long — Foreign key → member.회원ID — NOT NULL

cart_product (장바구니상품)

  • 장바구니상품ID (cart_product_id) — Long — Primary key — NOT NULL
  • 장바구니ID (cart_id) — Long — Foreign key → cart.장바구니ID — NOT NULL
  • 상품ID (product_id2) — Long — Foreign key → product.상품ID — NOT NULL

category (카테고리)

  • 카테고리ID (category_id) — Integer — Primary key — NOT NULL
  • 부모카테고리ID (parent_id) — Integer
  • 카테고리이름 (name) — Varchar
  • 카테고리ID (category_id2) — Integer — Foreign key → category.카테고리ID — NOT NULL

coupon (쿠폰)

  • 쿠폰ID (coupon_id) — Long — Primary key — NOT NULL
  • 이름 (name) — Varchar
  • 만료기간 (experiod) — Datetime
  • 쿠폰번호 (code) — Varchar
  • 할인율 (discount_rate)
  • 할인대상 (target)
  • 회원ID (member_id) — Long — Foreign key → member.회원ID — NOT NULL
  • 상품ID (product_id) — Long — Foreign key → product.상품ID — NOT NULL

discount (할인)

  • 할인ID (discount_id) — Long — Primary key — NOT NULL
  • Field

member (회원)

  • 회원ID (member_id) — Long — Primary key — NOT NULL
  • 이메일 (email) — Varchar
  • 비밀번호 (password) — Varchar
  • 이름 (name) — Varchar
  • 휴대폰번호 (phone) — Varchar
  • 생년월일 (birthday) — Varchar
  • 배송지 (address) — Varchar
  • 권한 (permission) — Enum

member_point (적립금)

  • 적립금ID (point_id) — Long — Primary key — NOT NULL
  • 적립금 (point) — Integer
  • 소멸일 (expired_at) — Datetime
  • 회원ID (member_id) — Long — Foreign key → member.회원ID — NOT NULL

membership (멤버십)

  • 등급ID (membership_id) — Long — Primary key — NOT NULL
  • 등급 (membership) — Enum
  • 가입일 (sign_in_date) — Datetime

product (상품)

  • 상품ID (product_id) — Long — Primary key — NOT NULL
  • 제품명 (name) — Varchar
  • 가격 (price) — Integer
  • 최대주문수량 (puchase_limit) — Int
  • 상품정보ID (product_info_id) — Long — Foreign key → product_info.상품정보ID — NOT NULL

product_discount (상품_할인)

  • 상품할인ID (Key) — Long — Primary key — NOT NULL
  • 할인율 (Field)
  • 할인종료일 (expired_at) — LocalDatetime

product_info (상품정보)

  • 상품정보ID (product_info_id) — Long — Primary key — NOT NULL
  • 카테고리ID (category_id) — Integer — Foreign key → category.카테고리ID — NOT NULL
  • 브랜드ID (brand_id) — Long — Foreign key → brand.브랜드ID — NOT NULL
  • 색상 (color) — Enum
  • Field

product_wish (상품찜목록)

  • 찜목록ID (wish_id) — Long — Primary key — NOT NULL
  • 회원ID (member_id) — Long — Foreign key → member.회원ID — NOT NULL
  • 상품ID (product_id) — Long — Foreign key → product.상품ID — NOT NULL

puchase_review (주문_리뷰)

  • Key — Primary key — NOT NULL
  • 주문ID (purchase_id) — Long — Foreign key → purchase.주문ID — NOT NULL
  • 리뷰ID (review_id) — Long — Foreign key → review.리뷰ID — NOT NULL

purchase (주문)

  • 주문ID (purchase_id) — Long — Primary key — NOT NULL
  • 배송메시지 (address_message) — Varchar
  • 상품 금액 (price) — Integer
  • 회원ID (member_id) — Long — Foreign key → member.회원ID — NOT NULL
  • 주문날짜 (created_at) — Datetime
  • 개수 (amount) — Integer
  • Key — Foreign key → purchase_detail.Key — NOT NULL
  • 사이즈 (size) — Enum

purchase_detail (주문상세정보)

  • Key — Primary key — NOT NULL
  • 색상 (color) — Varchar
  • 용량 (volume) — Integer
  • 사이즈 (size) — Enum

question (문의)

  • 문의ID (qna_id) — Long — Primary key — NOT NULL
  • 문의내용 (question_content) — Varchar(500)
  • 문의자 (writer) — Varchar
  • 질문날짜 (created_at) — DateTime
  • 비밀글여부 (isPrivate) — Boolean
  • 답변여부 (isAnswered) — Boolean
  • 회원ID (member_id) — Long — Foreign key → member.회원ID — NOT NULL
  • 주문ID (purchase_id) — Long — Foreign key → purchase.주문ID — NOT NULL
  • 답변내용 (answer_content) — Varchar(500)

review (리뷰)

  • 리뷰ID (review_id) — Long — Primary key — NOT NULL
  • 리뷰내용 (content) — Varchar
  • 작성일자 (created_at) — Datetime
  • 리뷰이미지 (image) — Varchar
  • 작성자 (writer) — Varchar
  • 회원ID (member_id) — Long — Foreign key → member.회원ID — NOT NULL

review_like (리뷰_좋아요)

  • 리뷰좋아요ID (review_like_id) — Long — Primary key — NOT NULL
  • 좋아요 (like) — Integer
  • 리뷰ID (review_id) — Long — Foreign key → review.리뷰ID — NOT NULL

review_score (리뷰_평점)

  • (Key) — Long — Primary key — NOT NULL
  • 평점 (score) — Double
  • 리뷰ID (review_id) — Long — Foreign key → review.리뷰ID — NOT NULL

size (사이즈)

  • 사이즈ID (size_id) — Long — Primary key — NOT NULL
  • 키 (height) — Integer
  • 몸무게 (weight) — Integer
  • 상의사이즈 (top_size) — Enum
  • 하의사이즈 (pants_size) — Enum
  • Key — Foreign key → size_beauty_member.Key — NOT NULL

size_beauty_member (Untitled2)

  • Key — Primary key — NOT NULL
  • 회원ID (member_id) — Long — Foreign key → member.회원ID — NOT NULL

stock_aggregate (Untitled)