UFE Database

Começar. É Gratuito
ou inscrever-se com seu endereço de e-mail
Rocket clouds
UFE Database por Mind Map: UFE Database

1. tbUsers

1.1. idUser (key)

1.2. username (char)

1.3. passHash (hash)

1.4. salt (char)

1.5. email (char)

1.6. validEmail (bool)

1.7. firstName (char/null)

1.8. lastName (char/null)

1.9. companyName (char/null)

1.10. description (long)

1.11. isDeveloper (bool)

1.12. karma (int)

1.13. registerDate (date)

1.14. loginDate (date)

1.15. lastIP (char)

1.16. plan (char/null)

1.17. userLimit (int)

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

2. tbGames

2.1. idGame (key)

2.2. idGameManager (int)

2.3. title (char)

2.4. shortDescription (char)

2.5. longDescription (long)

2.6. userLimit (int)

2.7. listed (bool)

2.8. hasRating (bool)

2.9. averageRating (int)

2.10. votersMustBeRegistered (bool)

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

3. tbGameManagers

3.1. idGameManager (key)

3.2. idUser (int)

3.3. idGame (int)

3.4. idManagerRank (int)

4. tbManagerRanks

4.1. idManagerRank (key)

4.2. title (char)

4.3. rank (int)

5. tbScoreNames

5.1. idScore (key)

5.2. idGame (int)

5.3. scoreName (char)

5.4. isDouble (bool)

5.5. defaultOrder (char)

6. tbHighScores

6.1. idHighScore (key)

6.2. idUser (int)

6.3. idScore (int)

6.4. score (double)

7. tbComments (optional)

8. tbSubscriptions

8.1. idSubscription (key)

8.2. idUser (int)

8.3. idSale (int)

8.4. plan (char)

8.5. expirationDate (date)

9. tbSales

9.1. idSale (key)

9.2. idUser (int)

9.3. paymentMethod (char)

9.4. gross (double)

9.5. gain (double)

9.6. externalId (char)

10. tbRatingVotes

10.1. idRatingVote (key)

10.2. idGame (int)

10.3. idUser (int/null)

10.4. rating (int)

10.5. ip (char)