From 20dcf37976ee269adcb2c004c5f612d8509b7f11 Mon Sep 17 00:00:00 2001 From: redmatrix Date: Tue, 15 Dec 2015 17:42:49 -0800 Subject: issue #221 --- hubzilla_er/tables/item.html | 1315 ------------------------------------------ 1 file changed, 1315 deletions(-) delete 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 deleted file mode 100644 index 8f2684aa5..000000000 --- a/hubzilla_er/tables/item.html +++ /dev/null @@ -1,1315 +0,0 @@ - - - - - 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