e-commerce
Tables (14)
CART (장바구니)
- ID — BIGINT — Primary key — NOT NULL
- PRODUCT_ID — BIGINT — Foreign key → PRODUCT.ID — NOT NULL
- USER_ID — BIGINT — Foreign key → USER.ID — NOT NULL
- AMOUNT (수량) — INTEGER
- CREATED_AT (생성일시) — DATETIME
- UPDATED_AT (수정일시) — DATETIME
CATEGORY (카테고리)
- ID — BIGINT — Primary key — NOT NULL
- NAME (카테고리명) — VARCHAR(255)
- CREATED_AT (생성일시) — DATETIME
- UPDATED_AT (수정일시) — DATETIME
COUPON (쿠폰)
- ID — BIGINT — Primary key — NOT NULL
- NAME (쿠폰명) — VARCHAR(255)
- TYPE (쿠폰타입) — ENUM
- DISCOUNT_TYPE (할인타입) — ENUM
- DISCOUNT_AMOUNT (할인액) — INTEGER
- CREATED_AT (생성일시) — DATETIME
- UPDATED_AT (수정일시) — DATETIME
INVENTORY (재고)
- ID — BIGINT — Primary key — NOT NULL
- PRODUCT_ID — BIGINT — Foreign key → PRODUCT.ID — NOT NULL
- STOCK (재고수) — INTEGER
- CREATED_AT (생성일시) — DATETIME
- UPDATED_AT (수정일시) — DATETIME
ISSUED_COUPON (발급쿠폰)
- ID — BIGINT — Primary key — NOT NULL
- USER_ID — BIGINT — Foreign key → USER.ID — NOT NULL
- COUPON_ID — BIGINT — Foreign key → COUPON.ID — NOT NULL
- CREATED_AT (생성일시) — DATETIME
- UPDATED_AT (수정일시) — DATETIME
ITEM (물품)
- ID — BIGINT — Primary key — NOT NULL
- CATEGORY_ID (카테고리ID) — BIGINT — Foreign key → CATEGORY.ID — NOT NULL
- NAME (상품명) — VARCHAR(255)
- DESC (상품 설명) — TEXT
- SALE_STATUS (판매 상태) — ENUM
- PRICE (가격) — INTEGER
- SALE_START_DATE (판매 시작일) — DATETIME
- CREATED_AT (생성일시) — DATETIME
- UPDATED_AT (수정일시) — DATETIME
OPTION (옵션)
- ID — BIGINT — Primary key — NOT NULL
- PRICE (추가 금액) — INTEGER
- NAME (옵션명) — VARCHAR(255)
- CREATED_AT (생성일시) — DATETIME
- UPDATED_AT (수정일시) — DATETIME
ORDER (주문)
- ID — BIGINT — Primary key — NOT NULL
- USER_ID — BIGINT — Foreign key → USER.ID — NOT NULL
- ORDER_NO (주문번호) — VARCHAR(255)
- AMOUNT (수량) — INTEGER
- CREATED_AT (생성일시) — DATETIME
- UPDATED_AT (수정일시) — DATETIME
ORDER_PRODUCT (주문상품)
- PRODUCT_ID — BIGINT — Foreign key → PRODUCT.ID — NOT NULL
- ORDER_ID — BIGINT — Foreign key → ORDER.ID — NOT NULL
- AMOUNT (수량) — INTEGER
- CREATED_AT (생성일시) — DATETIME
- UPDATED_AT (수정일시) — DATETIME
PAYMENT (결제)
- ID — BIGINT — Primary key — NOT NULL
- ORDER_ID — BIGINT — Foreign key → ORDER.ID — NOT NULL
- CREATED_AT (생성일시) — DATETIME
- UPDATED_AT (수정일시) — DATETIME
POINT_HISTORY (포인트 내역)
- ID — BIGINT — Primary key — NOT NULL
- USER_ID — BIGINT — Foreign key → USER.ID — NOT NULL
- AMOUNT (금액) — INTEGER
- TYPE (타입) — ENUM
- CREATED_AT (생성일시) — DATETIME
- UPDATED_AT (수정일시) — DATETIME
PRODUCT (상품)
- ID — BIGINT — Primary key — NOT NULL
- OPTION_ID — BIGINT — Foreign key → OPTION.ID — NOT NULL
- ITEM_ID — BIGINT — Foreign key → ITEM.ID — NOT NULL
USER (사용자)
- ID — BIGINT — Primary key — NOT NULL
- EMAIL — VARCHAR(255)
- PASSWORD — VARCHAR(255)
- ROLE — ENUM
- CREATED_AT (생성일시) — DATETIME
- UPDATED_AT (수정일시) — DATETIME
USER_POINT (사용자포인트)
- ID — BIGINT — Primary key — NOT NULL
- USER_ID — BIGINT — Foreign key → USER.ID — NOT NULL
- POINT — INTEGER
- CREATED_AT (생성일시) — DATETIME
- UPDATED_AT (수정일시) — DATETIME