SSG

Tables (5)

Common (공통)

  • CreatedAt (생성날짜) — Datetime — NOT NULL
  • ModifiedAt (수정날짜) — Datetime — NOT NULL

Item (상품)

  • ItemId (상품번호) — Long — Primary key — NOT NULL
  • ItemName (이름) — String — NOT NULL
  • ItemPrice (가격) — Integer — NOT NULL
  • ItemType (타입) — String — NOT NULL
  • ItemDisplayStartDate (전시 시작 날짜) — Datetime — NOT NULL
  • ItemDisplayEndDate (전시 끝 날짜) — Datetime — NOT NULL

Promotion (프로모션)

  • PromotionId (프로모션번호) — Long — Primary key — NOT NULL
  • PromotionNm (이름) — String — NOT NULL
  • DiscountAmount (정액) — Integer
  • DiscountRate (정률) — BigDecimal
  • PromotionStartDate (전시 시작 날짜) — Datetime — NOT NULL
  • PromotionEndDate (전시 끝 날짜) — Datetime — NOT NULL

PromotionItem (프로모션상품)

  • PromotionItemId (프로모션상품번호) — Long — Primary key — NOT NULL
  • ItemId (상품번호) — Long — Foreign key → Item.ItemId — NOT NULL
  • PromotionId (프로모션번호) — Long — Foreign key → Promotion.PromotionId — NOT NULL

User (사용자)

  • UserId (사용자번호) — Long — Primary key — NOT NULL
  • UserName (이름) — String — NOT NULL
  • UserType (타입) — String — NOT NULL
  • UserStat (상태) — String — NOT NULL