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