TrenD
Tables (10)
Address (주소)
- 주소ID (address_id) — bigint — Primary key — NOT NULL
- 유저ID (user_id) — bigint — Foreign key → User.유저ID — NOT NULL
- 주소종류 (address_type) — varchar — NOT NULL
- 기본주소 (address) — json — NOT NULL
- 상세주소 (address_detail) — varchar — NOT NULL
Auth (인증)
- 인증ID (auth_id) — bigint — Primary key — NOT NULL
- 유저ID (user_id) — bigint — Foreign key → User.유저ID — NOT NULL
- 제공자 (provider) — enum
- 제공자ID (provider_id) — varchar
- 비밀번호 (password) — varchar
- 생성시간 (created_at) — datetime — NOT NULL
- 수정시간 (modified_at) — datetime — NOT NULL
Cart (장바구니)
- 장바구니ID (cart_id) — bigint — Primary key — NOT NULL
- 유저ID (user_id) — bigint — Foreign key → User.유저ID — NOT NULL
- 옵션ID (option_id) — bigint — Foreign key → ProductOption.옵션ID — NOT NULL
- 수량 (quantity) — int — NOT NULL
Category (카테고리)
- 카테고리ID (category_id) — bigint — Primary key — NOT NULL
- 카테고리이름 (category_name) — varchar — NOT NULL
- 설명 (category_description) — varchar
OrderDetail (주문상세)
- 주문상세ID (order_detail_id) — bigint — Primary key — NOT NULL
- 주문ID (order_id) — bigint — Foreign key → Orders.주문ID — NOT NULL
- 옵션ID (option_id) — bigint — Foreign key → ProductOption.옵션ID — NOT NULL
- 개수 (count) — int — NOT NULL
- 단가 (price) — int — NOT NULL
Orders (주문)
- 주문ID (order_id) — bigint — Primary key — NOT NULL
- 유저ID (user_id) — bigint — Foreign key → User.유저ID — NOT NULL
- 수령인이름 (recipient_name) — varchar — NOT NULL
- 수령인전화번호 (recipient_tel) — varchar — NOT NULL
- 배송지 (delivery_address) — json — NOT NULL
- 배송상세주소 (delivery_detail_address) — varchar — NOT NULL
- 배송요청사항 (delivery_request) — varchar
- 배송비 (delivery_fee) — int — NOT NULL
- 총결제금액 (total_price) — int — NOT NULL
- 주문상태 (order_status) — enum — NOT NULL
- 주문일 (created_at) — datetime — NOT NULL
- 주문수정일 (modified_at) — datetime — NOT NULL
Product (상품)
- 상품ID (product_id) — bigint — Primary key — NOT NULL
- 카테고리ID (category_id) — bigint — Foreign key → Category.카테고리ID — NOT NULL
- 상품명 (product_name) — varchar — NOT NULL
- 가격 (product_price) — int — NOT NULL
- 상품설명 (product_description) — varchar
- 상품세부정보 (product_details) — varchar
- 상품등록일 (created_at) — datetime — NOT NULL
- 상품수정일 (modified_at) — datetime — NOT NULL
ProductImage (상품이미지)
- 상품이미지ID (product_image_id) — bigint — Primary key — NOT NULL
- 상품ID (product_id) — bigint — Foreign key → Product.상품ID — NOT NULL
- 이미지URL (product_image_url) — varchar — NOT NULL
- 파일명 (file_name) — varchar — NOT NULL
ProductOption (상품옵션)
- 옵션ID (option_id) — bigint — Primary key — NOT NULL
- 상품ID (product_id) — bigint — Foreign key → Product.상품ID — NOT NULL
- 사이즈 (option_size) — varchar — NOT NULL
- 재고수량 (stock) — int — NOT NULL
User (유저)
- 유저ID (user_id) — bigint — Primary key — NOT NULL
- 이메일 (email) — varchar — NOT NULL
- 이름 (name) — varchar — NOT NULL
- 역할 (role) — enum — NOT NULL
- 가입일 (created_at) — datetime — NOT NULL
- 회원정보수정일 (modified_at) — datetime — NOT NULL