← Back to branch summary

~eltonplima/sqm/devel

« back to all changes in this revision

Viewing changes to documentation/diagrams/database/diagrams/network_traffic.1degree.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.1degree.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 "oneDegreeRelationshipsDiagram" {
4
4
  graph [
49
49
      <TR><TD PORT="ip" COLSPAN="3" ALIGN="LEFT">ip</TD></TR>
50
50
      <TR><TD PORT="name" COLSPAN="3" ALIGN="LEFT">name</TD></TR>
51
51
      <TR><TD PORT="domain_id" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">domain_id</TD></TR>
52
 
      <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>
 
52
      <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>
53
53
    </TABLE>>
54
54
    URL="network_host.html"
55
55
    tooltip="network_host"
61
61
      <TR><TD PORT="id" COLSPAN="3" BGCOLOR="#bed1b8" ALIGN="LEFT">id</TD></TR>
62
62
      <TR><TD PORT="code" COLSPAN="3" ALIGN="LEFT">code</TD></TR>
63
63
      <TR><TD PORT="description" COLSPAN="3" ALIGN="LEFT">description</TD></TR>
64
 
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">  </TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">2 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">1 &gt;</TD></TR>
 
64
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">  </TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">7 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">1 &gt;</TD></TR>
65
65
    </TABLE>>
66
66
    URL="network_http_status_code.html"
67
67
    tooltip="network_http_status_code"
73
73
      <TR><TD PORT="id" COLSPAN="3" BGCOLOR="#bed1b8" ALIGN="LEFT">id</TD></TR>
74
74
      <TR><TD PORT="mime_type" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">mime_type</TD></TR>
75
75
      <TR><TD PORT="description" COLSPAN="3" ALIGN="LEFT">description</TD></TR>
76
 
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">  </TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">2 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">1 &gt;</TD></TR>
 
76
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">  </TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">19 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">1 &gt;</TD></TR>
77
77
    </TABLE>>
78
78
    URL="network_mime_type.html"
79
79
    tooltip="network_mime_type"
97
97
      <TR><TD PORT="id" COLSPAN="3" BGCOLOR="#bed1b8" ALIGN="LEFT">id</TD></TR>
98
98
      <TR><TD PORT="method" COLSPAN="3" ALIGN="LEFT">method</TD></TR>
99
99
      <TR><TD PORT="description" COLSPAN="3" ALIGN="LEFT">description</TD></TR>
100
 
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">  </TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">3 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">1 &gt;</TD></TR>
 
100
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">  </TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">4 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">1 &gt;</TD></TR>
101
101
    </TABLE>>
102
102
    URL="network_request_method.html"
103
103
    tooltip="network_request_method"
109
109
      <TR><TD PORT="id" COLSPAN="3" BGCOLOR="#bed1b8" ALIGN="LEFT">id</TD></TR>
110
110
      <TR><TD PORT="status" COLSPAN="3" ALIGN="LEFT">status</TD></TR>
111
111
      <TR><TD PORT="description" COLSPAN="3" ALIGN="LEFT">description</TD></TR>
112
 
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">  </TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">2 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">1 &gt;</TD></TR>
 
112
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">  </TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">9 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">1 &gt;</TD></TR>
113
113
    </TABLE>>
114
114
    URL="network_request_status.html"
115
115
    tooltip="network_request_status"
119
119
    <TABLE BORDER="2" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
120
120
      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">network_traffic</TD></TR>
121
121
      <TR><TD PORT="id" COLSPAN="2" BGCOLOR="#bed1b8" ALIGN="LEFT">id</TD><TD PORT="id.type" ALIGN="LEFT">serial[10]</TD></TR>
 
122
      <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>
122
123
      <TR><TD PORT="timestamp" COLSPAN="2" ALIGN="LEFT">timestamp</TD><TD PORT="timestamp.type" ALIGN="LEFT">varchar[14]</TD></TR>
123
124
      <TR><TD PORT="process_time" COLSPAN="2" ALIGN="LEFT">process_time</TD><TD PORT="process_time.type" ALIGN="LEFT">int4[10]</TD></TR>
124
125
      <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>
131
132
      <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>
132
133
      <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>
133
134
      <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>
134
 
      <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>
 
135
      <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>
135
136
    </TABLE>>
136
137
    URL="network_traffic.html"
137
138
    tooltip="network_traffic"
144
145
      <TR><TD PORT="protocol_id" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">protocol_id</TD></TR>
145
146
      <TR><TD PORT="host_id" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">host_id</TD></TR>
146
147
      <TR><TD PORT="path" COLSPAN="3" ALIGN="LEFT">path</TD></TR>
147
 
      <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>
 
148
      <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>
148
149
    </TABLE>>
149
150
    URL="network_url.html"
150
151
    tooltip="network_url"
154
155
    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
155
156
      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">network_user</TD></TR>
156
157
      <TR><TD PORT="user_ptr_id" COLSPAN="3" BGCOLOR="#bed1b8" ALIGN="LEFT">user_ptr_id</TD></TR>
157
 
      <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>
 
158
      <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>
158
159
    </TABLE>>
159
160
    URL="network_user.html"
160
161
    tooltip="network_user"