~eltonplima/sqm/devel

« back to all changes in this revision

Viewing changes to documentation/diagrams/database/diagrams/network_mime_type.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 [
44
44
    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
45
45
      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">network_host</TD></TR>
46
46
      <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
47
 
      <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>
 
47
      <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>
48
48
    </TABLE>>
49
49
    URL="network_host.html"
50
50
    tooltip="network_host"
54
54
    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
55
55
      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">network_http_status_code</TD></TR>
56
56
      <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
57
 
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">  </TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">2 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">1 &gt;</TD></TR>
 
57
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">  </TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">7 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">1 &gt;</TD></TR>
58
58
    </TABLE>>
59
59
    URL="network_http_status_code.html"
60
60
    tooltip="network_http_status_code"
66
66
      <TR><TD PORT="id" COLSPAN="2" BGCOLOR="#bed1b8" ALIGN="LEFT">id</TD><TD PORT="id.type" ALIGN="LEFT">serial[10]</TD></TR>
67
67
      <TR><TD PORT="mime_type" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">mime_type</TD><TD PORT="mime_type.type" ALIGN="LEFT">varchar[100]</TD></TR>
68
68
      <TR><TD PORT="description" COLSPAN="2" ALIGN="LEFT">description</TD><TD PORT="description.type" ALIGN="LEFT">text[2147483647]</TD></TR>
69
 
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 0</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">2 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">1 &gt;</TD></TR>
 
69
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 0</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">19 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">1 &gt;</TD></TR>
70
70
    </TABLE>>
71
71
    URL="network_mime_type.html"
72
72
    tooltip="network_mime_type"
86
86
    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
87
87
      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">network_request_method</TD></TR>
88
88
      <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
89
 
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">  </TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">3 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">1 &gt;</TD></TR>
 
89
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">  </TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">4 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">1 &gt;</TD></TR>
90
90
    </TABLE>>
91
91
    URL="network_request_method.html"
92
92
    tooltip="network_request_method"
96
96
    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
97
97
      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">network_request_status</TD></TR>
98
98
      <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
99
 
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">  </TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">2 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">1 &gt;</TD></TR>
 
99
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">  </TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">9 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">1 &gt;</TD></TR>
100
100
    </TABLE>>
101
101
    URL="network_request_status.html"
102
102
    tooltip="network_request_status"
106
106
    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
107
107
      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">network_traffic</TD></TR>
108
108
      <TR><TD PORT="id" COLSPAN="3" BGCOLOR="#bed1b8" ALIGN="LEFT">id</TD></TR>
 
109
      <TR><TD PORT="hash_line" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">hash_line</TD></TR>
109
110
      <TR><TD PORT="timestamp" COLSPAN="3" ALIGN="LEFT">timestamp</TD></TR>
110
111
      <TR><TD PORT="process_time" COLSPAN="3" ALIGN="LEFT">process_time</TD></TR>
111
112
      <TR><TD PORT="port_id" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">port_id</TD></TR>
118
119
      <TR><TD PORT="user_id" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">user_id</TD></TR>
119
120
      <TR><TD PORT="hierarchy_status_id" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">hierarchy_status_id</TD></TR>
120
121
      <TR><TD PORT="mime_type_id" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">mime_type_id</TD></TR>
121
 
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 9</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">4 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">  </TD></TR>
 
122
      <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>
122
123
    </TABLE>>
123
124
    URL="network_traffic.html"
124
125
    tooltip="network_traffic"
128
129
    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
129
130
      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">network_url</TD></TR>
130
131
      <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
131
 
      <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>
 
132
      <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>
132
133
    </TABLE>>
133
134
    URL="network_url.html"
134
135
    tooltip="network_url"
138
139
    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
139
140
      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">network_user</TD></TR>
140
141
      <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
141
 
      <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>
 
142
      <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>
142
143
    </TABLE>>
143
144
    URL="network_user.html"
144
145
    tooltip="network_user"