TABLE "public.web_member"
        COLUMN         |           TYPE           |                        Modifiers
-----------------------+--------------------------+---------------------------------------------------------
 id                    | INTEGER                  | NOT NULL DEFAULT NEXTVAL('web_member_id_seq'::regclass)
 name                  | CHARACTER VARYING(64)    | NOT NULL
 phone                 | CHARACTER VARYING(32)    | NOT NULL
 sex                   | INTEGER                  |
 preff_difficulty_from | INTEGER                  |
 preff_difficulty_to   | INTEGER                  |
 latitude              | DOUBLE PRECISION         |
 longitude             | DOUBLE PRECISION         |
 location_index        | CHARACTER(24)            | NOT NULL
 country_id            | INTEGER                  | NOT NULL DEFAULT 2
 city                  | CHARACTER VARYING(64)    | NOT NULL
 description           | text                     | NOT NULL
 user_id               | INTEGER                  | NOT NULL
 last_modified         | TIMESTAMP WITH TIME zone |
 normalized_name       | CHARACTER VARYING(64)    | NOT NULL
 date_joined           | TIMESTAMP WITH TIME zone |
Indexes:
    "web_member_pkey" PRIMARY KEY, btree (id)
    "web_member_user_id_uniq" UNIQUE CONSTRAINT, btree (user_id)
    "web_member_country_id" btree (country_id)
    "web_member_location_index" btree (location_index)
    "web_member_user_id" btree (user_id)
Foreign-KEY constraints:
    "country_id_refs_id_da95fd32a0949f0" FOREIGN KEY (country_id) REFERENCES web_country(id) DEFERRABLE INITIALLY DEFERRED
    "user_id_refs_id_197cdfaff9279c92" FOREIGN KEY (user_id) REFERENCES web_user(id) DEFERRABLE INITIALLY DEFERRED
Referenced BY:
    TABLE "web_route" CONSTRAINT "added_by_id_refs_id_157791930f5e12d5" FOREIGN KEY (added_by_id) REFERENCES web_member(id) DEFERRABLE INITIALLY DEFERRED
    TABLE "web_crag" CONSTRAINT "added_by_id_refs_id_1745ebe43b31bec6" FOREIGN KEY (added_by_id) REFERENCES web_member(id) DEFERRABLE INITIALLY DEFERRED
    TABLE "web_media" CONSTRAINT "added_by_id_refs_id_29e8560d89e8af62" FOREIGN KEY (added_by_id) REFERENCES web_member(id) DEFERRABLE INITIALLY DEFERRED
    TABLE "web_comment" CONSTRAINT "author_id_refs_id_64c699bea28c99e9" FOREIGN KEY (author_id) REFERENCES web_member(id) DEFERRABLE INITIALLY DEFERRED
    TABLE "web_media_members" CONSTRAINT "member_id_refs_id_4cc8ce6dd79993f6" FOREIGN KEY (member_id) REFERENCES web_member(id) DEFERRABLE INITIALLY DEFERRED
    TABLE "web_eventparticipant" CONSTRAINT "member_id_refs_id_6542f66c2e273db6" FOREIGN KEY (member_id) REFERENCES web_member(id) DEFERRABLE INITIALLY DEFERRED
    TABLE "web_event" CONSTRAINT "owned_by_id_refs_id_5b47892dfdc4d292" FOREIGN KEY (owned_by_id) REFERENCES web_member(id) DEFERRABLE INITIALLY DEFERRED
    TABLE "web_messagerecipient" CONSTRAINT "recipient_id_refs_id_3ea959c00c27f261" FOREIGN KEY (recipient_id) REFERENCES web_member(id) DEFERRABLE INITIALLY DEFERRED
    TABLE "web_message" CONSTRAINT "sender_id_refs_id_72ba9faa2a1c0547" FOREIGN KEY (sender_id) REFERENCES web_member(id) DEFERRABLE INITIALLY DEFERRED
Triggers:
    save_normalized_member_name AFTER INSERT OR UPDATE ON web_member FOR EACH ROW EXECUTE PROCEDURE save_normalized_member_name()
    set_member_location_index BEFORE INSERT OR UPDATE ON web_member FOR EACH ROW EXECUTE PROCEDURE set_member_location_index()



                                      TABLE "public.watson_searchentry"
     COLUMN      |          TYPE           |                            Modifiers
-----------------+-------------------------+-----------------------------------------------------------------
 id              | INTEGER                 | NOT NULL DEFAULT NEXTVAL('watson_searchentry_id_seq'::regclass)
 engine_slug     | CHARACTER VARYING(200)  | NOT NULL
 content_type_id | INTEGER                 | NOT NULL
 object_id       | text                    | NOT NULL
 object_id_int   | INTEGER                 |
 title           | CHARACTER VARYING(1000) | NOT NULL
 description     | text                    | NOT NULL
 content         | text                    | NOT NULL
 url             | CHARACTER VARYING(1000) | NOT NULL
 meta_encoded    | text                    | NOT NULL
 search_tsv      | tsvector                | NOT NULL
