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