← Back to branch summary

~eltonplima/sqm/devel

« back to all changes in this revision

Viewing changes to documentation/diagrams/database/diagrams/network_traffic.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:
documentation/diagrams/database/diagrams/network_traffic.2degrees.dot
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 [
39
39
    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
40
40
      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">auth_user</TD></TR>
41
41
      <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
42
 
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">  </TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">2 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">5 &gt;</TD></TR>
 
42
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">  </TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">6 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">5 &gt;</TD></TR>
43
43
    </TABLE>>
44
44
    URL="auth_user.html"
45
45
    tooltip="auth_user"
49
49
    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
50
50
      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">network_domain</TD></TR>
51
51
      <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
52
 
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">  </TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">1 row</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">1 &gt;</TD></TR>
 
52
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">  </TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">77 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">1 &gt;</TD></TR>
53
53
    </TABLE>>
54
54
    URL="network_domain.html"
55
55
    tooltip="network_domain"
74
74
      <TR><TD PORT="ip" COLSPAN="3" ALIGN="LEFT">ip</TD></TR>
75
75
      <TR><TD PORT="name" COLSPAN="3" ALIGN="LEFT">name</TD></TR>
76
76
      <TR><TD PORT="domain_id" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">domain_id</TD></TR>
77
 
      <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>
 
77
      <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>
78
78
    </TABLE>>
79
79
    URL="network_host.html"
80
80
    tooltip="network_host"
86
86
      <TR><TD PORT="id" COLSPAN="3" BGCOLOR="#bed1b8" ALIGN="LEFT">id</TD></TR>
87
87
      <TR><TD PORT="code" COLSPAN="3" ALIGN="LEFT">code</TD></TR>
88
88
      <TR><TD PORT="description" COLSPAN="3" ALIGN="LEFT">description</TD></TR>
89
 
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">  </TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">2 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">1 &gt;</TD></TR>
 
89
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">  </TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">7 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">1 &gt;</TD></TR>
90
90
    </TABLE>>
91
91
    URL="network_http_status_code.html"
92
92
    tooltip="network_http_status_code"
98
98
      <TR><TD PORT="id" COLSPAN="3" BGCOLOR="#bed1b8" ALIGN="LEFT">id</TD></TR>
99
99
      <TR><TD PORT="mime_type" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">mime_type</TD></TR>
100
100
      <TR><TD PORT="description" COLSPAN="3" ALIGN="LEFT">description</TD></TR>
101
 
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">  </TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">2 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">1 &gt;</TD></TR>
 
101
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">  </TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">19 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">1 &gt;</TD></TR>
102
102
    </TABLE>>
103
103
    URL="network_mime_type.html"
104
104
    tooltip="network_mime_type"
132
132
      <TR><TD PORT="id" COLSPAN="3" BGCOLOR="#bed1b8" ALIGN="LEFT">id</TD></TR>
133
133
      <TR><TD PORT="method" COLSPAN="3" ALIGN="LEFT">method</TD></TR>
134
134
      <TR><TD PORT="description" COLSPAN="3" ALIGN="LEFT">description</TD></TR>
135
 
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">  </TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">3 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">1 &gt;</TD></TR>
 
135
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">  </TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">4 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">1 &gt;</TD></TR>
136
136
    </TABLE>>
137
137
    URL="network_request_method.html"
138
138
    tooltip="network_request_method"
144
144
      <TR><TD PORT="id" COLSPAN="3" BGCOLOR="#bed1b8" ALIGN="LEFT">id</TD></TR>
145
145
      <TR><TD PORT="status" COLSPAN="3" ALIGN="LEFT">status</TD></TR>
146
146
      <TR><TD PORT="description" COLSPAN="3" ALIGN="LEFT">description</TD></TR>
147
 
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">  </TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">2 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">1 &gt;</TD></TR>
 
147
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">  </TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">9 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">1 &gt;</TD></TR>
148
148
    </TABLE>>
149
149
    URL="network_request_status.html"
150
150
    tooltip="network_request_status"
154
154
    <TABLE BORDER="2" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
155
155
      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">network_traffic</TD></TR>
156
156
      <TR><TD PORT="id" COLSPAN="2" BGCOLOR="#bed1b8" ALIGN="LEFT">id</TD><TD PORT="id.type" ALIGN="LEFT">serial[10]</TD></TR>
 
157
      <TR><TD PORT="hash_line" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">hash_line</TD><TD PORT="hash_line.type" ALIGN="LEFT">varchar[32]</TD></TR>
157
158
      <TR><TD PORT="timestamp" COLSPAN="2" ALIGN="LEFT">timestamp</TD><TD PORT="timestamp.type" ALIGN="LEFT">varchar[14]</TD></TR>
158
159
      <TR><TD PORT="process_time" COLSPAN="2" ALIGN="LEFT">process_time</TD><TD PORT="process_time.type" ALIGN="LEFT">int4[10]</TD></TR>
159
160
      <TR><TD PORT="port_id" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">port_id</TD><TD PORT="port_id.type" ALIGN="LEFT">int4[10]</TD></TR>
166
167
      <TR><TD PORT="user_id" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">user_id</TD><TD PORT="user_id.type" ALIGN="LEFT">int4[10]</TD></TR>
167
168
      <TR><TD PORT="hierarchy_status_id" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">hierarchy_status_id</TD><TD PORT="hierarchy_status_id.type" ALIGN="LEFT">int4[10]</TD></TR>
168
169
      <TR><TD PORT="mime_type_id" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">mime_type_id</TD><TD PORT="mime_type_id.type" ALIGN="LEFT">int4[10]</TD></TR>
169
 
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 9</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">4 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">0 &gt;</TD></TR>
 
170
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 9</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">2.165 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">0 &gt;</TD></TR>
170
171
    </TABLE>>
171
172
    URL="network_traffic.html"
172
173
    tooltip="network_traffic"
179
180
      <TR><TD PORT="protocol_id" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">protocol_id</TD></TR>
180
181
      <TR><TD PORT="host_id" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">host_id</TD></TR>
181
182
      <TR><TD PORT="path" COLSPAN="3" ALIGN="LEFT">path</TD></TR>
182
 
      <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>
 
183
      <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>
183
184
    </TABLE>>
184
185
    URL="network_url.html"
185
186
    tooltip="network_url"
189
190
    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
190
191
      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">network_user</TD></TR>
191
192
      <TR><TD PORT="user_ptr_id" COLSPAN="3" BGCOLOR="#bed1b8" ALIGN="LEFT">user_ptr_id</TD></TR>
192
 
      <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>
 
193
      <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>
193
194
    </TABLE>>
194
195
    URL="network_user.html"
195
196
    tooltip="network_user"
199
200
    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
200
201
      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">quote</TD></TR>
201
202
      <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
202
 
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 2</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">2 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">  </TD></TR>
 
203
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 2</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">6 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">  </TD></TR>
203
204
    </TABLE>>
204
205
    URL="quote.html"
205
206
    tooltip="quote"