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