Skip to content

Instantly share code, notes, and snippets.

@reynldi
Created September 23, 2022 03:56
Show Gist options
  • Select an option

  • Save reynldi/82efad1a71c64b76e8f4afa36b38830c to your computer and use it in GitHub Desktop.

Select an option

Save reynldi/82efad1a71c64b76e8f4afa36b38830c to your computer and use it in GitHub Desktop.
@startuml
' hide the spot
hide circle
entity "custom_referrals" as custom_referrals {
* id uint <<PK>>
--
* user_uuid varchar(36)
* referral_code varchar(8)
* total_user_acquired (int)
* owner_commission_trading_fee (varchar)
* owner_commission_signup (varchar)
* owner_commission_deposit (varchar)
* owner_commission_withdrawal (varchar)
* owner_commission_trading_fee (varchar)
* referred_commission_trading_fee (varchar)
* referred_commission_signup (varchar)
* referred_commission_deposit (varchar)
* referred_commission_withdrawal (varchar)
* referred_commission_trading_fee (varchar)
* expiry_time
* is_deleted int
* created_at datetime
* update_at datetime
* updated_at datetime
}
entity "commission_history" as commission_history {
* id uint <<PK>>
--
* user_uuid varchar(32)
* referral_code varchar(6)
* total_user_acquired int
* owner_commission_trading_fee (varchar)
* owner_commission_signup (varchar)
* owner_commission_deposit (varchar)
* owner_commission_withdrawal (varchar)
* owner_commission_trading_fee (varchar)
* referred_commission_trading_fee (varchar)
* referred_commission_signup (varchar)
* referred_commission_deposit (varchar)
* referred_commission_withdrawal (varchar)
* referred_commission_trading_fee (varchar)
* expiry_time
* is_deleted int
* created_at datetime
* update_at datetime
* updated_at datetime
}
custom_referrals -> commission_history
@enduml
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment