work out

Tables (10)

ADDRESS (배송지)

  • 배송지Id (address_id) — bigint — Primary key — NOT NULL — PK
  • 회원고유id (user_id) — bigint — Foreign key → User.회원고유id — NOT NULL — PK
  • 배송지명 (name) — varchar — NOT NULL
  • 수취인명 (recipient_name) — varchar — NOT NULL
  • 수취인번호 (recipient_ number) — varchar — NOT NULL
  • 우편번호 (zip_code) — varchar — NOT NULL
  • 주소 (address) — varchar — NOT NULL
  • 주소상세 (detail) — varchar — NOT NULL
  • 기존주소여부 (defalt_address) — boolean — NOT NULL

CART (장바구니)

  • 장바구니Id (cart_id) — bigint — Primary key — NOT NULL — PK
  • 상품디테일Id (product_deatail) — bigint — Foreign key → PRODUCT_DETAIL.상품디테일Id — NOT NULL — PK
  • 회원고유id (user_id) — bigint — Foreign key → User.회원고유id — NOT NULL — PK
  • 수량 (count) — int(11) — NOT NULL
  • 총가격 (total_price) — int(211) — NOT NULL

Like (좋아요)

  • 종아요Id (like_id) — bigint — Primary key — NOT NULL — PK
  • 회원고유id (user_id) — bigint — Foreign key → User.회원고유id — NOT NULL — PK
  • 상품id (product_id) — bigint — Foreign key → PRODUCT.상품id — NOT NULL — PK

ODERS (주문내역)

  • 주문내역Id (orders_id) — bigint — Primary key — NOT NULL — PK
  • 회원고유id (user_id) — bigint — Foreign key → User.회원고유id — NOT NULL — PK
  • 총 주문 금액 (total_price) — int(1) — NOT NULL
  • 배송지 (address) — varchar(50) — NOT NULL
  • 주문일자 (create_at) — int(11) — NOT NULL
  • 송장번호 (invoice) — int(11) — NOT NULL
  • 배송상태 (delivery) — enum — NOT NULL
  • 주문상세 (order_status) — enum — NOT NULL

ORDER_DETAIL (주문상세)

  • 주문상세Id (order_detail_id) — bigint — Primary key — NOT NULL
  • 회원고유id (user_id) — bigint — Foreign key → User.회원고유id — NOT NULL — PK
  • 주문내역Id (orders_id) — bigint — Foreign key → ODERS.주문내역Id — NOT NULL — PK
  • 상품id (product_id) — bigint — Foreign key → PRODUCT.상품id — NOT NULL — PK
  • 상품디테일Id (product_deatail) — bigint — Foreign key → PRODUCT_DETAIL.상품디테일Id — NOT NULL — PK
  • 주문수량 (count) — int(11) — NOT NULL
  • 상품명 (product) — varchar(50) — NOT NULL
  • 가격 (price) — int(11) — NOT NULL

PRODUCT (상품)

  • 상품id (product_id) — bigint — Primary key — NOT NULL — PK
  • 상품명 (product) — varchar(50) — NOT NULL
  • 가격 (price) — int(11) — NOT NULL
  • 설명 (explanation) — varchar — NOT NULL
  • 분류 (category) — enum — NOT NULL
  • 종아요 (like_count) — int(11)
  • 리뷰수 (review_count) — int(11) — NOT NULL
  • 상품상태 (product_status) — NOT NULL
  • 생성일자 (create_at) — datetime — NOT NULL — TimeStamp
  • 수정일자 (modified_at) — datetime — NOT NULL — TimeStamp
  • 결제고유번호 (tid) — varchar — NOT NULL
  • 대표이미지 (FieId) — NOT NULL

PRODUCT_DETAIL (상품디테일)

  • 상품디테일Id (product_deatail) — bigint — Primary key — NOT NULL — PK
  • 상품id (product_id) — bigint — Foreign key → PRODUCT.상품id — NOT NULL — PK
  • 사이즈 (size) — enum — NOT NULL
  • 색상 (color) — varchar(50) — NOT NULL
  • 재고 (quantity) — int(11) — NOT NULL
  • 상품상태 (status) — enum — NOT NULL

REVIEW (리뷰)

  • 리뷰Id (review_id) — bigint — Primary key — NOT NULL — PK
  • 회원고유id (user_id) — bigint — Foreign key → User.회원고유id — NOT NULL — PK
  • 상품id (product_id) — bigint — Foreign key → PRODUCT.상품id — NOT NULL — PK
  • 내용 (review) — varchar — NOT NULL
  • 별점 (rating) — int(11) — NOT NULL
  • 생성일자 (create_at) — datetime — NOT NULL — TIMESTAMP
  • 수정일자 (modified_at) — datetime — NOT NULL — TIMESTAMP

REVIEW_IMAGE (리뷰이미지)

  • 리뷰이미지Id (review_image) — bigint — Primary key — PK
  • 리뷰Id (review_id) — bigint — Foreign key → REVIEW.리뷰Id — NOT NULL — PK
  • 리뷰이미지링크 (review_image_url) — varchar

User (회원정보)

  • 회원고유id (user_id) — bigint — Primary key — NOT NULL — PK
  • 아이디 (userName) — varchar(50) — NOT NULL — UNIQUE
  • 소셜아이디 (socal_id) — varchar(50) — NOT NULL — UNIQUE
  • 비밀번호 (password) — varchar — NOT NULL
  • 이름 (name) — varchar(50) — NOT NULL
  • 이메일 (email) — email — NOT NULL — UNIQUE
  • 전화번호 (phone) — varchar(50) — NOT NULL — UNIQUE
  • 권한 (userRole) — varchar(50) — NOT NULL
  • 상태 (status) — enum — NOT NULL
  • 생성일 (create_at) — datetime — NOT NULL — TimeStamp상속
  • 수정일 (modified-at) — datetime — NOT NULL — TimeStamp상속