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