База данных MySQL

1. Partner

1.1. id

1.2. user_id

1.3. link

1.4. referral_visits

1.5. referral_registrations

1.6. referral_paid

1.7. referral_payments

1.8. commission_in

1.9. commission_out

1.10. banned

2. PartnerReferral

2.1. id

2.2. user_id

2.3. partner_id

2.4. profit_amount

2.5. http_referrer

2.6. ip

2.7. ua

2.8. date_first_visit

2.9. date_register

3. PaymentTransaction

3.1. id

3.2. user_id

3.3. type

3.3.1. game_to_user

3.3.2. user_to_game

3.3.3. payin_user

3.3.4. payout_user

3.4. currency

3.4.1. real

3.4.2. virtual

3.5. amount

3.6. description

3.7. status

3.7.1. wait

3.7.2. process

3.7.3. success

3.7.4. fail

3.8. date_start

3.9. date_end

4. PaymentIn

4.1. id

4.2. transaction_id

4.3. provider

4.4. token

5. PaymentOut

5.1. id

5.2. transaction_id

5.3. provider

5.4. token

6. Game

6.1. id

6.2. bid

6.3. type

6.3.1. real

6.3.2. virtual

6.4. player1

6.5. player2

6.6. player3

6.7. player4

6.8. player5

6.9. move_player

6.10. move_length

6.11. status

7. GamePlayer

7.1. id

7.2. user_id

7.3. game_id

7.4. balance

7.5. capital

7.6. position

7.7. skip_move

7.8. additional

7.9. winner

7.10. status

8. User

8.1. id

8.2. email

8.3. name

8.4. password_hash

8.5. password_reset_token

8.6. auth_key

8.7. social_provider

8.8. social_id

8.9. role

8.9.1. user (10)

8.9.2. partner (20)

8.9.3. support (30)

8.9.4. moderate (40)

8.9.5. manager (50)

8.9.6. admin (255)

8.10. banned

8.11. created_at

8.12. updated_at

8.13. last_online

9. UserProfile

9.1. user_id

9.2. photo

9.3. sex

9.3.1. man(1)

9.3.2. woman(0)

9.4. age

9.5. country

9.6. city

9.7. phone

9.8. phone_verified

9.9. balance_real

9.10. balance_game

9.11. payments_in

9.12. payments_out

9.13. level

9.14. level_points

9.15. game_count

9.16. game_win

9.17. game_lost

9.18. game_draw

9.19. game_leave

9.20. email_subscribe

9.21. sms_subscribe

9.22. created_at

9.23. updated_at

10. GamePlayerCompany

10.1. id

10.2. game_id

10.3. company_id

10.4. owner_id

10.5. filials_count

10.6. monopoly

10.7. rent_amount

10.8. pledge_time

10.9. status

10.9.1. sale

10.9.2. active

10.9.3. pledge

11. GameTransaction

11.1. id

11.2. game_id

11.3. sender

11.4. recipient

11.5. amount

11.6. status

11.6.1. process

11.6.2. success

11.6.3. fail

11.7. date_start

11.8. date_end

12. GameCompany

12.1. id

12.2. name

12.3. description

12.4. photo

12.5. icon

12.6. position

12.7. minigame

12.8. price

12.9. price_filials

12.10. price_monopoly

12.11. profit

12.12. profit_filials_0

12.13. profit_filials_1

12.14. profit_filials_2

12.15. profit_filials_3

12.16. profit_filials_4

12.17. profit_monopoly

13. GameLog

13.1. id

13.2. game_id

13.3. player_id

13.4. move

13.5. event

13.6. description