Ararea

1. GAMES

1.1. languages {array de strings}

1.2. publisher_id

1.3. title (unique, text {searchable})

1.4. release_year

1.5. description (text {searchable})

1.6. cover (url)

1.7. developer_id

1.8. published_by_developer?

1.9. platforms (array)

1.10. in_development?

2. GAME_RATINGS

2.1. game_id

2.2. user_id

2.3. narrative_score

2.4. visuals_score

2.5. music_score

2.6. gameplay_score

2.7. performance_score

2.8. hype_score

2.9. review (text {searchable})

2.10. color

2.11. innovation_score

3. SUBJECTS

3.1. label (text {searchable})

3.2. image (url?)

4. USERS

4.1. password

4.2. username (unique, text {searchable})

4.3. email (unique)

4.4. name (text {searchable})

4.5. avatar

4.6. website

4.7. bio (text {searchable})

4.8. twitter_username

4.9. youtube_username

4.10. twitch_username

4.11. gender

4.12. is_birth_year_private?

4.13. is_gender_private?

4.14. birth_year

4.15. steam_username

4.16. battletag

4.17. accent_color

4.18. favorite_subjects (array de ids {3})

4.19. favorite_games (array de ids {3})

4.20. country

4.21. current_games (array de ids {3})

4.22. github_username

4.23. verification_token

4.24. is_verified?

4.25. is_deleted?

4.26. languages {array de strings}

5. DEVELOPERS

5.1. itchio_username

5.2. github_username

5.3. twitter_username

5.4. name (unique, text {searchable})

5.5. age

5.6. is_person?

5.7. foundation_year

5.8. country

5.9. website

5.10. patreon_username

5.11. description (text {searchable})

6. PUBLISHERS

6.1. country

6.2. foundation_year

6.3. website

6.4. twitter_username

6.5. name (text {searchable})

7. PLATFORMS

7.1. Es un catálogo administrado por nosotros, al usuario se le dibujan con checkboxes y esos strings se guardan en un array dentro de 'games'

8. Los GAMES se relacionan con los SUBJECTS en Neo4j por categorías: (Fez)-[Performance]-(Trixel Technology) OR (Sunset)-[Visuals]-(Calid Atmosphere)

9. LANGUAGES

9.1. Es un catálogo similar al de platforms

10. Users can register

11. Users can create games

12. Users can create developers

13. Users can create publishers

14. Create languages catalog

15. Constraint different user fields

16. Random name and bio generator for new users

17. Calificar tags con votos de usuarios

18. Sistema de confianza de usuarios (si ha puesto tags correctos, ya no depende de votación)