Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- User
- - PK-> user_id : Int[11]
- - display_name : Char[256]
- - username : Char[256]
- - email : Char[256]
- - password : Char[256]
- - passphrase : Char[256]
- - referral_id : Int[11]
- - FK-> permission_id : Int[11]
- - FK-> access_status_i : Int[11]
- - confirm_email_at : DateTime[]
- - registered_at : DateTime[]
- - created_at : DateTime[]
- - updated_at : DateTime[]
- AccessStatus
- - access_status_id : Int[11]
- - objects_data : Char[256] // { deposit: true, withdrawal: true }
- Permission
- - PK-> permission_id : Int[11]
- - level : Int[11]
- Balance
- - PK-> balance_id : Int[11]
- - FK-> user_id : Int[11]
- - FK-> currency_id : Int[11]
- - action_type : Int[11] // 1 = increse , 2 = decrese
- - total_balance : Decimal[16,8]
- - available_balance : Decimal[16,8]
- - pending_balance : Decimal[16,8]
- - lock_options : Decimal[16,8]
- - final_balance : Decimal[16,8]
- - previous_hash : Char[128]
- - current_hash : Char[128]
- Security
- - PK-> security_id : Int[11]
- - opt_password : Char[128]
- - twofactor_password : Char[64]
- - passphrase_verify_hash : Char[128]
- UserLogging
- - PK-> user_logging_id : Int[11]
- - ip_address : Char[128]
- - user_agent : Char[256]
- - geo_location : Char[256]
- - session : Char[256]
- - deviced_name : Char[256]
- - is_proxy : Int[11]
- - authorized_token : Char[128]
- - attemp_count : Int[11]
- - login_at : DateTime[]
- - created_at : DateTime[]
- UserSetting
- - PK-> user_setting_id : Int[11]
- - language : Char[256]
- - timezone : Char[256]
- - display_currency_type : Char[256]
- - objects_data : Char[1024] // { alert_deposit: true, alert_withdrawal: true, alert_buy_currency: true, alert_sell_currency: true }
- CurrencyType
- - PK-> currency_id : Int[11]
- - name : Char[256]
- - symbol : Char[64]
- Paring
- - PK-> paring_id : Int[11]
- - symbol_paring : Char[64]
- - base_currency : Int[11]
- - major_currency : Int[11]
- - last_price : Decimal[16,8]
- - trend : Int[11] // 1 = up, 0 = down
- - percentile : Int[11]
- - created_at : DateTime[]
- - updated_at : DateTime[]
- PendingCurrencyOrder
- - PK-> pending_currency_order_id : Int[]
- - pending_type : Int[11] // 1 = Send , 2 = Received
- - to_address : Char[256]
- - from_address : Char[256]
- - amount : Decimal[16,8]
- - created_at : DateTime[]
- - verify_hash : Char[128]
- CurrencyWallet
- - PK-> currency_wallet_id : Int[11]
- - FK-> currency_id : Int[11]
- - address : Char[256]
- - private_key : Char[256]
- - wif_key : Char[256]
- - public_key : Char[256]
- - number_tx : Int[11]
- - created_at : DateTime[]
- CurrencyTX
- - PK-> currency_tx_id : Int[11]
- - FK-> currency_id : Int[11]
- - txid : Char[256]
- - address : Char[256]
- - amount : Decimal[16,8]
- - confirmations : Int[11]
- - tx_type : Int[11] // 1 = send_out , 2 = receive_in
- - verify_hash : Char[256] // (txid+amount+address)
- - created_at : DateTime[]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement