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
*	email	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)