wiki:PlayerId/DatabaseLayout
Last modified 3 months ago

  1. Clan
    1. Clan User
      1. Clan User Status
  2. Country
    1. Country Thread
  3. Event
  4. Feedback
  5. Feedback Type
  6. Gallery
    1. Gallery Picture
    2. Gallery Video
    3. Gallery Game
    4. Gallery Thread
  7. Game
    1. Game Thread
    2. Game Version
      1. Game Version Attribute
      2. Game Version Legalperson
      3. Game Version License
    3. Game Attribute
  8. Legalperson
    1. Legalperson Thread
  9. License
    1. License Thread
  10. Location
  11. Picture
    1. Picture Location
    2. Picture User Rating
  12. Rating
  13. Thread
    1. Thread Post
    2. Thread Post Feedback
  14. URL
    1. URL Game
    2. URL Feedback
  15. User
    1. User Location
      1. User Location Status
    2. User Game
    3. User Profile
      1. User Profile Attribute
    4. User URL
  16. Video
    1. Video Thread
    2. Video Game
    3. Video User Rating
    4. Video Youtube
  17. Type Definitions

Clan

  • Name (text)
  • Description (textarea, loc)
  • Webpage (text)

Clan User

  • Clan (ref)
  • User (ref)
  • Clan User Status (ref)

Clan User Status

  • Name (text, loc)
  • Description (textarea, loc)

Country

  • Name (text, loc)
  • Code2 (text)

Country Thread

  • Country (ref)
  • Thread (ref)

Event

  • TODO

Feedback

  • User (ref)
  • Feedback Type (ref)

Feedback Type

  • Name (text, loc)
  • Description (textarea, loc)

Gallery

  • Name (text, loc)
  • Description (textarea, loc)

Gallery Picture

  • Gallery (ref)
  • Picture (ref)

Gallery Video

  • Video (ref)
  • Gallery (ref)

Gallery Game

  • Gallery (ref)
  • Game (ref)

Gallery Thread

  • Gallery (ref)
  • Thread (ref)

Game

  • Name (text, loc)
  • Description (textarea, loc)
  • Webpage (text)

Game Thread

  • Game (ref)
  • Thread (ref)

Game Version

  • Game (ref)
  • Version (text)
  • Download (text)
  • Release Date (date)
  • Legalperson (ref)
  • Forked Of Game Version (ref)

Game Version Attribute

  • Game Version (ref)
  • Game Attribute (ref)
  • Value (textarea)

Game Version Legalperson

  • Game Version (ref)
  • Legalperson (ref)
  • Files (textarea)

Game Version License

  • Game Version (ref)
  • License (ref)
  • Name (text, loc)
  • Files (textarea)

Game Attribute

  • Name (text, loc)
  • Description (textarea, loc)

Legalperson

  • Name (text)
  • Personal (bool)
  • Description (textarea, loc)
  • Webpage (text)

Legalperson Thread

  • Legalperson (ref)
  • Thread (ref)

License

  • Name (text)
  • Description (textarea, loc)
  • Webpage (text, loc)
  • Free (bool) (== No payment required to play)
  • OpenSource (bool) (== Sourcecode free to download)
  • Forkable (bool) (== Can be copied and modified and rereleased)

License Thread

  • License (ref)
  • Thread (ref)

Location

  • Position (latlng)
  • Name (text, loc)
  • Description (text, loc)
  • Created (datetime)

Picture

  • User (ref)
  • Filename (text)
  • Name (text, loc)
  • Description (textarea, loc)
  • Created (datetime)

Picture Location

  • Picture (ref)
  • Location (ref)

Picture User Rating

  • Picture (ref)
  • User (ref)
  • Rating (ref)

Rating

  • Value (posint) (1-5 ?)
  • Comment (textarea)

Thread

  • Name (text)
  • Description (text)
  • User (ref)
  • Created (datetime)

Thread Post

  • Thread (ref)
  • Name (text)
  • Description (text)
  • User (ref)
  • Created (datetime)

Thread Post Feedback

  • Thread Post (ref)
  • Feedback (ref)

URL

  • Name (text) (the url)
  • Description (text, loc)
  • Created (datetime)

URL Game

  • URL (ref)
  • Game (ref)

URL Feedback

  • URL (ref)
  • Feedback (ref)

User

  • Username (text)
  • Password_* (several text) (md5,sha1)
  • Country (ref)
  • Email (email)

User Location

  • User (ref)
  • Location (ref)
  • User Location Status (ref)

User Location Status

  • Name (text, loc)

User Game

  • User (ref)
  • Game (ref)
  • Playing (bool)
  • Rating (ref)

User Profile

  • User (ref)
  • User Profile Attribute (ref)
  • Value (textarea)

User Profile Attribute

  • Name (text, loc)
  • Description (textarea, loc)
  • User (ref) (for new private attributes)

User URL

  • URL (ref)
  • User (ref)

Video

  • User (ref)
  • Location Type (posint) (= Youtube, ...)
  • Name (text, loc)
  • Description (textarea, loc)
  • Created (datetime)

Video Thread

  • Video (ref)
  • Thread (ref)

Video Game

  • Video (ref)
  • Game (ref)

Video User Rating

  • Video (ref)
  • User (ref)
  • Rating (ref)

Video Youtube

  • Video (ref)
  • YoutubeID (text)

Type Definitions

  • ref = Reference to other table
  • text = input type=text
  • textarea = textarea
  • loc = localizable
  • posint = Positive Integer
  • bool = true/false
  • date = Date
  • datetime = Date + Time
  • latlng = TODO (define position on world)