blob: 9665d42517ad129c6acfd945dc75c84279985e4c (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
|
// dot 2.26.3 on Linux 3.2.0-4-686-pae
// SchemaSpy rev 590
digraph "oneDegreeRelationshipsDiagram" {
graph [
rankdir="RL"
bgcolor="#f7f7f7"
label="\nGenerated by SchemaSpy"
labeljust="l"
nodesep="0.18"
ranksep="0.46"
fontname="Helvetica"
fontsize="11"
];
node [
fontname="Helvetica"
fontsize="11"
shape="plaintext"
];
edge [
arrowsize="0.8"
];
"mail" [
label=<
<TABLE BORDER="2" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
<TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">mail</TD></TR>
<TR><TD PORT="id" COLSPAN="2" BGCOLOR="#bed1b8" ALIGN="LEFT">id</TD><TD PORT="id.type" ALIGN="LEFT">int unsigned[10]</TD></TR>
<TR><TD PORT="convid" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">convid</TD><TD PORT="convid.type" ALIGN="LEFT">int unsigned[10]</TD></TR>
<TR><TD PORT="mail_flags" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">mail_flags</TD><TD PORT="mail_flags.type" ALIGN="LEFT">int unsigned[10]</TD></TR>
<TR><TD PORT="from_xchan" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">from_xchan</TD><TD PORT="from_xchan.type" ALIGN="LEFT">char[255]</TD></TR>
<TR><TD PORT="to_xchan" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">to_xchan</TD><TD PORT="to_xchan.type" ALIGN="LEFT">char[255]</TD></TR>
<TR><TD PORT="account_id" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">account_id</TD><TD PORT="account_id.type" ALIGN="LEFT">int unsigned[10]</TD></TR>
<TR><TD PORT="channel_id" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">channel_id</TD><TD PORT="channel_id.type" ALIGN="LEFT">int unsigned[10]</TD></TR>
<TR><TD PORT="title" COLSPAN="2" ALIGN="LEFT">title</TD><TD PORT="title.type" ALIGN="LEFT">text[65535]</TD></TR>
<TR><TD PORT="body" COLSPAN="2" ALIGN="LEFT">body</TD><TD PORT="body.type" ALIGN="LEFT">mediumtext[16777215]</TD></TR>
<TR><TD PORT="sig" COLSPAN="2" ALIGN="LEFT">sig</TD><TD PORT="sig.type" ALIGN="LEFT">text[65535]</TD></TR>
<TR><TD PORT="attach" COLSPAN="2" ALIGN="LEFT">attach</TD><TD PORT="attach.type" ALIGN="LEFT">mediumtext[16777215]</TD></TR>
<TR><TD PORT="mid" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">mid</TD><TD PORT="mid.type" ALIGN="LEFT">char[255]</TD></TR>
<TR><TD PORT="parent_mid" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">parent_mid</TD><TD PORT="parent_mid.type" ALIGN="LEFT">char[255]</TD></TR>
<TR><TD PORT="mail_deleted" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">mail_deleted</TD><TD PORT="mail_deleted.type" ALIGN="LEFT">tinyint[3]</TD></TR>
<TR><TD PORT="mail_replied" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">mail_replied</TD><TD PORT="mail_replied.type" ALIGN="LEFT">tinyint[3]</TD></TR>
<TR><TD PORT="mail_isreply" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">mail_isreply</TD><TD PORT="mail_isreply.type" ALIGN="LEFT">tinyint[3]</TD></TR>
<TR><TD PORT="mail_seen" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">mail_seen</TD><TD PORT="mail_seen.type" ALIGN="LEFT">tinyint[3]</TD></TR>
<TR><TD PORT="mail_recalled" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">mail_recalled</TD><TD PORT="mail_recalled.type" ALIGN="LEFT">tinyint[3]</TD></TR>
<TR><TD PORT="mail_obscured" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">mail_obscured</TD><TD PORT="mail_obscured.type" ALIGN="LEFT">smallint[5]</TD></TR>
<TR><TD PORT="created" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">created</TD><TD PORT="created.type" ALIGN="LEFT">datetime[19]</TD></TR>
<TR><TD PORT="expires" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">expires</TD><TD PORT="expires.type" ALIGN="LEFT">datetime[19]</TD></TR>
<TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">< 0</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">7 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">0 ></TD></TR>
</TABLE>>
URL="mail.html"
tooltip="mail"
];
}
|