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 --- doc/schemaspy_hubzilla/tables/xchan.html | 821 +++++++++++++++++++++++++++++++ 1 file changed, 821 insertions(+) create mode 100644 doc/schemaspy_hubzilla/tables/xchan.html (limited to 'doc/schemaspy_hubzilla/tables/xchan.html') diff --git a/doc/schemaspy_hubzilla/tables/xchan.html b/doc/schemaspy_hubzilla/tables/xchan.html new file mode 100644 index 000000000..f9f06261f --- /dev/null +++ b/doc/schemaspy_hubzilla/tables/xchan.html @@ -0,0 +1,821 @@ + + + + + SchemaSpy - Table zot.xchan + + + + + + + +
+ +
+
+ + + + + +
Table zot.xchanGenerated by
SchemaSpy
+ +
+
+ + + + + +
+		 + + + + + + +
Legend:SourceForge.net
+ + + + + + + +
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
+
+
+ + +
+  +
+ + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
xchan_hashchar255 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
abook.abook_xchan + Defined in XML R
attach.hash + Defined in XML R
channel.channel_hash + Defined in XML R
chat.chat_xchan + Defined in XML R
chatpresence.cp_xchan + Defined in XML R
dreport.dreport_xchan + Defined in XML R
event.event_hash + Defined in XML R
event.event_xchan + Defined in XML R
group_member.xchan + Defined in XML R
groups.hash + Defined in XML R
hubloc.hubloc_hash + Defined in XML R
item.author_xchan + Defined in XML R
item.owner_xchan + Defined in XML R
item.source_xchan + Defined in XML R
mail.from_xchan + Defined in XML R
mail.to_xchan + Defined in XML R
manage.xchan + Defined in XML R
notify.hash + Defined in XML R
outq.outq_hash + Defined in XML R
photo.xchan + Defined in XML R
profext.hash + Defined in XML R
register.hash + Defined in XML R
shares.share_xchan + Defined in XML R
source.src_channel_xchan + Defined in XML R
source.src_xchan + Defined in XML R
term.parent_hash + Defined in XML R
term.term_hash + Defined in XML R
updates.ud_hash + Defined in XML R
vote.vote_xchan + Defined in XML R
xchat.xchat_xchan + Defined in XML R
xconfig.xchan + Defined in XML R
xign.xchan + Defined in XML R
xlink.xlink_xchan + Defined in XML R
xprof.xprof_hash + Defined in XML R
xtag.xtag_hash + Defined in XML R
+		 + + + + + + + + + +
hubloc.hubloc_hash + Defined in XML R
channel.channel_hash + Defined in XML R
+
xchan_guidchar255
xchan_guid_sigtext65535
xchan_pubkeytext65535
xchan_photo_mimetypechar32image/jpeg
xchan_photo_lchar255
xchan_photo_mchar255
xchan_photo_schar255
xchan_addrchar255
xchan_urlchar255
xchan_connurlchar255
xchan_followchar255
xchan_connpagechar255
xchan_namechar255
xchan_networkchar255
xchan_instance_urlchar255
xchan_flagsint unsigned100
xchan_photo_datedatetime190000-00-00 00:00:00
xchan_name_datedatetime190000-00-00 00:00:00
xchan_hiddenbit00
xchan_orphanbit00
xchan_censoredbit00
xchan_selfcensoredbit00
xchan_systembit00
xchan_pubforumbit00
xchan_deletedbit00
+

Table contained 2 301 rows at fr nov 06 17:11 CET 2015

+

+
+Indexes: ++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Column(s)TypeSortConstraint Name
xchan_hashPrimary keyAscPRIMARY
xchan_addrPerformanceAscxchan_addr
xchan_censoredPerformanceAscxchan_censored
xchan_connurlPerformanceAscxchan_connurl
xchan_deletedPerformanceAscxchan_deleted
xchan_flagsPerformanceAscxchan_flags
xchan_followPerformanceAscxchan_follow
xchan_guidPerformanceAscxchan_guid
xchan_hiddenPerformanceAscxchan_hidden
xchan_instance_urlPerformanceAscxchan_instance_url
xchan_namePerformanceAscxchan_name
xchan_networkPerformanceAscxchan_network
xchan_orphanPerformanceAscxchan_orphan
xchan_pubforumPerformanceAscxchan_pubforum
xchan_selfcensoredPerformanceAscxchan_selfcensored
xchan_systemPerformanceAscxchan_system
xchan_urlPerformanceAscxchan_url
+
+
+
Close relationships:
+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
+
+ + -- cgit v1.2.3