blob: 6a7257e5ee3a1cb130e89fda07ead45acf89c87b (
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
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
|
// 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"
];
"abook":"abook_xchan":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot];
"abook" [
label=<
<TABLE BORDER="2" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
<TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">abook</TD></TR>
<TR><TD PORT="abook_id" COLSPAN="2" BGCOLOR="#bed1b8" ALIGN="LEFT">abook_id</TD><TD PORT="abook_id.type" ALIGN="LEFT">int unsigned[10]</TD></TR>
<TR><TD PORT="abook_account" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">abook_account</TD><TD PORT="abook_account.type" ALIGN="LEFT">int unsigned[10]</TD></TR>
<TR><TD PORT="abook_channel" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">abook_channel</TD><TD PORT="abook_channel.type" ALIGN="LEFT">int unsigned[10]</TD></TR>
<TR><TD PORT="abook_xchan" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">abook_xchan</TD><TD PORT="abook_xchan.type" ALIGN="LEFT">char[255]</TD></TR>
<TR><TD PORT="abook_my_perms" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">abook_my_perms</TD><TD PORT="abook_my_perms.type" ALIGN="LEFT">int[10]</TD></TR>
<TR><TD PORT="abook_their_perms" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">abook_their_perms</TD><TD PORT="abook_their_perms.type" ALIGN="LEFT">int[10]</TD></TR>
<TR><TD PORT="abook_closeness" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">abook_closeness</TD><TD PORT="abook_closeness.type" ALIGN="LEFT">tinyint unsigned[3]</TD></TR>
<TR><TD PORT="abook_created" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">abook_created</TD><TD PORT="abook_created.type" ALIGN="LEFT">datetime[19]</TD></TR>
<TR><TD PORT="abook_updated" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">abook_updated</TD><TD PORT="abook_updated.type" ALIGN="LEFT">datetime[19]</TD></TR>
<TR><TD PORT="abook_connected" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">abook_connected</TD><TD PORT="abook_connected.type" ALIGN="LEFT">datetime[19]</TD></TR>
<TR><TD PORT="abook_dob" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">abook_dob</TD><TD PORT="abook_dob.type" ALIGN="LEFT">datetime[19]</TD></TR>
<TR><TD PORT="abook_flags" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">abook_flags</TD><TD PORT="abook_flags.type" ALIGN="LEFT">int[10]</TD></TR>
<TR><TD PORT="abook_blocked" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">abook_blocked</TD><TD PORT="abook_blocked.type" ALIGN="LEFT">tinyint[3]</TD></TR>
<TR><TD PORT="abook_ignored" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">abook_ignored</TD><TD PORT="abook_ignored.type" ALIGN="LEFT">tinyint[3]</TD></TR>
<TR><TD PORT="abook_hidden" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">abook_hidden</TD><TD PORT="abook_hidden.type" ALIGN="LEFT">tinyint[3]</TD></TR>
<TR><TD PORT="abook_archived" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">abook_archived</TD><TD PORT="abook_archived.type" ALIGN="LEFT">tinyint[3]</TD></TR>
<TR><TD PORT="abook_pending" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">abook_pending</TD><TD PORT="abook_pending.type" ALIGN="LEFT">tinyint[3]</TD></TR>
<TR><TD PORT="abook_unconnected" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">abook_unconnected</TD><TD PORT="abook_unconnected.type" ALIGN="LEFT">tinyint[3]</TD></TR>
<TR><TD PORT="abook_self" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">abook_self</TD><TD PORT="abook_self.type" ALIGN="LEFT">tinyint[3]</TD></TR>
<TR><TD PORT="abook_feed" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">abook_feed</TD><TD PORT="abook_feed.type" ALIGN="LEFT">tinyint[3]</TD></TR>
<TR><TD PORT="abook_profile" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">abook_profile</TD><TD PORT="abook_profile.type" ALIGN="LEFT">char[64]</TD></TR>
<TR><TD PORT="abook_incl" COLSPAN="2" ALIGN="LEFT">abook_incl</TD><TD PORT="abook_incl.type" ALIGN="LEFT">text[65535]</TD></TR>
<TR><TD PORT="abook_excl" COLSPAN="2" ALIGN="LEFT">abook_excl</TD><TD PORT="abook_excl.type" ALIGN="LEFT">text[65535]</TD></TR>
<TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">< 1</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">685 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">0 ></TD></TR>
</TABLE>>
URL="abook.html"
tooltip="abook"
];
"xchan" [
label=<
<TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
<TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">xchan</TD></TR>
<TR><TD PORT="xchan_hash" COLSPAN="3" BGCOLOR="#bed1b8" ALIGN="LEFT">xchan_hash</TD></TR>
<TR><TD PORT="xchan_guid" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">xchan_guid</TD></TR>
<TR><TD PORT="xchan_guid_sig" COLSPAN="3" ALIGN="LEFT">xchan_guid_sig</TD></TR>
<TR><TD PORT="xchan_pubkey" COLSPAN="3" ALIGN="LEFT">xchan_pubkey</TD></TR>
<TR><TD PORT="xchan_photo_mimetype" COLSPAN="3" ALIGN="LEFT">xchan_photo_mimetype</TD></TR>
<TR><TD PORT="xchan_photo_l" COLSPAN="3" ALIGN="LEFT">xchan_photo_l</TD></TR>
<TR><TD PORT="xchan_photo_m" COLSPAN="3" ALIGN="LEFT">xchan_photo_m</TD></TR>
<TR><TD PORT="xchan_photo_s" COLSPAN="3" ALIGN="LEFT">xchan_photo_s</TD></TR>
<TR><TD PORT="xchan_addr" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">xchan_addr</TD></TR>
<TR><TD PORT="xchan_url" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">xchan_url</TD></TR>
<TR><TD PORT="xchan_connurl" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">xchan_connurl</TD></TR>
<TR><TD PORT="xchan_follow" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">xchan_follow</TD></TR>
<TR><TD PORT="xchan_connpage" COLSPAN="3" ALIGN="LEFT">xchan_connpage</TD></TR>
<TR><TD PORT="xchan_name" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">xchan_name</TD></TR>
<TR><TD PORT="xchan_network" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">xchan_network</TD></TR>
<TR><TD PORT="xchan_instance_url" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">xchan_instance_url</TD></TR>
<TR><TD PORT="xchan_flags" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">xchan_flags</TD></TR>
<TR><TD PORT="xchan_photo_date" COLSPAN="3" ALIGN="LEFT">xchan_photo_date</TD></TR>
<TR><TD PORT="xchan_name_date" COLSPAN="3" ALIGN="LEFT">xchan_name_date</TD></TR>
<TR><TD PORT="xchan_hidden" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">xchan_hidden</TD></TR>
<TR><TD PORT="xchan_orphan" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">xchan_orphan</TD></TR>
<TR><TD PORT="xchan_censored" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">xchan_censored</TD></TR>
<TR><TD PORT="xchan_selfcensored" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">xchan_selfcensored</TD></TR>
<TR><TD PORT="xchan_system" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">xchan_system</TD></TR>
<TR><TD PORT="xchan_pubforum" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">xchan_pubforum</TD></TR>
<TR><TD PORT="xchan_deleted" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">xchan_deleted</TD></TR>
<TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">< 2</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">2 301 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">35 ></TD></TR>
</TABLE>>
URL="xchan.html"
tooltip="xchan"
];
}
|
