project-shop

Tables (15)

admin (관리자)

  • 관리자ID (admin_id) — bigint — Primary key — NOT NULL
  • 이름 (name) — varchar — NOT NULL
  • 역할 (role) — enum — NOT NULL
  • 관리자코드(로그인용) (code) — varchar — NOT NULL
  • 비밀번호 (password) — varchar — NOT NULL
  • 등록일자 (created_at) — datetime — NOT NULL
  • 수정일자 (updated_at) — datetime

cart (장바구니)

  • 장바구니ID (cart_id) — bigint — Primary key — NOT NULL
  • 회원ID (member_id) — bigint — Foreign key → member.회원ID — NOT NULL

cart_item (장바구니 속 상품)

  • PK (cart_item_id) — bigint — Primary key — NOT NULL
  • 장바구니ID (cart_id) — bigint — Foreign key → cart.장바구니ID — NOT NULL
  • 상품ID (product_id) — bigint — Foreign key → product.상품ID — NOT NULL
  • 수량 (quantity) — int — NOT NULL
  • 주문선택여부 (is_checked) — boolean — NOT NULL

category (카테고리)

  • 카테고리ID (category_id) — bigint — Primary key — NOT NULL
  • 카테고리명 (name) — varchar — NOT NULL

delivery (배송)

  • PK (delivery_id) — bigint — Primary key — NOT NULL
  • 주문ID (order_id) — bigint — Foreign key → order.주문ID — NOT NULL
  • 배송상태 (status) — enum — NOT NULL
  • 송장번호 (trackingno) — varchar
  • 배송시작일자 (shipped_at) — datetime
  • 배송완료일자 (delivered_at) — datetime

member (회원)

  • 회원ID (member_id) — bigint — Primary key — NOT NULL
  • 이름 (name) — varchar — NOT NULL
  • 비밀번호 (password) — varchar — NOT NULL
  • 이메일 (email) — varchar — NOT NULL
  • 전화번호 (telno) — varchar — NOT NULL
  • 상태 (status) — enum — NOT NULL
  • 가입일자 (created_at) — datetime — NOT NULL
  • 수정일자 (updated_at) — datetime
  • 탈퇴일자 (expired_at) — datetime
  • 차단여부 (is_blocked) — boolean — NOT NULL
  • 최근차단일자 (blocked_at) — datetime

member_address (주소)

  • 주소ID (address_id) — bigint — Primary key — NOT NULL
  • 회원ID (member_id) — bigint — Foreign key → member.회원ID — NOT NULL
  • 도로명주소 (road_address) — varchar — NOT NULL
  • 상세주소 (detail_address) — varchar
  • 기본값여부 (is_default) — boolean — NOT NULL

order (주문)

  • 주문ID (order_id) — bigint — Primary key — NOT NULL
  • 회원ID (member_id) — bigint — Foreign key → member.회원ID — NOT NULL
  • 주문상태 (status) — enum — NOT NULL
  • 총금액 (total_amount) — int — NOT NULL
  • 도로명주소 (road_address) — varchar — NOT NULL
  • 상세주소 (detail_address) — varchar
  • 주문일시 (ordered_at) — datetime — NOT NULL
  • 취소일시 (canceled_at) — datetime

order_item (주문상품)

  • 주문상품ID (order_item_id) — bigint — Primary key — NOT NULL
  • 주문ID (order_id) — bigint — Foreign key → order.주문ID — NOT NULL
  • 상품ID (product_id) — bigint — Foreign key → product.상품ID — NOT NULL
  • 수량 (quantity) — int — NOT NULL
  • 단가 (unit_price) — int — NOT NULL

payment (결제수단)

  • 결제수단ID (payment_id) — bigint — Primary key — NOT NULL
  • 주문ID (order_id) — bigint — Foreign key → order.주문ID — NOT NULL
  • 결제수단명 (name) — enum — NOT NULL
  • 결제상태 (is_paid) — boolean — NOT NULL
  • 결제금액 (paid_amount) — int — NOT NULL
  • 결제일시 (paid_at) — datetime

product (상품)

  • 상품ID (product_id) — bigint — Primary key — NOT NULL
  • 카테고리ID (category_id) — bigint — Foreign key → category.카테고리ID — NOT NULL
  • 관리자ID (admin_id) — bigint — Foreign key → admin.관리자ID — NOT NULL
  • 상품코드 (code) — varchar — NOT NULL
  • 상품명 (name) — varchar — NOT NULL
  • 가격 (price) — int — NOT NULL
  • 재고수량 (stock_quantity) — int — NOT NULL
  • 상품설명 (detail) — varchar
  • 유통기한 (expiration_date) — datetime — NOT NULL
  • 판매상태 (status) — enum — NOT NULL
  • 등록일자 (created_at) — datetime — NOT NULL
  • 수정일자 (updated_at) — datetime

product_image (상품사진)

  • 상품사진ID (product_image_id) — bigint — Primary key — NOT NULL
  • 상품ID (product_id) — bigint — Foreign key → product.상품ID — NOT NULL
  • 이미지url (image_url) — varchar — NOT NULL
  • 대표이미지여부 (is_thumbnail) — boolean — NOT NULL

refund (반품)

  • 반품ID (return_id) — bigint — Primary key — NOT NULL
  • 주문ID (order_id) — bigint — Foreign key → order.주문ID — NOT NULL
  • 관리자ID (admin_id) — bigint — Foreign key → admin.관리자ID — NOT NULL
  • reason_type (신청사유) — enum — NOT NULL
  • content (내용) — varchar — NOT NULL
  • status (상태) — enum — NOT NULL
  • refund_amount (환불금액) — int
  • created_at (신청일시) — datetime — NOT NULL
  • updated_at (수정일시) — datetime
  • processed_at (처리일시) — datetime

review (리뷰)

  • 리뷰ID (review_id) — bigint — Primary key — NOT NULL
  • 주문상품ID (order_item_id) — bigint — Foreign key → order_item.주문상품ID — NOT NULL
  • 회원ID (member_id) — bigint — Foreign key → member.회원ID — NOT NULL
  • 별점 (rating) — int — NOT NULL
  • 제목 (title) — varchar — NOT NULL
  • 내용 (content) — varchar — NOT NULL
  • 등록일시 (created_at) — datetime — NOT NULL
  • 수정일시 (updated_at) — datetime
  • 공개여부 (is_public) — boolean — NOT NULL

review_image (리뷰 첨부사진)

  • PK (review_image_id) — bigint — Primary key — NOT NULL
  • 리뷰ID (review_id) — bigint — Foreign key → review.리뷰ID — NOT NULL
  • 이미지url (image_url) — varchar — NOT NULL