web_member + watson_searchentry

                                         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()