Table of contents

erDiagram

Member {
  uint   ID
  uint   Status
  uint   Points
  uint   MembershipLevelID
}


MembershipLevel {
  uint   ID
  string Title
}

Product {
  uint   ID
  uint   Price
  uint   PromotionID
  string Title
}

Promotion {
  uint   ID
  uint   PromotionMembershipLevelID
  string Code
  string Title
}

PromotionMembershipLevel {
  uint    ID
  uint    PromotionID
  uint    MembershipLevelID
  float32 MembershipPercentOff
  float32 PotinRate
}

Member          ||--|| MembershipLevel: "one-to-one"
Product         ||--|| Promotion: "one-to-one"
Promotion       }o--o{ PromotionMembershipLevel: "many-to-many"
MembershipLevel }o--o{ PromotionMembershipLevel: "many-to-many"

flowchart TB

classDef Type fill: #4287f5
classDef SameLogic fill: #777

Member:::Type --> |buy| Product:::Type
Member        -.- |with| MembershipLevel:::Type
Product       -.- |with| Promotion.Code:::Type

%% A
Promotion.Code --- |"A"| ResultA(Product.Price)

%% B
Promotion.Code --- |"B"| PromotionMembershipLevel.MembershipLevelID:::Type
PromotionMembershipLevel.MembershipLevelID --> |0| ResultB1(Product.Price)
PromotionMembershipLevel.MembershipLevelID --> |1| ResultB2(Product.Price x 0.95)
PromotionMembershipLevel.MembershipLevelID --> |2| ResultB3(Product.Price x 0.9)
PromotionMembershipLevel.MembershipLevelID --> |3| ResultB4(Product.Price x 0.85)

%% C
Promotion.Code --> |"C"| ResultC1(Product.Price - UsePoints x PromotionMembershipLevel.PointRate):::SameLogic

%% D (Extend from C)
ResultC1 --- |D| ConditionD[["PromotionMembershipLevel.MembershipLevelID > 0 <br>&&<br>UsePoints >= 100"]]
ConditionD --> ResultD(Product.Price after deducting UsePoints x 0.9)

%% Link style
linkStyle 10,11 stroke:#ff3,color:yellow;