Table client_applications | |||
---|---|---|---|
* | id | serial | |
name | varchar( 255 ) | ||
url | varchar( 255 ) | ||
support_url | varchar( 255 ) | ||
callback_url | varchar( 255 ) | ||
key | varchar( 50 ) | ||
secret | varchar( 50 ) | ||
user_id | integer | ||
created_at | timestamp | ||
updated_at | timestamp | ||
* | allow_read_prefs | bool DEFO false | |
* | allow_write_prefs | bool DEFO false | |
* | allow_write_diary | bool DEFO false | |
* | allow_write_api | bool DEFO false | |
* | allow_read_gpx | bool DEFO false | |
* | allow_write_gpx | bool DEFO false | |
* | allow_write_notes | bool DEFO false | |
Indexes | |||
Pk | client_applications_pkey | ON id | |
U | index_client_applications_on_key | ON key | |
Foreign Keys | |||
client_applications_user_id_fkey | ( user_id ) ref users (id) |
Table current_node_tags | |||
---|---|---|---|
* | node_id | bigint | |
* | k | varchar( 255 ) DEFO ''::character varying | |
* | v | varchar( 255 ) DEFO ''::character varying | |
Indexes | |||
Pk | current_node_tags_pkey | ON node_id, k | |
Foreign Keys | |||
current_node_tags_id_fkey | ( node_id ) ref current_nodes (id) |
Table current_nodes | |||
---|---|---|---|
* | id | bigserial | |
* | latitude | integer | |
* | longitude | integer | |
* | changeset_id | bigint | |
* | visible | bool | |
* | timestamp | timestamp | |
* | tile | bigint | |
* | version | bigint | |
Indexes | |||
Pk | current_nodes_pkey1 | ON id | |
current_nodes_tile_idx | ON tile | ||
current_nodes_timestamp_idx | ON timestamp | ||
Foreign Keys | |||
current_nodes_changeset_id_fkey | ( changeset_id ) ref changesets (id) |
Table current_relation_members | |||
---|---|---|---|
* | relation_id | bigint | |
* | member_type | nwr_enum | |
* | member_id | bigint | |
* | member_role | varchar( 255 ) | |
* | sequence_id | integer DEFO 0 | |
Indexes | |||
Pk | current_relation_members_pkey | ON relation_id, member_type, member_id, member_role, sequence_id | |
current_relation_members_member_idx | ON member_type, member_id | ||
Foreign Keys | |||
current_relation_members_id_fkey | ( relation_id ) ref current_relations (id) |
Table current_relations | |||
---|---|---|---|
* | id | bigserial | |
* | changeset_id | bigint | |
* | timestamp | timestamp | |
* | visible | bool | |
* | version | bigint | |
Indexes | |||
Pk | current_relations_pkey | ON id | |
current_relations_timestamp_idx | ON timestamp | ||
Foreign Keys | |||
current_relations_changeset_id_fkey | ( changeset_id ) ref changesets (id) |
Table current_way_nodes | |||
---|---|---|---|
* | way_id | bigint | |
* | sequence_id | bigint | |
* | node_id | bigint | |
Indexes | |||
Pk | current_way_nodes_pkey | ON way_id, sequence_id | |
current_way_nodes_node_idx | ON node_id | ||
Foreign Keys | |||
current_way_nodes_node_id_fkey | ( node_id ) ref current_nodes (id) | ||
current_way_nodes_id_fkey | ( way_id ) ref current_ways (id) |
Table current_way_tags | |||
---|---|---|---|
* | way_id | bigint | |
* | k | varchar( 255 ) DEFO ''::character varying | |
* | v | varchar( 255 ) DEFO ''::character varying | |
Indexes | |||
Pk | current_way_tags_pkey | ON way_id, k | |
Foreign Keys | |||
current_way_tags_id_fkey | ( way_id ) ref current_ways (id) |
Table current_ways | |||
---|---|---|---|
* | id | bigserial | |
* | changeset_id | bigint | |
* | timestamp | timestamp | |
* | visible | bool | |
* | version | bigint | |
Indexes | |||
Pk | current_ways_pkey | ON id | |
current_ways_timestamp_idx | ON timestamp | ||
Foreign Keys | |||
current_ways_changeset_id_fkey | ( changeset_id ) ref changesets (id) |
Table diary_comments | |||
---|---|---|---|
* | id | bigserial | |
* | diary_entry_id | bigint | |
* | user_id | bigint | |
* | body | text | |
* | created_at | timestamp | |
* | updated_at | timestamp | |
* | visible | bool DEFO true | |
* | body_format | format_enum DEFO 'html'::format_enum | |
Indexes | |||
Pk | diary_comments_pkey | ON id | |
U | diary_comments_entry_id_idx | ON diary_entry_id, id | |
diary_comment_user_id_created_at_index | ON user_id, created_at | ||
Foreign Keys | |||
diary_comments_diary_entry_id_fkey | ( diary_entry_id ) ref diary_entries (id) | ||
diary_comments_user_id_fkey | ( user_id ) ref users (id) |
Table diary_entries | |||
---|---|---|---|
* | id | bigserial | |
* | user_id | bigint | |
* | title | varchar( 255 ) | |
* | body | text | |
* | created_at | timestamp | |
* | updated_at | timestamp | |
latitude | float8 | ||
longitude | float8 | ||
* | language_code | varchar( 255 ) DEFO 'en'::character varying | |
* | visible | bool DEFO true | |
* | body_format | format_enum DEFO 'html'::format_enum | |
Indexes | |||
Pk | diary_entries_pkey | ON id | |
diary_entry_created_at_index | ON created_at | ||
diary_entry_language_code_created_at_index | ON language_code, created_at | ||
diary_entry_user_id_created_at_index | ON user_id, created_at | ||
Foreign Keys | |||
diary_entries_language_code_fkey | ( language_code ) ref languages (code) | ||
diary_entries_user_id_fkey | ( user_id ) ref users (id) |
Table friends | |||
---|---|---|---|
* | id | bigserial | |
* | user_id | bigint | |
* | friend_user_id | bigint | |
Indexes | |||
Pk | friends_pkey | ON id | |
friends_user_id_idx | ON user_id | ||
user_id_idx | ON friend_user_id | ||
Foreign Keys | |||
friends_friend_user_id_fkey | ( friend_user_id ) ref users (id) | ||
friends_user_id_fkey | ( user_id ) ref users (id) |
Table gps_points | |||
---|---|---|---|
altitude | float8 | ||
* | trackid | integer | |
* | latitude | integer | |
* | longitude | integer | |
* | gpx_id | bigint | |
timestamp | timestamp | ||
tile | bigint | ||
Indexes | |||
points_gpxid_idx | ON gpx_id | ||
points_tile_idx | ON tile | ||
Foreign Keys | |||
gps_points_gpx_id_fkey | ( gpx_id ) ref gpx_files (id) |
Table gpx_file_tags | |||
---|---|---|---|
* | id | bigserial | |
* | gpx_id | bigint DEFO 0 | |
* | tag | varchar( 255 ) | |
Indexes | |||
Pk | gpx_file_tags_pkey | ON id | |
gpx_file_tags_gpxid_idx | ON gpx_id | ||
gpx_file_tags_tag_idx | ON tag | ||
Foreign Keys | |||
gpx_file_tags_gpx_id_fkey | ( gpx_id ) ref gpx_files (id) |
Table gpx_files | |||
---|---|---|---|
* | id | bigserial | |
* | user_id | bigint | |
* | visible | bool DEFO true | |
* | name | varchar( 255 ) DEFO ''::character varying | |
size | bigint | ||
latitude | float8 | ||
longitude | float8 | ||
* | timestamp | timestamp | |
* | description | varchar( 255 ) DEFO ''::character varying | |
* | inserted | bool | |
* | visibility | gpx_visibility_enum DEFO 'public'::gpx_visibility_enum | |
Indexes | |||
Pk | gpx_files_pkey | ON id | |
gpx_files_timestamp_idx | ON timestamp | ||
gpx_files_user_id_idx | ON user_id | ||
gpx_files_visible_visibility_idx | ON visible, visibility | ||
Foreign Keys | |||
gpx_files_user_id_fkey | ( user_id ) ref users (id) |
Table languages | |||
---|---|---|---|
* | code | varchar( 255 ) | |
* | english_name | varchar( 255 ) | |
native_name | varchar( 255 ) | ||
Indexes | |||
Pk | languages_pkey | ON code |
Table messages | |||
---|---|---|---|
* | id | bigserial | |
* | from_user_id | bigint | |
* | title | varchar( 255 ) | |
* | body | text | |
* | sent_on | timestamp | |
* | message_read | bool DEFO false | |
* | to_user_id | bigint | |
* | to_user_visible | bool DEFO true | |
* | from_user_visible | bool DEFO true | |
* | body_format | format_enum DEFO 'html'::format_enum | |
Indexes | |||
Pk | messages_pkey | ON id | |
messages_from_user_id_idx | ON from_user_id | ||
messages_to_user_id_idx | ON to_user_id | ||
Foreign Keys | |||
messages_from_user_id_fkey | ( from_user_id ) ref users (id) | ||
messages_to_user_id_fkey | ( to_user_id ) ref users (id) |
Table node_tags | |||
---|---|---|---|
* | node_id | bigint | |
* | version | bigint | |
* | k | varchar( 255 ) DEFO ''::character varying | |
* | v | varchar( 255 ) DEFO ''::character varying | |
Indexes | |||
Pk | node_tags_pkey | ON node_id, version, k | |
Foreign Keys | |||
node_tags_id_fkey | ( node_id, version ) ref nodes (node_id, version) |
Table nodes | |||
---|---|---|---|
* | node_id | bigint | |
* | version | bigint | |
* | latitude | integer | |
* | longitude | integer | |
* | changeset_id | bigint | |
* | visible | bool | |
* | timestamp | timestamp | |
* | tile | bigint | |
redaction_id | integer | ||
Indexes | |||
Pk | nodes_pkey | ON node_id, version | |
nodes_changeset_id_idx | ON changeset_id | ||
nodes_tile_idx | ON tile | ||
nodes_timestamp_idx | ON timestamp | ||
Foreign Keys | |||
nodes_changeset_id_fkey | ( changeset_id ) ref changesets (id) | ||
nodes_redaction_id_fkey | ( redaction_id ) ref redactions (id) |
Table note_comments | |||
---|---|---|---|
* | id | bigserial | |
* | note_id | bigint | |
* | visible | bool | |
* | created_at | timestamp | |
author_ip | inet | ||
author_id | bigint | ||
body | text | ||
event | note_event_enum | ||
Indexes | |||
Pk | note_comments_pkey | ON id | |
index_note_comments_on_created_at | ON created_at | ||
note_comments_note_id_idx | ON note_id | ||
Foreign Keys | |||
note_comments_note_id_fkey | ( note_id ) ref notes (id) | ||
note_comments_author_id_fkey | ( author_id ) ref users (id) |
Table notes | |||
---|---|---|---|
* | id | bigserial | |
* | latitude | integer | |
* | longitude | integer | |
* | tile | bigint | |
* | updated_at | timestamp | |
* | created_at | timestamp | |
* | status | note_status_enum | |
closed_at | timestamp | ||
Indexes | |||
Pk | notes_pkey | ON id | |
notes_created_at_idx | ON created_at | ||
notes_tile_status_idx | ON tile, status | ||
notes_updated_at_idx | ON updated_at |
Table relation_members | |||
---|---|---|---|
* | relation_id | bigint DEFO 0 | |
* | version | bigint DEFO 0 | |
* | member_type | nwr_enum | |
* | member_id | bigint | |
* | member_role | varchar( 255 ) | |
* | sequence_id | integer DEFO 0 | |
Indexes | |||
Pk | relation_members_pkey | ON relation_id, version, member_type, member_id, member_role, sequence_id | |
relation_members_member_idx | ON member_type, member_id | ||
Foreign Keys | |||
relation_members_id_fkey | ( relation_id, version ) ref relations (relation_id, version) |
Table relation_tags | |||
---|---|---|---|
* | relation_id | bigint DEFO 0 | |
* | version | bigint | |
* | k | varchar( 255 ) DEFO ''::character varying | |
* | v | varchar( 255 ) DEFO ''::character varying | |
Indexes | |||
Pk | relation_tags_pkey | ON relation_id, version, k | |
Foreign Keys | |||
relation_tags_id_fkey | ( relation_id, version ) ref relations (relation_id, version) |
Table relations | |||
---|---|---|---|
* | relation_id | bigint DEFO 0 | |
* | version | bigint | |
* | changeset_id | bigint | |
* | timestamp | timestamp | |
* | visible | bool DEFO true | |
redaction_id | integer | ||
Indexes | |||
Pk | relations_pkey | ON relation_id, version | |
relations_changeset_id_idx | ON changeset_id | ||
relations_timestamp_idx | ON timestamp | ||
Foreign Keys | |||
relations_changeset_id_fkey | ( changeset_id ) ref changesets (id) | ||
relations_redaction_id_fkey | ( redaction_id ) ref redactions (id) |
Table schema_migrations | |||
---|---|---|---|
* | version | varchar( 255 ) | |
Indexes | |||
U | unique_schema_migrations | ON version |
Table user_preferences | |||
---|---|---|---|
* | user_id | bigint | |
* | k | varchar( 255 ) | |
* | v | varchar( 255 ) | |
Indexes | |||
Pk | user_preferences_pkey | ON user_id, k | |
Foreign Keys | |||
user_preferences_user_id_fkey | ( user_id ) ref users (id) |
Table user_tokens | |||
---|---|---|---|
* | id | bigserial | |
* | user_id | bigint | |
* | token | varchar( 255 ) | |
* | expiry | timestamp | |
referer | text | ||
Indexes | |||
Pk | user_tokens_pkey | ON id | |
U | user_tokens_token_idx | ON token | |
user_tokens_user_id_idx | ON user_id | ||
Foreign Keys | |||
user_tokens_user_id_fkey | ( user_id ) ref users (id) |
Table way_tags | |||
---|---|---|---|
* | way_id | bigint DEFO 0 | |
* | version | bigint | |
* | k | varchar( 255 ) | |
* | v | varchar( 255 ) | |
Indexes | |||
Pk | way_tags_pkey | ON way_id, version, k | |
Foreign Keys | |||
way_tags_id_fkey | ( way_id, version ) ref ways (way_id, version) |
Table user_roles | |||
---|---|---|---|
* | id | serial | |
* | user_id | bigint | |
created_at | timestamp | ||
updated_at | timestamp | ||
* | role | user_role_enum | |
* | granter_id | bigint | |
Indexes | |||
Pk | user_roles_pkey | ON id | |
U | user_roles_id_role_unique | ON user_id, role | |
Foreign Keys | |||
user_roles_granter_id_fkey | ( granter_id ) ref users (id) | ||
user_roles_user_id_fkey | ( user_id ) ref users (id) |
Table user_blocks | |||
---|---|---|---|
* | id | serial | |
* | user_id | bigint | |
* | creator_id | bigint | |
* | reason | text | |
* | ends_at | timestamp | |
* | needs_view | bool DEFO false | |
revoker_id | bigint | ||
created_at | timestamp | ||
updated_at | timestamp | ||
* | reason_format | format_enum DEFO 'html'::format_enum | |
Indexes | |||
Pk | user_blocks_pkey | ON id | |
index_user_blocks_on_user_id | ON user_id | ||
Foreign Keys | |||
user_blocks_moderator_id_fkey | ( creator_id ) ref users (id) | ||
user_blocks_revoker_id_fkey | ( revoker_id ) ref users (id) | ||
user_blocks_user_id_fkey | ( user_id ) ref users (id) |
Table acls | |||
---|---|---|---|
* | id | serial | |
address | inet | ||
* | k | varchar( 255 ) | |
v | varchar( 255 ) | ||
domain | varchar( 255 ) | ||
Indexes | |||
Pk | acls_pkey | ON id | |
acls_k_idx | ON k |
Table way_nodes | |||
---|---|---|---|
* | way_id | bigint | |
* | version | bigint | |
* | sequence_id | bigint | |
* | node_id | bigint | |
Indexes | |||
Pk | way_nodes_pkey | ON way_id, version, sequence_id | |
way_nodes_node_idx | ON node_id | ||
Foreign Keys | |||
way_nodes_id_fkey | ( way_id, version ) ref ways (way_id, version) |
Table oauth_nonces | |||
---|---|---|---|
* | id | serial | |
nonce | varchar( 255 ) | ||
timestamp | integer | ||
created_at | timestamp | ||
updated_at | timestamp | ||
Indexes | |||
Pk | oauth_nonces_pkey | ON id | |
U | index_oauth_nonces_on_nonce_and_timestamp | ON nonce, timestamp |
Table changesets | |||
---|---|---|---|
* | id | bigserial | |
* | user_id | bigint | |
* | created_at | timestamp | |
min_lat | integer | ||
max_lat | integer | ||
min_lon | integer | ||
max_lon | integer | ||
* | closed_at | timestamp | |
* | num_changes | integer DEFO 0 | |
Indexes | |||
Pk | changesets_pkey | ON id | |
changesets_bbox_idx | ON min_lat, max_lat, min_lon, max_lon | ||
changesets_closed_at_idx | ON closed_at | ||
changesets_created_at_idx | ON created_at | ||
changesets_user_id_created_at_idx | ON user_id, created_at | ||
changesets_user_id_id_idx | ON user_id, id | ||
Foreign Keys | |||
changesets_user_id_fkey | ( user_id ) ref users (id) |
Table changeset_tags | |||
---|---|---|---|
* | changeset_id | bigint | |
* | k | varchar( 255 ) DEFO ''::character varying | |
* | v | varchar( 255 ) DEFO ''::character varying | |
Indexes | |||
changeset_tags_id_idx | ON changeset_id | ||
Foreign Keys | |||
changeset_tags_id_fkey | ( changeset_id ) ref changesets (id) |
Table redactions | |||
---|---|---|---|
* | id | serial | |
title | varchar( 255 ) | ||
description | text | ||
created_at | timestamp | ||
updated_at | timestamp | ||
* | user_id | bigint | |
* | description_format | format_enum DEFO 'markdown'::format_enum | |
Indexes | |||
Pk | redactions_pkey | ON id | |
Foreign Keys | |||
redactions_user_id_fkey | ( user_id ) ref users (id) |
Table users | |||
---|---|---|---|
* | id | bigserial | |
* | varchar( 255 ) | ||
* | pass_crypt | varchar( 255 ) | |
* | creation_time | timestamp | |
* | display_name | varchar( 255 ) DEFO ''::character varying | |
* | data_public | bool DEFO false | |
* | description | text DEFO ''::text | |
home_lat | float8 | ||
home_lon | float8 | ||
home_zoom | smallint DEFO 3 | ||
nearby | integer DEFO 50 | ||
pass_salt | varchar( 255 ) | ||
image_file_name | text | ||
* | email_valid | bool DEFO false | |
new_email | varchar( 255 ) | ||
creation_ip | varchar( 255 ) | ||
languages | varchar( 255 ) | ||
* | status | user_status_enum DEFO 'pending'::user_status_enum | |
terms_agreed | timestamp | ||
* | consider_pd | bool DEFO false | |
openid_url | varchar( 255 ) | ||
preferred_editor | varchar( 255 ) | ||
* | terms_seen | bool DEFO false | |
* | description_format | format_enum DEFO 'html'::format_enum | |
image_fingerprint | varchar( 255 ) | ||
* | changesets_count | integer DEFO 0 | |
* | traces_count | integer DEFO 0 | |
* | diary_entries_count | integer DEFO 0 | |
* | image_use_gravatar | bool DEFO true | |
image_content_type | varchar( 255 ) | ||
Indexes | |||
Pk | users_pkey | ON id | |
U | user_openid_url_idx | ON openid_url | |
U | users_display_name_idx | ON display_name | |
U | users_email_idx | ON email |
Table oauth_tokens | |||
---|---|---|---|
* | id | serial | |
user_id | integer | ||
type | varchar( 20 ) | ||
client_application_id | integer | ||
token | varchar( 50 ) | ||
secret | varchar( 50 ) | ||
authorized_at | timestamp | ||
invalidated_at | timestamp | ||
created_at | timestamp | ||
updated_at | timestamp | ||
* | allow_read_prefs | bool DEFO false | |
* | allow_write_prefs | bool DEFO false | |
* | allow_write_diary | bool DEFO false | |
* | allow_write_api | bool DEFO false | |
* | allow_read_gpx | bool DEFO false | |
* | allow_write_gpx | bool DEFO false | |
callback_url | varchar( 255 ) | ||
verifier | varchar( 20 ) | ||
scope | varchar( 255 ) | ||
valid_to | timestamp | ||
* | allow_write_notes | bool DEFO false | |
Indexes | |||
Pk | oauth_tokens_pkey | ON id | |
U | index_oauth_tokens_on_token | ON token | |
Foreign Keys | |||
oauth_tokens_client_application_id_fkey | ( client_application_id ) ref client_applications (id) | ||
oauth_tokens_user_id_fkey | ( user_id ) ref users (id) |
Table current_relation_tags | |||
---|---|---|---|
* | relation_id | bigint | |
* | k | varchar( 255 ) DEFO ''::character varying | |
* | v | varchar( 255 ) DEFO ''::character varying | |
Indexes | |||
Pk | current_relation_tags_pkey | ON relation_id, k | |
Foreign Keys | |||
current_relation_tags_id_fkey | ( relation_id ) ref current_relations (id) |
Table ways | |||
---|---|---|---|
* | way_id | bigint DEFO 0 | |
* | version | bigint | |
* | changeset_id | bigint | |
* | timestamp | timestamp | |
* | visible | bool DEFO true | |
redaction_id | integer | ||
Indexes | |||
Pk | ways_pkey | ON way_id, version | |
ways_changeset_id_idx | ON changeset_id | ||
ways_timestamp_idx | ON timestamp | ||
Foreign Keys | |||
ways_changeset_id_fkey | ( changeset_id ) ref changesets (id) | ||
ways_redaction_id_fkey | ( redaction_id ) ref redactions (id) |