API tools faq
paste
View difference between Paste ID: 3tRVPPVi and CUiadtXN
SHOW: | | - or go back to the newest paste.
1
                                         Table "public.web_member"
2
        Column         |           Type           |                        Modifiers
3
-----------------------+--------------------------+---------------------------------------------------------
4
 id                    | integer                  | not null default nextval('web_member_id_seq'::regclass)
5
 name                  | character varying(64)    | not null
6
 phone                 | character varying(32)    | not null
7
 sex                   | integer                  |
8
 preff_difficulty_from | integer                  |
9
 preff_difficulty_to   | integer                  |
10
 latitude              | double precision         |
11
 longitude             | double precision         |
12
 location_index        | character(24)            | not null
13
 country_id            | integer                  | not null default 2
14
 city                  | character varying(64)    | not null
15
 description           | text                     | not null
16
 user_id               | integer                  | not null
17
 last_modified         | timestamp with time zone |
18
 normalized_name       | character varying(64)    | not null
19
 date_joined           | timestamp with time zone |
20
Indexes:
21
    "web_member_pkey" PRIMARY KEY, btree (id)
22
    "web_member_user_id_uniq" UNIQUE CONSTRAINT, btree (user_id)
23
    "web_member_country_id" btree (country_id)
24
    "web_member_location_index" btree (location_index)
25
    "web_member_user_id" btree (user_id)
26
Foreign-key constraints:
27
    "country_id_refs_id_da95fd32a0949f0" FOREIGN KEY (country_id) REFERENCES web_country(id) DEFERRABLE INITIALLY DEFERRED
28
    "user_id_refs_id_197cdfaff9279c92" FOREIGN KEY (user_id) REFERENCES web_user(id) DEFERRABLE INITIALLY DEFERRED
29
Referenced by:
30
    TABLE "web_route" CONSTRAINT "added_by_id_refs_id_157791930f5e12d5" FOREIGN KEY (added_by_id) REFERENCES web_member(id) DEFERRABLE INITIALLY DEFERRED
31
    TABLE "web_crag" CONSTRAINT "added_by_id_refs_id_1745ebe43b31bec6" FOREIGN KEY (added_by_id) REFERENCES web_member(id) DEFERRABLE INITIALLY DEFERRED
32
    TABLE "web_media" CONSTRAINT "added_by_id_refs_id_29e8560d89e8af62" FOREIGN KEY (added_by_id) REFERENCES web_member(id) DEFERRABLE INITIALLY DEFERRED
33
    TABLE "web_comment" CONSTRAINT "author_id_refs_id_64c699bea28c99e9" FOREIGN KEY (author_id) REFERENCES web_member(id) DEFERRABLE INITIALLY DEFERRED
34
    TABLE "web_media_members" CONSTRAINT "member_id_refs_id_4cc8ce6dd79993f6" FOREIGN KEY (member_id) REFERENCES web_member(id) DEFERRABLE INITIALLY DEFERRED
35
    TABLE "web_eventparticipant" CONSTRAINT "member_id_refs_id_6542f66c2e273db6" FOREIGN KEY (member_id) REFERENCES web_member(id) DEFERRABLE INITIALLY DEFERRED
36
    TABLE "web_event" CONSTRAINT "owned_by_id_refs_id_5b47892dfdc4d292" FOREIGN KEY (owned_by_id) REFERENCES web_member(id) DEFERRABLE INITIALLY DEFERRED
37
    TABLE "web_messagerecipient" CONSTRAINT "recipient_id_refs_id_3ea959c00c27f261" FOREIGN KEY (recipient_id) REFERENCES web_member(id) DEFERRABLE INITIALLY DEFERRED
38
    TABLE "web_message" CONSTRAINT "sender_id_refs_id_72ba9faa2a1c0547" FOREIGN KEY (sender_id) REFERENCES web_member(id) DEFERRABLE INITIALLY DEFERRED
39
Triggers:
40
    save_normalized_member_name AFTER INSERT OR UPDATE ON web_member FOR EACH ROW EXECUTE PROCEDURE save_normalized_member_name()
41
    set_member_location_index BEFORE INSERT OR UPDATE ON web_member FOR EACH ROW EXECUTE PROCEDURE set_member_location_index()
42
43
44
45
                                      Table "public.watson_searchentry"

46
     Column      |          Type           |                            Modifiers                            

47
-----------------+-------------------------+-----------------------------------------------------------------

48
 id              | integer                 | not null default nextval('watson_searchentry_id_seq'::regclass)

49
 engine_slug     | character varying(200)  | not null

50
 content_type_id | integer                 | not null

51
 object_id       | text                    | not null

52
 object_id_int   | integer                 | 

53
 title           | character varying(1000) | not null

54
 description     | text                    | not null

55
 content         | text                    | not null

56
 url             | character varying(1000) | not null

57
 meta_encoded    | text                    | not null

58
 search_tsv      | tsvector                | not null

59
Indexes:

60
    "watson_searchentry_pkey" PRIMARY KEY, btree (id)

61
    "watson_searchentry_content_type_id" btree (content_type_id)

62
    "watson_searchentry_engine_slug" btree (engine_slug)

63
    "watson_searchentry_engine_slug_like" btree (engine_slug varchar_pattern_ops)

64
    "watson_searchentry_object_id_int" btree (object_id_int)

