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/abook.html | 502 ++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 502 insertions(+) create mode 100644 hubzilla_er/tables/abook.html (limited to 'hubzilla_er/tables/abook.html') diff --git a/hubzilla_er/tables/abook.html b/hubzilla_er/tables/abook.html new file mode 100644 index 000000000..7e103df6f --- /dev/null +++ b/hubzilla_er/tables/abook.html @@ -0,0 +1,502 @@ + + + + + SchemaSpy - Table zot.abook + + + + + + + +
+ +
+
+ + + + + +
Table zot.abookGenerated by
SchemaSpy
+ +
+
+ + + + +
+		 + + + + + + +
Legend:SourceForge.net
+ + + + + + + +
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
+
+
+ + +
+  +
+ + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
abook_idint unsigned10 √ 
abook_accountint unsigned100
abook_channelint unsigned100
abook_xchanchar255
abook_my_permsint100
abook_their_permsint100
abook_closenesstinyint unsigned399
abook_createddatetime190000-00-00 00:00:00
abook_updateddatetime190000-00-00 00:00:00
abook_connecteddatetime190000-00-00 00:00:00
abook_dobdatetime190000-00-00 00:00:00
abook_flagsint100
abook_blockedtinyint30
abook_ignoredtinyint30
abook_hiddentinyint30
abook_archivedtinyint30
abook_pendingtinyint30
abook_unconnectedtinyint30
abook_selftinyint30
abook_feedtinyint30
abook_profilechar64
abook_incltext65535
abook_excltext65535
+

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

+

+
+Indexes: ++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Column(s)TypeSortConstraint Name
abook_idPrimary keyAscPRIMARY
abook_accountPerformanceAscabook_account
abook_archivedPerformanceAscabook_archived
abook_blockedPerformanceAscabook_blocked
abook_channelPerformanceAscabook_channel
abook_closenessPerformanceAscabook_closeness
abook_connectedPerformanceAscabook_connected
abook_createdPerformanceAscabook_created
abook_dobPerformanceAscabook_dob
abook_feedPerformanceAscabook_feed
abook_flagsPerformanceAscabook_flags
abook_hiddenPerformanceAscabook_hidden
abook_ignoredPerformanceAscabook_ignored
abook_my_permsPerformanceAscabook_my_perms
abook_pendingPerformanceAscabook_pending
abook_profilePerformanceAscabook_profile
abook_selfPerformanceAscabook_self
abook_their_permsPerformanceAscabook_their_perms
abook_unconnectedPerformanceAscabook_unconnected
abook_updatedPerformanceAscabook_updated
abook_xchanPerformanceAscabook_xchan
+
+
+ + -- cgit v1.2.3