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 --- .../diagrams/channel.1degree.dot | 415 +++++++++++++++++++++ 1 file changed, 415 insertions(+) create mode 100644 doc/schemaspy_hubzilla/diagrams/channel.1degree.dot (limited to 'doc/schemaspy_hubzilla/diagrams/channel.1degree.dot') diff --git a/doc/schemaspy_hubzilla/diagrams/channel.1degree.dot b/doc/schemaspy_hubzilla/diagrams/channel.1degree.dot new file mode 100644 index 000000000..04ff9b9d5 --- /dev/null +++ b/doc/schemaspy_hubzilla/diagrams/channel.1degree.dot @@ -0,0 +1,415 @@ +// 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" + ]; + "attach":"hash":w -> "channel":"channel_hash.type":e [arrowhead=none dir=back arrowtail=crowodot]; + "attach":"hash":w -> "hubloc":"hubloc_hash":e [arrowhead=none dir=back arrowtail=crowodot]; + "attach":"hash":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; + "channel":"channel_hash":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; + "event":"event_hash":w -> "channel":"channel_hash.type":e [arrowhead=none dir=back arrowtail=crowodot]; + "event":"event_hash":w -> "hubloc":"hubloc_hash":e [arrowhead=none dir=back arrowtail=crowodot]; + "event":"event_hash":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; + "event":"event_xchan":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; + "groups":"hash":w -> "channel":"channel_hash.type":e [arrowhead=none dir=back arrowtail=crowodot]; + "groups":"hash":w -> "hubloc":"hubloc_hash":e [arrowhead=none dir=back arrowtail=crowodot]; + "groups":"hash":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; + "hubloc":"hubloc_hash":w -> "channel":"channel_hash.type":e [arrowhead=none dir=back arrowtail=crowodot]; + "hubloc":"hubloc_hash":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; + "notify":"hash":w -> "channel":"channel_hash.type":e [arrowhead=none dir=back arrowtail=crowodot]; + "notify":"hash":w -> "hubloc":"hubloc_hash":e [arrowhead=none dir=back arrowtail=crowodot]; + "notify":"hash":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; + "outq":"outq_hash":w -> "channel":"channel_hash.type":e [arrowhead=none dir=back arrowtail=teeodot]; + "outq":"outq_hash":w -> "hubloc":"hubloc_hash":e [arrowhead=none dir=back arrowtail=teeodot]; + "outq":"outq_hash":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=teeodot]; + "profext":"hash":w -> "channel":"channel_hash.type":e [arrowhead=none dir=back arrowtail=crowodot]; + "profext":"hash":w -> "hubloc":"hubloc_hash":e [arrowhead=none dir=back arrowtail=crowodot]; + "profext":"hash":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; + "register":"hash":w -> "channel":"channel_hash.type":e [arrowhead=none dir=back arrowtail=crowodot]; + "register":"hash":w -> "hubloc":"hubloc_hash":e [arrowhead=none dir=back arrowtail=crowodot]; + "register":"hash":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; + "term":"parent_hash":w -> "channel":"channel_hash.type":e [arrowhead=none dir=back arrowtail=crowodot]; + "term":"parent_hash":w -> "hubloc":"hubloc_hash":e [arrowhead=none dir=back arrowtail=crowodot]; + "term":"parent_hash":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; + "term":"term_hash":w -> "channel":"channel_hash.type":e [arrowhead=none dir=back arrowtail=crowodot]; + "term":"term_hash":w -> "hubloc":"hubloc_hash":e [arrowhead=none dir=back arrowtail=crowodot]; + "term":"term_hash":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; + "updates":"ud_hash":w -> "channel":"channel_hash.type":e [arrowhead=none dir=back arrowtail=crowodot]; + "updates":"ud_hash":w -> "hubloc":"hubloc_hash":e [arrowhead=none dir=back arrowtail=crowodot]; + "updates":"ud_hash":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; + "xchan":"xchan_hash":w -> "channel":"channel_hash.type":e [arrowhead=none dir=back arrowtail=teeodot]; + "xchan":"xchan_hash":w -> "hubloc":"hubloc_hash":e [arrowhead=none dir=back arrowtail=teeodot]; + "xprof":"xprof_hash":w -> "channel":"channel_hash.type":e [arrowhead=none dir=back arrowtail=teeodot]; + "xprof":"xprof_hash":w -> "hubloc":"hubloc_hash":e [arrowhead=none dir=back arrowtail=teeodot]; + "xprof":"xprof_hash":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=teeodot]; + "xtag":"xtag_hash":w -> "channel":"channel_hash.type":e [arrowhead=none dir=back arrowtail=crowodot]; + "xtag":"xtag_hash":w -> "hubloc":"hubloc_hash":e [arrowhead=none dir=back arrowtail=crowodot]; + "xtag":"xtag_hash":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; + "attach" [ + label=< + + + + + + + + + + + + + + + + + + + + + + + + + + +
attach
id
aid
uid
hash
creator
filename
filetype
filesize
revision
folder
flags
is_dir
is_photo
os_storage
os_path
display_path
data
created
edited
allow_cid
allow_gid
deny_cid
deny_gid
< 3105 rows
> + URL="attach.html" + tooltip="attach" + ]; + "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]
< 112 rows14 >
> + URL="channel.html" + tooltip="channel" + ]; + "event" [ + label=< + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
event
id
aid
uid
event_xchan
event_hash
created
edited
start
finish
summary
description
location
type
nofinish
adjust
ignore
allow_cid
allow_gid
deny_cid
deny_gid
event_status
event_status_date
event_percent
event_repeat
event_sequence
event_priority
event_vdata
< 412 rows
> + URL="event.html" + tooltip="event" + ]; + "groups" [ + label=< + + + + + + + + + +
groups
id
hash
uid
visible
deleted
name
< 310 rows
> + URL="groups.html" + tooltip="groups" + ]; + "hubloc" [ + label=< + + + + + + + + + + + + + + + + + + + + + + + +
hubloc
hubloc_id
hubloc_guid
hubloc_guid_sig
hubloc_hash
hubloc_addr
hubloc_network
hubloc_flags
hubloc_status
hubloc_url
hubloc_url_sig
hubloc_host
hubloc_callback
hubloc_connect
hubloc_sitekey
hubloc_updated
hubloc_connected
hubloc_primary
hubloc_orphancheck
hubloc_error
hubloc_deleted
< 32 658 rows14 >
> + URL="hubloc.html" + tooltip="hubloc" + ]; + "notify" [ + label=< + + + + + + + + + + + + + + + + + + +
notify
id
hash
name
url
photo
date
msg
aid
uid
link
parent
seen
type
verb
otype
< 3528 rows
> + URL="notify.html" + tooltip="notify" + ]; + "outq" [ + label=< + + + + + + + + + + + + + + + +
outq
outq_hash
outq_account
outq_channel
outq_driver
outq_posturl
outq_async
outq_delivered
outq_created
outq_updated
outq_notify
outq_msg
outq_priority
< 3660 rows
> + URL="outq.html" + tooltip="outq" + ]; + "profext" [ + label=< + + + + + + + + +
profext
id
channel_id
hash
k
v
< 30 rows
> + URL="profext.html" + tooltip="profext" + ]; + "register" [ + label=< + + + + + + + + + +
register
id
hash
created
uid
password
language
< 30 rows
> + URL="register.html" + tooltip="register" + ]; + "term" [ + label=< + + + + + + + + + + + + + + +
term
tid
aid
uid
oid
otype
type
term
url
imgurl
term_hash
parent_hash
< 68 980 rows
> + URL="term.html" + tooltip="term" + ]; + "updates" [ + label=< + + + + + + + + + + +
updates
ud_id
ud_hash
ud_guid
ud_date
ud_last
ud_flags
ud_addr
< 30 rows
> + URL="updates.html" + tooltip="updates" + ]; + "xchan" [ + label=< + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
xchan
xchan_hash
xchan_guid
xchan_guid_sig
xchan_pubkey
xchan_photo_mimetype
xchan_photo_l
xchan_photo_m
xchan_photo_s
xchan_addr
xchan_url
xchan_connurl
xchan_follow
xchan_connpage
xchan_name
xchan_network
xchan_instance_url
xchan_flags
xchan_photo_date
xchan_name_date
xchan_hidden
xchan_orphan
xchan_censored
xchan_selfcensored
xchan_system
xchan_pubforum
xchan_deleted
< 22 301 rows35 >
> + URL="xchan.html" + tooltip="xchan" + ]; + "xprof" [ + label=< + + + + + + + + + + + + + + + + + + +
xprof
xprof_hash
xprof_age
xprof_desc
xprof_dob
xprof_gender
xprof_marital
xprof_sexual
xprof_locale
xprof_region
xprof_postcode
xprof_country
xprof_keywords
xprof_about
xprof_homepage
xprof_hometown
< 30 rows
> + URL="xprof.html" + tooltip="xprof" + ]; + "xtag" [ + label=< + + + + + + + +
xtag
xtag_id
xtag_hash
xtag_term
xtag_flags
< 30 rows
> + URL="xtag.html" + tooltip="xtag" + ]; +} -- cgit v1.2.3