~eltonplima/sqm/devel

« back to all changes in this revision

Viewing changes to documentation/diagrams/database/diagrams/network_user.2degrees.dot

  • Committer: Elton Pereira de Lima
  • Date: 2009-11-12 10:59:01 UTC
  • Revision ID: elton@elton-laptop-20091112105901-ra7hfonxr08r7ps6
All foreign key of network models now null=False and blank=False
Improved speed to importer.

Show diffs side-by-side

added added

removed removed

Lines of Context:
1
 
// dot 2.20.2 on Linux 2.6.31-11-generic
 
1
// dot 2.20.2 on Linux 2.6.31-14-generic
2
2
// SchemaSpy rev 514
3
3
digraph "twoDegreesRelationshipsDiagram" {
4
4
  graph [
62
62
      <TR><TD PORT="is_superuser" COLSPAN="3" ALIGN="LEFT">is_superuser</TD></TR>
63
63
      <TR><TD PORT="last_login" COLSPAN="3" ALIGN="LEFT">last_login</TD></TR>
64
64
      <TR><TD PORT="date_joined" COLSPAN="3" ALIGN="LEFT">date_joined</TD></TR>
65
 
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">  </TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">2 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">5 &gt;</TD></TR>
 
65
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">  </TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">6 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">5 &gt;</TD></TR>
66
66
    </TABLE>>
67
67
    URL="auth_user.html"
68
68
    tooltip="auth_user"
112
112
    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
113
113
      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">network_host</TD></TR>
114
114
      <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
115
 
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 1</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">7 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">2 &gt;</TD></TR>
 
115
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 1</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">280 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">2 &gt;</TD></TR>
116
116
    </TABLE>>
117
117
    URL="network_host.html"
118
118
    tooltip="network_host"
122
122
    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
123
123
      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">network_http_status_code</TD></TR>
124
124
      <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
125
 
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">  </TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">2 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">1 &gt;</TD></TR>
 
125
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">  </TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">7 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">1 &gt;</TD></TR>
126
126
    </TABLE>>
127
127
    URL="network_http_status_code.html"
128
128
    tooltip="network_http_status_code"
132
132
    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
133
133
      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">network_mime_type</TD></TR>
134
134
      <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
135
 
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">  </TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">2 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">1 &gt;</TD></TR>
 
135
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">  </TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">19 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">1 &gt;</TD></TR>
136
136
    </TABLE>>
137
137
    URL="network_mime_type.html"
138
138
    tooltip="network_mime_type"
152
152
    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
153
153
      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">network_request_method</TD></TR>
154
154
      <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
155
 
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">  </TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">3 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">1 &gt;</TD></TR>
 
155
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">  </TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">4 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">1 &gt;</TD></TR>
156
156
    </TABLE>>
157
157
    URL="network_request_method.html"
158
158
    tooltip="network_request_method"
162
162
    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
163
163
      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">network_request_status</TD></TR>
164
164
      <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
165
 
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">  </TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">2 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">1 &gt;</TD></TR>
 
165
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">  </TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">9 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">1 &gt;</TD></TR>
166
166
    </TABLE>>
167
167
    URL="network_request_status.html"
168
168
    tooltip="network_request_status"
172
172
    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
173
173
      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">network_traffic</TD></TR>
174
174
      <TR><TD PORT="id" COLSPAN="3" BGCOLOR="#bed1b8" ALIGN="LEFT">id</TD></TR>
 
175
      <TR><TD PORT="hash_line" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">hash_line</TD></TR>
175
176
      <TR><TD PORT="timestamp" COLSPAN="3" ALIGN="LEFT">timestamp</TD></TR>
176
177
      <TR><TD PORT="process_time" COLSPAN="3" ALIGN="LEFT">process_time</TD></TR>
177
178
      <TR><TD PORT="port_id" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">port_id</TD></TR>
184
185
      <TR><TD PORT="user_id" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">user_id</TD></TR>
185
186
      <TR><TD PORT="hierarchy_status_id" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">hierarchy_status_id</TD></TR>
186
187
      <TR><TD PORT="mime_type_id" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">mime_type_id</TD></TR>
187
 
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 9</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">4 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">  </TD></TR>
 
188
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 9</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">2.165 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">  </TD></TR>
188
189
    </TABLE>>
189
190
    URL="network_traffic.html"
190
191
    tooltip="network_traffic"
194
195
    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
195
196
      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">network_url</TD></TR>
196
197
      <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
197
 
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 2</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">5 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">1 &gt;</TD></TR>
 
198
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 2</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">2.160 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">1 &gt;</TD></TR>
198
199
    </TABLE>>
199
200
    URL="network_url.html"
200
201
    tooltip="network_url"
204
205
    <TABLE BORDER="2" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
205
206
      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">network_user</TD></TR>
206
207
      <TR><TD PORT="user_ptr_id" COLSPAN="2" BGCOLOR="#bed1b8" ALIGN="LEFT">user_ptr_id</TD><TD PORT="user_ptr_id.type" ALIGN="LEFT">int4[10]</TD></TR>
207
 
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 1</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">2 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">3 &gt;</TD></TR>
 
208
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 1</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">6 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">3 &gt;</TD></TR>
208
209
    </TABLE>>
209
210
    URL="network_user.html"
210
211
    tooltip="network_user"
220
221
      <TR><TD PORT="block" COLSPAN="3" ALIGN="LEFT">block</TD></TR>
221
222
      <TR><TD PORT="date_block" COLSPAN="3" ALIGN="LEFT">date_block</TD></TR>
222
223
      <TR><TD PORT="time_block" COLSPAN="3" ALIGN="LEFT">time_block</TD></TR>
223
 
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 2</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">2 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">  </TD></TR>
 
224
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 2</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">6 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">  </TD></TR>
224
225
    </TABLE>>
225
226
    URL="quote.html"
226
227
    tooltip="quote"