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/tables/item.html | 1315 ++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 1315 insertions(+) create mode 100644 hubzilla_er/tables/item.html (limited to 'hubzilla_er/tables/item.html') diff --git a/hubzilla_er/tables/item.html b/hubzilla_er/tables/item.html new file mode 100644 index 000000000..8f2684aa5 --- /dev/null +++ b/hubzilla_er/tables/item.html @@ -0,0 +1,1315 @@ + + + + + SchemaSpy - Table zot.item + + + + + + + +
+ +
+
+ + + + + +
Table zot.itemGenerated by
SchemaSpy
+ +
+
+ + + + + +
+		 + + + + + + +
Legend:SourceForge.net
+ + + + + + + +
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
+
+
+ + +
+  +
+ + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
idint unsigned10 √  + + + + + +
verify.id + Implied Constraint R
+
midchar255
aidint unsigned100
uidint unsigned100
parentint unsigned100
parent_midchar255
thr_parentchar255
createddatetime190000-00-00 00:00:00
editeddatetime190000-00-00 00:00:00
expiresdatetime190000-00-00 00:00:00
commenteddatetime190000-00-00 00:00:00
receiveddatetime190000-00-00 00:00:00
changeddatetime190000-00-00 00:00:00
comments_closeddatetime190000-00-00 00:00:00
owner_xchanchar255
author_xchanchar255
source_xchanchar255
mimetypechar255
titletext65535
bodymediumtext16777215
htmlmediumtext16777215
appchar255
langchar64
revisionint unsigned100
verbchar255
obj_typechar255
objecttext65535
tgt_typechar255
targettext65535
layout_midchar255
postoptstext65535
routetext65535
llinkchar255
plinkchar255
resource_idchar255
resource_typechar16
attachmediumtext16777215
sigtext65535
diaspora_metamediumtext16777215
locationchar255
coordchar255
public_policychar255
comment_policychar255
allow_cidmediumtext16777215
allow_gidmediumtext16777215
deny_cidmediumtext16777215
deny_gidmediumtext16777215
item_restrictint100
item_flagsint100
item_privatebit00
item_originbit00
item_unseenbit00
item_starredbit00
item_uplinkbit00
item_consensusbit00
item_wallbit00
item_thread_topbit00
item_notshownbit00
item_nsfwbit00
item_relaybit00
item_mentionsmebit00
item_nocommentbit00
item_obscuredbit00
item_verifiedbit00
item_retainedbit00
item_rssbit00
item_deletedbit00
item_typeint100
item_hiddenbit00
item_unpublishedbit00
item_delayedbit00
item_pending_removebit00
item_blockedbit00
+

Table contained 9 613 rows at on aug 19 21:08 CEST 2015

+

+
+Indexes: ++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
aidPerformanceAscaid
allow_cidPerformanceAscallow_cid
allow_gidPerformanceAscallow_gid
author_xchanPerformanceAscauthor_xchan
bodyPerformanceAscbody
changedPerformanceAscchanged
comment_policyPerformanceAsccomment_policy
commentedPerformanceAsccommented
comments_closedPerformanceAsccomments_closed
createdPerformanceAsccreated
deny_cidPerformanceAscdeny_cid
deny_gidPerformanceAscdeny_gid
editedPerformanceAscedited
expiresPerformanceAscexpires
item_blockedPerformanceAscitem_blocked
item_consensusPerformanceAscitem_consensus
item_delayedPerformanceAscitem_delayed
item_deletedPerformanceAscitem_deleted
item_flagsPerformanceAscitem_flags
item_hiddenPerformanceAscitem_hidden
item_mentionsmePerformanceAscitem_mentionsme
item_nocommentPerformanceAscitem_nocomment
item_notshownPerformanceAscitem_notshown
item_nsfwPerformanceAscitem_nsfw
item_obscuredPerformanceAscitem_obscured
item_originPerformanceAscitem_origin
item_pending_removePerformanceAscitem_pending_remove
item_privatePerformanceAscitem_private
item_relayPerformanceAscitem_relay
item_restrictPerformanceAscitem_restrict
item_retainedPerformanceAscitem_retained
item_rssPerformanceAscitem_rss
item_starredPerformanceAscitem_starred
item_thread_topPerformanceAscitem_thread_top
item_typePerformanceAscitem_type
item_unpublishedPerformanceAscitem_unpublished
item_unseenPerformanceAscitem_unseen
item_uplinkPerformanceAscitem_uplink
item_verifiedPerformanceAscitem_verified
item_wallPerformanceAscitem_wall
layout_midPerformanceAsclayout_mid
llinkPerformanceAscllink
midPerformanceAscmid
mimetypePerformanceAscmimetype
owner_xchanPerformanceAscowner_xchan
parentPerformanceAscparent
parent_midPerformanceAscparent_mid
public_policyPerformanceAscpublic_policy
receivedPerformanceAscreceived
resource_typePerformanceAscresource_type
revisionPerformanceAscrevision
titlePerformanceAsctitle
uidPerformanceAscuid
uid + commentedPerformanceAsc/Ascuid_commented
uid + createdPerformanceAsc/Ascuid_created
mid + uidPerformanceAsc/Ascuid_mid
verbPerformanceAscverb
+
+
+
Close relationships:
+ + + + + + + + + + + + + + + + + + + + + + + + + + + + +
+
+ + -- cgit v1.2.3