UFE Database

1. tbGameManagers

1.1. idGameManager (key)

1.2. idUser (int)

1.3. idGame (int)

1.4. idManagerRank (int)

2. tbManagerRanks

2.1. idManagerRank (key)

2.2. title (char)

2.3. rank (int)

3. tbScoreNames

3.1. idScore (key)

3.2. idGame (int)

3.3. scoreName (char)

3.4. isDouble (bool)

3.5. defaultOrder (char)

4. tbHighScores

4.1. idHighScore (key)

4.2. idUser (int)

4.3. idScore (int)

4.4. score (double)

5. tbComments (optional)

6. tbSales

6.1. idSale (key)

6.2. idUser (int)

6.3. paymentMethod (char)

6.4. gross (double)

6.5. gain (double)

6.6. externalId (char)

7. tbUsers

7.1. idUser (key)

7.2. username (char)

7.3. passHash (hash)

7.4. salt (char)

7.5. email (char)

7.6. validEmail (bool)

7.7. firstName (char/null)

7.8. lastName (char/null)

7.9. companyName (char/null)

7.10. description (long)

7.11. isDeveloper (bool)

7.12. karma (int)

7.13. registerDate (date)

7.14. loginDate (date)

7.15. lastIP (char)

7.16. plan (char/null)

7.17. userLimit (int)

7.18. (optional) thumbnail (alternatively, picture can be renamed into id.jpg)

8. tbGames

8.1. idGame (key)

8.2. idGameManager (int)

8.3. title (char)

8.4. shortDescription (char)

8.5. longDescription (long)

8.6. userLimit (int)

8.7. listed (bool)

8.8. hasRating (bool)

8.9. averageRating (int)

8.10. votersMustBeRegistered (bool)

8.11. (optional) thumbnails 1 and 2 (alternatively, picture can be renamed into id.jpg)

9. tbSubscriptions

9.1. idSubscription (key)

9.2. idUser (int)

9.3. idSale (int)

9.4. plan (char)

9.5. expirationDate (date)

10. tbRatingVotes

10.1. idRatingVote (key)

10.2. idGame (int)

10.3. idUser (int/null)

10.4. rating (int)

10.5. ip (char)