erd.md

ERD

• Total
• User
• UserPoint
• Order
• OrderLine
• Payment
• CouponEvent
• Coupon
• Product
• ProductStock
• ProductPopularity

Total

erDiagram
    User{
        userId long PK
        username string
    }
    UserPoint{
        pointId long PK
        userId long FK "User.Id"
        balance long
        updateMillis long
    }
    CouponEvent{
        eventId long PK
        name string
        type enum "FIXED, PERCENTAGE"
        value long
        totalCount int
        currentCount int
        expiryMillis long
        validFsprom long
        validTo long
    }
    Coupon{
        code string PK
        userId long FK "User.userId"
        type enum "FIXED, PERCENTAGE"
        value long
        expiryMillis long
        isUsed boolean
        createMillis long
    }
    Order{
        orderId long PK
        userId long FK "User.userId"
        totalAmount long
        discountAmount long
        orderStatus enum "PENDING, FAILURE, COMPLETE, CALCEL"
        createMillis long
        updateMillis long
    }
    OrderLine{
        orderLineId long PK
        orderId long FK "Order.orderId"
        productId long FK "Product.productId"
        quantity int
        price long
    }
    Payment{
        paymentId long PK
        orderId long FK "Order.orderId"
        amount long
        status enum "PENDING, FAILURE, COMPLETE, CALCEL"
        createMillis long
        updateMillis long
    }
    Product{
        productId long PK
        productname string
        price long
    }
    ProductStock{
        stockId long PK
        productId long FK "Product.productId"
        quantity int 
        version int
    }
    ProductPopularity{
        popularityId long PK
        productId long FK "Product.productId"
        productName string
        rank int
        totalOrder int
        updateMillis long
    }

    User ||--|| UserPoint: ""
    User ||--o{ Order: ""
    User ||--o{ Coupon:  ""
    CouponEvent ||--o{ Coupon: ""
    Product ||--|| ProductStock: ""
    Product ||--|| ProductPopularity: ""
    OrderLine ||--|| Product: ""
    Order ||--|{ OrderLine: ""
    Order ||--|| Payment: ""

Loading

User

erDiagram
    User{
        userId long PK
        username string
    }
    UserPoint{
        pointId long PK
        userId long FK "User.Id"
        balance long
        updateMillis long
    }
    User ||--|| UserPoint: ""
    User ||--o{ Coupon:  ""
    User ||--o{ Order: ""

Loading

User

Properties

• userId: 유저아이디 PK
• username: 유저명

UserPoint

Properties

• pointId: 포인트 아이디 PK
• userId: User.userId FK
• balance: 잔액
• updateMillis: 수정일시

Evnets

erDiagram
    CouponEvent{
        eventId long PK
        name string
        type enum "FIXED, PERCENTAGE"
        value long
        totalCount int
        currentCount int
        expiryMillis long
        validFsprom long
        validTo long
    }
    Coupon{
        code string PK
        userId long FK "User.userId"
        type enum "FIXED, PERCENTAGE"
        value long
        expiryMillis long
        isUsed boolean
        createMillis long
    }
    CouponEvent ||--o{ Coupon: ""
    User ||--o{ Coupon:  ""

Loading

CouponEvent

Properties

• eventId: 이벤트아이디 PK
• name: 이벤트명
• type: 할인정책 "FIXED, PERCENTAGE"

  • FIXED: 정액
  • PERCENTAGE: 정률

• value: 할인금액
• totalCount: 전체개수
• currentCount: 발급개수
• expiryDate: 만료일자
• validFrom: 발급시작일자
• validTo: 발급종료일자

Coupon

Properties

• code: 코드번호 PK
• userId: User.userId FK
• type: 할인정책 "FIXED, PERCENTAGE"

  • FIXED: 정액
  • PERCENTAGE: 정률

• value: 할인금액
• expiryDate: 만료일자
• isUsed: 사용상태
• createMillis: 생성일시

Orders

erDiagram
    Order{
        orderId long PK
        userId long FK "User.userId"
        totalAmount long
        discountAmount long
        orderStatus enum "PENDING, FAILURE, COMPLETE, CALCEL"
        createMillis long
        updateMillis long
    }
    OrderLine{
        orderLineId long PK
        orderId long FK "Order.orderId"
        productId long FK "Product.productId"
        quantity int
        price long
    }
    Payment{
        paymentId long PK
        orderId long FK "Order.orderId"
        amount long
        status enum "PENDING, FAILURE, COMPLETE, CALCEL"
        createMillis long
        updateMillis long
    }
    Order ||--|{ OrderLine: ""
    Order ||--|| Payment: ""

Loading

Order

Properties

• orderId: 오더아이디 PK
• userId: User.userId FK
• totalAmount: 전체가격
• discountAmount: 할인금액
• orderStatus: 주문상태

  • PENDING: 결제대기
  • FAILURE: 주문실패
  • COMPLETE: 주문완료
  • CALCEL: 주문취소

• createMillis: 생성일시
• updateMillis: 수정일시

OrderLine

Properties

• orderLineId: 오더라인아이디 PK
• orderId: Order.orderId FK
• productId: Product.productId FK
• quantity: 개수
• price: 단가

Payment

Properties

• paymentId: 결제아이디 PK
• orderId: Order.orderId FK
• amount: 결제금액
• status: 상태

  • PENDING: 결제중
  • FAILURE: 결재실패
  • COMPLETE: 결재완료

• createMillis: 생성일시
• updateMillis: 수정일시

Products

erDiagram
    Product{
        productId long PK
        name string
        price long
    }
    ProductStock{
        stockId long PK
        productId long FK "Product.productId"
        quantity int 
        version int
    }
    ProductPopularity{
        popularityId long PK
        productId long FK "Product.productId"
        productName string
        rank int
        totalOrder int
        updateMillis long
    }
    Product ||--|| ProductStock: ""
    Product ||--|| ProductPopularity: ""

Loading

Product

Properties

• productId: 상품아이디 PK
• name: 제품명
• price: 단가

ProductStock

Properties

• stockId: 재고아이디 PK
• productId: Product.productId FK
• quantity: 재고량
• version: 버전

ProductPopularity

Properties

• popularityId: 상위상품아이디 PK
• productId: Product.productId FK
• productName: 상품명
• rank: 순위
• totalOrder: 총주문개수
• updateMillis: 수정일시