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상속