65
    "watson_searchentry_search_tsv" gin (search_tsv)

66
Foreign-key constraints:

67
    "content_type_id_refs_id_21a2c219b8bb212f" FOREIGN KEY (content_type_id) REFERENCES django_content_type(id) DEFERRABLE INITIALLY DEFERRED

68
Triggers:

69-
    watson_searchentry_trigger BEFORE INSERT OR UPDATE ON watson_searchentry FOR EACH ROW EXECUTE PROCEDURE watson_searchentry_trigger_handler()
69+
    watson_searchentry_trigger BEFORE INSERT OR UPDATE ON watson_searchentry FOR EACH ROW EXECUTE PROCEDURE watson_searchentry_trigger_handler()

70
71
72
73
                                     Table "public.web_user"

74
    Column     |           Type           |                       Modifiers                       

75
---------------+--------------------------+-------------------------------------------------------

76
 id            | integer                  | not null default nextval('web_user_id_seq'::regclass)

77
 password      | character varying(128)   | not null

78
 last_login    | timestamp with time zone | not null

79
 is_superuser  | boolean                  | not null

80
 email         | character varying(75)    | not null

81
 is_active     | boolean                  | not null

82
 is_staff      | boolean                  | not null

83
 date_created  | timestamp with time zone | 

84
 last_modified | timestamp with time zone | 

85
Indexes:

86
    "web_user_pkey" PRIMARY KEY, btree (id)

87
    "web_user_email_key" UNIQUE CONSTRAINT, btree (email)

88
    "web_user_email_like" btree (email varchar_pattern_ops)

89
Referenced by:

90
    TABLE "djangoratings_similaruser" CONSTRAINT "from_user_id_refs_id_4bf6919558e6e464" FOREIGN KEY (from_user_id) REFERENCES web_user(id) DEFERRABLE INITIALLY DEFERRED

91
    TABLE "djangoratings_similaruser" CONSTRAINT "to_user_id_refs_id_4bf6919558e6e464" FOREIGN KEY (to_user_id) REFERENCES web_user(id) DEFERRABLE INITIALLY DEFERRED

92
    TABLE "web_member" CONSTRAINT "user_id_refs_id_197cdfaff9279c92" FOREIGN KEY (user_id) REFERENCES web_user(id) DEFERRABLE INITIALLY DEFERRED

93
    TABLE "djangoratings_ignoredobject" CONSTRAINT "user_id_refs_id_1c7310623ccfde79" FOREIGN KEY (user_id) REFERENCES web_user(id) DEFERRABLE INITIALLY DEFERRED

94
    TABLE "djangoratings_vote" CONSTRAINT "user_id_refs_id_332b4e96bf1fa6c7" FOREIGN KEY (user_id) REFERENCES web_user(id) DEFERRABLE INITIALLY DEFERRED

95
    TABLE "web_user_groups" CONSTRAINT "user_id_refs_id_3995dbc0686a6e33" FOREIGN KEY (user_id) REFERENCES web_user(id) DEFERRABLE INITIALLY DEFERRED

96
    TABLE "web_user_user_permissions" CONSTRAINT "user_id_refs_id_69b47a84ab5eab1f" FOREIGN KEY (user_id) REFERENCES web_user(id) DEFERRABLE INITIALLY DEFERRED

97
98
99
100
                                     Table "public.web_country"

101
    Column     |           Type           |                        Modifiers                         

102
---------------+--------------------------+----------------------------------------------------------

103
 id            | integer                  | not null default nextval('web_country_id_seq'::regclass)

104
 name          | character varying(64)    | not null

105
 code          | character varying(2)     | not null

106
 date_created  | timestamp with time zone | 

107
 last_modified | timestamp with time zone | 

108
Indexes:

109
    "web_country_pkey" PRIMARY KEY, btree (id)

110
    "web_country_name" btree (name)

111
Referenced by:

112
    TABLE "web_crag" CONSTRAINT "country_id_refs_id_1384050a9bd763af" FOREIGN KEY (country_id) REFERENCES web_country(id) DEFERRABLE INITIALLY DEFERRED

113
    TABLE "web_city" CONSTRAINT "country_id_refs_id_55d3b49fd200671" FOREIGN KEY (country_id) REFERENCES web_country(id) DEFERRABLE INITIALLY DEFERRED

114
    TABLE "web_event" CONSTRAINT "country_id_refs_id_5f487906379304d7" FOREIGN KEY (country_id) REFERENCES web_country(id) DEFERRABLE INITIALLY DEFERRED

115
    TABLE "web_eventdestination" CONSTRAINT "country_id_refs_id_a7787a11041d874" FOREIGN KEY (country_id) REFERENCES web_country(id) DEFERRABLE INITIALLY DEFERRED

116
    TABLE "web_member" CONSTRAINT "country_id_refs_id_da95fd32a0949f0" FOREIGN KEY (country_id) REFERENCES web_country(id) DEFERRABLE INITIALLY DEFERRED
        

    


            


                                


        

            



                
    

        Public Pastes
    

    
            

    

                    

        

    





    


    
    
    
    
    
    
    
    




    


    



                

            We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.             OK, I Understand
        

    
                

            

                
                    
                
            

            

                Not a member of Pastebin yet?

                Sign Up, it unlocks many cool features!