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