База данных MySQL

Начать. Это бесплатно
или Регистрация c помощью Вашего email-адреса
Rocket clouds
База данных MySQL создатель Mind Map: База данных MySQL

1. User

1.1. id

1.2. email

1.3. name

1.4. password_hash

1.5. password_reset_token

1.6. auth_key

1.7. social_provider

1.8. social_id

1.9. role

1.9.1. user (10)

1.9.2. partner (20)

1.9.3. support (30)

1.9.4. moderate (40)

1.9.5. manager (50)

1.9.6. admin (255)

1.10. banned

1.11. created_at

1.12. updated_at

1.13. last_online

2. UserProfile

2.1. user_id

2.2. photo

2.3. sex

2.3.1. man(1)

2.3.2. woman(0)

2.4. age

2.5. country

2.6. city

2.7. phone

2.8. phone_verified

2.9. balance_real

2.10. balance_game

2.11. payments_in

2.12. payments_out

2.13. level

2.14. level_points

2.15. game_count

2.16. game_win

2.17. game_lost

2.18. game_draw

2.19. game_leave

2.20. email_subscribe

2.21. sms_subscribe

2.22. created_at

2.23. updated_at

3. Partner

3.1. id

3.2. user_id

3.3. link

3.4. referral_visits

3.5. referral_registrations

3.6. referral_paid

3.7. referral_payments

3.8. commission_in

3.9. commission_out

3.10. banned

4. PartnerReferral

4.1. id

4.2. user_id

4.3. partner_id

4.4. profit_amount

4.5. http_referrer

4.6. ip

4.7. ua

4.8. date_first_visit

4.9. date_register

5. PaymentTransaction

5.1. id

5.2. user_id

5.3. type

5.3.1. game_to_user

5.3.2. user_to_game

5.3.3. payin_user

5.3.4. payout_user

5.4. currency

5.4.1. real

5.4.2. virtual

5.5. amount

5.6. description

5.7. status

5.7.1. wait

5.7.2. process

5.7.3. success

5.7.4. fail

5.8. date_start

5.9. date_end

6. PaymentIn

6.1. id

6.2. transaction_id

6.3. provider

6.4. token

7. PaymentOut

7.1. id

7.2. transaction_id

7.3. provider

7.4. token

8. Game

8.1. id

8.2. bid

8.3. type

8.3.1. real

8.3.2. virtual

8.4. player1

8.5. player2

8.6. player3

8.7. player4

8.8. player5

8.9. move_player

8.10. move_length

8.11. status

9. GamePlayerCompany

9.1. id

9.2. game_id

9.3. company_id

9.4. owner_id

9.5. filials_count

9.6. monopoly

9.7. rent_amount

9.8. pledge_time

9.9. status

9.9.1. sale

9.9.2. active

9.9.3. pledge

10. GameTransaction

10.1. id

10.2. game_id

10.3. sender

10.4. recipient

10.5. amount

10.6. status

10.6.1. process

10.6.2. success

10.6.3. fail

10.7. date_start

10.8. date_end

11. GameCompany

11.1. id

11.2. name

11.3. description

11.4. photo

11.5. icon

11.6. position

11.7. minigame

11.8. price

11.9. price_filials

11.10. price_monopoly

11.11. profit

11.12. profit_filials_0

11.13. profit_filials_1

11.14. profit_filials_2

11.15. profit_filials_3

11.16. profit_filials_4

11.17. profit_monopoly

12. GameLog

12.1. id

12.2. game_id

12.3. player_id

12.4. move

12.5. event

12.6. description

13. GamePlayer

13.1. id

13.2. user_id

13.3. game_id

13.4. balance

13.5. capital

13.6. position

13.7. skip_move

13.8. additional

13.9. winner

13.10. status