rising-erd
Tables (10)
CartItem (장바구니)
- 장바구니ID (id) — PRIMARYKEY — Primary key — NOT NULL
- 수량 (quantity) — NOT NULL
- 선택옵션 (selected_option) — NOTNULL
- 유저ID (user_id) — FOREIGNKEY — Foreign key → User.유저ID — NOT NULL
- 판매자등록ID (vender_product_id) — FOREIGNKEY — Foreign key → VendorProduct.판매자등록ID — NOT NULL
Category (카테코리)
- 카테고리ID (id) — PRIMARYKEY — Primary key — NOT NULL
- 카테고리명 (name) — NOTNULL
- 상위 카테고리ID (category_id) — FOREIGNKEY — Foreign key → Category.카테고리ID — NOT NULL
Option (옵션)
- 옵션ID (id) — PRIMARYKEY — Primary key — NOT NULL
- 옵션명 (name) — NOTNULL
- 설명 (description) — NOTNULL
- 그룹ID (option_group_id) — FOREIGNKEY — Foreign key → OptionGroup.그룹ID — NOT NULL
OptionGroup (옵션 그룹)
- 그룹ID (id) — PRIMARYKEY — Primary key — NOT NULL
- 그룹명 (name) — NOTNULL
- 상품ID (product_id) — FOREIGNKEY — Foreign key → Products.상품ID — NOT NULL
Order (주문)
- 주문ID (id) — PRIMARYKEY — Primary key — NOT NULL
- 주문일시 (order_date) — NOTNULL
- 총금액 (total_price) — NOTNULL
- 유저ID (user_id) — FOREINGKEY — Foreign key → User.유저ID — NOT NULL
OrderItem (주문상품별상세)
- 상세ID (id) — PRIMARYKEY — Primary key — NOT NULL
- 수량 (quantity) — NOTNULL
- 옵션 (selected_option) — NOTNULL
- 단가 (item_price) — NOTNULL
- 주문ID (order_id) — FOREIGNKEY — Foreign key → Order.주문ID — NOT NULL
- 판매자등록ID (vender_product_id) — FOREIGNKEY — Foreign key → VendorProduct.판매자등록ID — NOT NULL
Products (상품)
- 상품ID (id) — PRIMARYKEY — Primary key — NOT NULL
- 상품명 (name) — NOTNULL
- 설명 (discription) — NOTNULL
- 카테고리ID (category_id) — FOREIGNKEY — Foreign key → Category.카테고리ID — NOT NULL
User (유저)
- 유저ID (id) — PRIMARYKEY — Primary key — NOT NULL
- 이름 (name) — NOTNULL
- 비밀번호 (pw) — NOTNULL
- 이메일 (email) — NOTNULL
- 생년월일 (birth_date) — NOTNULL
- 역활 (role) — NOTNULL
VendorProduct (판매자별 상품 등록)
- 판매자등록ID (id) — PRIMARYKEY — Primary key — NOT NULL
- 가격 (price) — NOTNULL
- 재고수량 (stock_quantity) — NOT NULL
- 판매코드 (vendor_item_code) — NOT NULL
- 유저ID (user_id) — FOREIGNKEY — Foreign key → User.유저ID — NOT NULL
- 상품ID (product_id) — FOREIGNKEY — Foreign key → Products.상품ID — NOT NULL
WishList (관심상품)
- 관심상품ID (id) — PRIMARYKEY — Primary key — NOT NULL
- 판매자등록ID (vender_product_id) — FOREIGNKEY — Foreign key → VendorProduct.판매자등록ID — NOT NULL
- 유저ID (user_id) — FOREIGNKEY — Foreign key → User.유저ID — NOT NULL