Ararea
by Zura Guerra
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)