Database structure

Currently, the only supported database is SQLite. The schema is defined in this file.

The following tables are being used:

• comments table contains comments added to trees.
• files table is where information on uploaded images is kept.
• osm_trees table keeps a copy of related nodes from OSM.
• queue_messages table keeps messages for background data processing.
• species table contains data on tree species, used for autocomplete.
• trees table is where the latest version of all trees is kept.
• trees_props table is where changes to individual properties are logged.
• upload_tickets table stores temporary information on upload requests.
• users table stores information on all user accounts.