From c40f6060da9c014135e70f165fa7adbfb127bcf2 Mon Sep 17 00:00:00 2001 From: Haakon Meland Eriksen Date: Fri, 6 Nov 2015 17:26:04 +0100 Subject: Hubzilla report created by schemaSpy using zot.meta.xml to imply relationships --- hubzilla_er/diagrams/channel.implied2degrees.dot | 179 +++++++++++++++++++++++ 1 file changed, 179 insertions(+) create mode 100644 hubzilla_er/diagrams/channel.implied2degrees.dot (limited to 'hubzilla_er/diagrams/channel.implied2degrees.dot') diff --git a/hubzilla_er/diagrams/channel.implied2degrees.dot b/hubzilla_er/diagrams/channel.implied2degrees.dot new file mode 100644 index 000000000..4cc3b73a3 --- /dev/null +++ b/hubzilla_er/diagrams/channel.implied2degrees.dot @@ -0,0 +1,179 @@ +// dot 2.26.3 on Linux 3.2.0-4-686-pae +// SchemaSpy rev 590 +digraph "impliedTwoDegreesRelationshipsDiagram" { + 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" + ]; + "likes":"channel_id":w -> "channel":"channel_id.type":e [arrowhead=none dir=back arrowtail=crowodot style=dashed]; + "likes":"id":w -> "verify":"elipses":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; + "mail":"account_id":w -> "account":"elipses":e [arrowhead=none dir=back arrowtail=crowodot style=dashed]; + "mail":"channel_id":w -> "channel":"channel_id.type":e [arrowhead=none dir=back arrowtail=crowodot style=dashed]; + "mail":"id":w -> "verify":"elipses":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; + "profext":"channel_id":w -> "channel":"channel_id.type":e [arrowhead=none dir=back arrowtail=crowodot style=dashed]; + "profext":"id":w -> "verify":"elipses":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; + "profext":"k":w -> "cache":"elipses":e [arrowhead=none dir=back arrowtail=crowodot style=dashed]; + "account" [ + label=< + + + + +
account
...
1 row1 >
> + URL="account.html" + tooltip="account" + ]; + "cache" [ + label=< + + + + +
cache
...
21 rows5 >
> + URL="cache.html" + tooltip="cache" + ]; + "channel" [ + label=< + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
channel
channel_idint unsigned[10]
channel_account_idint unsigned[10]
channel_primarybit[0]
channel_namechar[255]
channel_addresschar[255]
channel_guidchar[255]
channel_guid_sigtext[65535]
channel_hashchar[255]
channel_timezonechar[128]
channel_locationchar[255]
channel_themechar[255]
channel_startpagechar[255]
channel_pubkeytext[65535]
channel_prvkeytext[65535]
channel_notifyflagsint unsigned[10]
channel_pageflagsint unsigned[10]
channel_dirdatedatetime[19]
channel_lastpostdatetime[19]
channel_deleteddatetime[19]
channel_max_anon_mailint unsigned[10]
channel_max_friend_reqint unsigned[10]
channel_expire_daysint[10]
channel_passwd_resetchar[255]
channel_default_groupchar[255]
channel_allow_cidmediumtext[16777215]
channel_allow_gidmediumtext[16777215]
channel_deny_cidmediumtext[16777215]
channel_deny_gidmediumtext[16777215]
channel_r_streamint unsigned[10]
channel_r_profileint unsigned[10]
channel_r_photosint unsigned[10]
channel_r_abookint unsigned[10]
channel_w_streamint unsigned[10]
channel_w_wallint unsigned[10]
channel_w_tagwallint unsigned[10]
channel_w_commentint unsigned[10]
channel_w_mailint unsigned[10]
channel_w_photosint unsigned[10]
channel_w_chatint unsigned[10]
channel_a_delegateint unsigned[10]
channel_r_storageint unsigned[10]
channel_w_storageint unsigned[10]
channel_r_pagesint unsigned[10]
channel_w_pagesint unsigned[10]
channel_a_republishint unsigned[10]
channel_w_likeint unsigned[10]
channel_removedbit[0]
channel_systembit[0]
< 05 rows3 >
> + URL="channel.html" + tooltip="channel" + ]; + "likes" [ + label=< + + + + + + + + + + + + +
likes
id
channel_id
liker
likee
iid
verb
target_type
target_id
target
< 20 rows
> + URL="likes.html" + tooltip="likes" + ]; + "mail" [ + label=< + + + + + + + + + + + + + + + + + + + + + + + + +
mail
id
convid
mail_flags
from_xchan
to_xchan
account_id
channel_id
title
body
sig
attach
mid
parent_mid
mail_deleted
mail_replied
mail_isreply
mail_seen
mail_recalled
mail_obscured
created
expires
< 37 rows
> + URL="mail.html" + tooltip="mail" + ]; + "profext" [ + label=< + + + + + + + + +
profext
id
channel_id
hash
k
v
< 30 rows
> + URL="profext.html" + tooltip="profext" + ]; + "verify" [ + label=< + + + + +
verify
...
1 row20 >
> + URL="verify.html" + tooltip="verify" + ]; +} -- cgit v1.2.3