Indexes:
    "watson_searchentry_pkey" PRIMARY KEY, btree (id)
    "watson_searchentry_content_type_id" btree (content_type_id)
    "watson_searchentry_engine_slug" btree (engine_slug)
    "watson_searchentry_engine_slug_like" btree (engine_slug varchar_pattern_ops)
    "watson_searchentry_object_id_int" btree (object_id_int)
    "watson_searchentry_search_tsv" gin (search_tsv)
Foreign-KEY constraints:
    "content_type_id_refs_id_21a2c219b8bb212f" FOREIGN KEY (content_type_id) REFERENCES django_content_type(id) DEFERRABLE INITIALLY DEFERRED
Triggers:
    watson_searchentry_trigger BEFORE INSERT OR UPDATE ON watson_searchentry FOR EACH ROW EXECUTE PROCEDURE watson_searchentry_trigger_handler()



                                     TABLE "public.web_user"
    COLUMN     |           TYPE           |                       Modifiers
---------------+--------------------------+-------------------------------------------------------
 id            | INTEGER                  | NOT NULL DEFAULT NEXTVAL('web_user_id_seq'::regclass)
 password      | CHARACTER VARYING(128)   | NOT NULL
 last_login    | TIMESTAMP WITH TIME zone | NOT NULL
 is_superuser  | BOOLEAN                  | NOT NULL
 email         | CHARACTER VARYING(75)    | NOT NULL
 is_active     | BOOLEAN                  | NOT NULL
 is_staff      | BOOLEAN                  | NOT NULL
 date_created  | TIMESTAMP WITH TIME zone |
 last_modified | TIMESTAMP WITH TIME zone |
Indexes:
    "web_user_pkey" PRIMARY KEY, btree (id)
    "web_user_email_key" UNIQUE CONSTRAINT, btree (email)
    "web_user_email_like" btree (email varchar_pattern_ops)
Referenced BY:
    TABLE "djangoratings_similaruser" CONSTRAINT "from_user_id_refs_id_4bf6919558e6e464" FOREIGN KEY (from_user_id) REFERENCES web_user(id) DEFERRABLE INITIALLY DEFERRED
    TABLE "djangoratings_similaruser" CONSTRAINT "to_user_id_refs_id_4bf6919558e6e464" FOREIGN KEY (to_user_id) REFERENCES web_user(id) DEFERRABLE INITIALLY DEFERRED
    TABLE "web_member" CONSTRAINT "user_id_refs_id_197cdfaff9279c92" FOREIGN KEY (user_id) REFERENCES web_user(id) DEFERRABLE INITIALLY DEFERRED
    TABLE "djangoratings_ignoredobject" CONSTRAINT "user_id_refs_id_1c7310623ccfde79" FOREIGN KEY (user_id) REFERENCES web_user(id) DEFERRABLE INITIALLY DEFERRED
    TABLE "djangoratings_vote" CONSTRAINT "user_id_refs_id_332b4e96bf1fa6c7" FOREIGN KEY (user_id) REFERENCES web_user(id) DEFERRABLE INITIALLY DEFERRED
    TABLE "web_user_groups" CONSTRAINT "user_id_refs_id_3995dbc0686a6e33" FOREIGN KEY (user_id) REFERENCES web_user(id) DEFERRABLE INITIALLY DEFERRED
    TABLE "web_user_user_permissions" CONSTRAINT "user_id_refs_id_69b47a84ab5eab1f" FOREIGN KEY (user_id) REFERENCES web_user(id) DEFERRABLE INITIALLY DEFERRED



                                     TABLE "public.web_country"
    COLUMN     |           TYPE           |                        Modifiers
---------------+--------------------------+----------------------------------------------------------
 id            | INTEGER                  | NOT NULL DEFAULT NEXTVAL('web_country_id_seq'::regclass)
 name          | CHARACTER VARYING(64)    | NOT NULL
 code          | CHARACTER VARYING(2)     | NOT NULL
 date_created  | TIMESTAMP WITH TIME zone |
 last_modified | TIMESTAMP WITH TIME zone |
Indexes:
    "web_country_pkey" PRIMARY KEY, btree (id)
    "web_country_name" btree (name)
Referenced BY:
    TABLE "web_crag" CONSTRAINT "country_id_refs_id_1384050a9bd763af" FOREIGN KEY (country_id) REFERENCES web_country(id) DEFERRABLE INITIALLY DEFERRED
    TABLE "web_city" CONSTRAINT "country_id_refs_id_55d3b49fd200671" FOREIGN KEY (country_id) REFERENCES web_country(id) DEFERRABLE INITIALLY DEFERRED
    TABLE "web_event" CONSTRAINT "country_id_refs_id_5f487906379304d7" FOREIGN KEY (country_id) REFERENCES web_country(id) DEFERRABLE INITIALLY DEFERRED
    TABLE "web_eventdestination" CONSTRAINT "country_id_refs_id_a7787a11041d874" FOREIGN KEY (country_id) REFERENCES web_country(id) DEFERRABLE INITIALLY DEFERRED
    TABLE "web_member" CONSTRAINT "country_id_refs_id_da95fd32a0949f0" FOREIGN KEY (country_id) REFERENCES web_country(id) DEFERRABLE INITIALLY DEFERRED