Advertisement
Guest User

Untitled

a guest
Jul 24th, 2017
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.62 KB | None | 0 0
  1. User
  2. - PK-> user_id : Int[11]
  3. - display_name : Char[256]
  4. - username : Char[256]
  5. - email : Char[256]
  6. - password : Char[256]
  7. - passphrase : Char[256]
  8. - referral_id : Int[11]
  9. - FK-> permission_id : Int[11]
  10. - FK-> access_status_i : Int[11]
  11. - confirm_email_at : DateTime[]
  12. - registered_at : DateTime[]
  13. - created_at : DateTime[]
  14. - updated_at : DateTime[]
  15.  
  16. AccessStatus
  17. - access_status_id : Int[11]
  18. - objects_data : Char[256] // { deposit: true, withdrawal: true }
  19.  
  20. Permission
  21. - PK-> permission_id : Int[11]
  22. - level : Int[11]
  23.  
  24. Balance
  25. - PK-> balance_id : Int[11]
  26. - FK-> user_id : Int[11]
  27. - FK-> currency_id : Int[11]
  28. - action_type : Int[11] // 1 = increse , 2 = decrese
  29. - total_balance : Decimal[16,8]
  30. - available_balance : Decimal[16,8]
  31. - pending_balance : Decimal[16,8]
  32. - lock_options : Decimal[16,8]
  33. - final_balance : Decimal[16,8]
  34. - previous_hash : Char[128]
  35. - current_hash : Char[128]
  36.  
  37. Security
  38. - PK-> security_id : Int[11]
  39. - opt_password : Char[128]
  40. - twofactor_password : Char[64]
  41. - passphrase_verify_hash : Char[128]
  42.  
  43. UserLogging
  44. - PK-> user_logging_id : Int[11]
  45. - ip_address : Char[128]
  46. - user_agent : Char[256]
  47. - geo_location : Char[256]
  48. - session : Char[256]
  49. - deviced_name : Char[256]
  50. - is_proxy : Int[11]
  51. - authorized_token : Char[128]
  52. - attemp_count : Int[11]
  53. - login_at : DateTime[]
  54. - created_at : DateTime[]
  55.  
  56. UserSetting
  57. - PK-> user_setting_id : Int[11]
  58. - language : Char[256]
  59. - timezone : Char[256]
  60. - display_currency_type : Char[256]
  61. - objects_data : Char[1024] // { alert_deposit: true, alert_withdrawal: true, alert_buy_currency: true, alert_sell_currency: true }
  62.  
  63. CurrencyType
  64. - PK-> currency_id : Int[11]
  65. - name : Char[256]
  66. - symbol : Char[64]
  67.  
  68. Paring
  69. - PK-> paring_id : Int[11]
  70. - symbol_paring : Char[64]
  71. - base_currency : Int[11]
  72. - major_currency : Int[11]
  73. - last_price : Decimal[16,8]
  74. - trend : Int[11] // 1 = up, 0 = down
  75. - percentile : Int[11]
  76. - created_at : DateTime[]
  77. - updated_at : DateTime[]
  78.  
  79. PendingCurrencyOrder
  80. - PK-> pending_currency_order_id : Int[]
  81. - pending_type : Int[11] // 1 = Send , 2 = Received
  82. - to_address : Char[256]
  83. - from_address : Char[256]
  84. - amount : Decimal[16,8]
  85. - created_at : DateTime[]
  86. - verify_hash : Char[128]
  87.  
  88. CurrencyWallet
  89. - PK-> currency_wallet_id : Int[11]
  90. - FK-> currency_id : Int[11]
  91. - address : Char[256]
  92. - private_key : Char[256]
  93. - wif_key : Char[256]
  94. - public_key : Char[256]
  95. - number_tx : Int[11]
  96. - created_at : DateTime[]
  97.  
  98. CurrencyTX
  99. - PK-> currency_tx_id : Int[11]
  100. - FK-> currency_id : Int[11]
  101. - txid : Char[256]
  102. - address : Char[256]
  103. - amount : Decimal[16,8]
  104. - confirmations : Int[11]
  105. - tx_type : Int[11] // 1 = send_out , 2 = receive_in
  106. - verify_hash : Char[256] // (txid+amount+address)
  107. - created_at : DateTime[]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement