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/verify.html | 383 +++++++++++++++++++++++++++++++++++++++++ 1 file changed, 383 insertions(+) create mode 100644 hubzilla_er/tables/verify.html (limited to 'hubzilla_er/tables/verify.html') diff --git a/hubzilla_er/tables/verify.html b/hubzilla_er/tables/verify.html new file mode 100644 index 000000000..e01eb4f62 --- /dev/null +++ b/hubzilla_er/tables/verify.html @@ -0,0 +1,383 @@ + + + + + SchemaSpy - Table zot.verify + + + + + + + +
+ +
+
+ + + + + +
Table zot.verifyGenerated by
SchemaSpy
+ +
+
+ + + + + +
+		 + + + + + + +
Legend:SourceForge.net
+ + + + + + + +
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
+
+
+ + +
+  +
+ + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
idint unsigned10 √  + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
attach.id + Implied Constraint R
config.id + Implied Constraint R
conv.id + Implied Constraint R
fcontact.id + Implied Constraint R
ffinder.id + Implied Constraint R
group_member.id + Implied Constraint R
groups.id + Implied Constraint R
item.id + Implied Constraint R
item_id.id + Implied Constraint R
likes.id + Implied Constraint R
mail.id + Implied Constraint R
photo.id + Implied Constraint R
profdef.id + Implied Constraint R
profext.id + Implied Constraint R
profile_check.id + Implied Constraint R
register.id + Implied Constraint R
sign.id + Implied Constraint R
sys_perms.id + Implied Constraint R
xconfig.id + Implied Constraint R
xign.id + Implied Constraint R
+
channelint unsigned100
typechar32
tokenchar255
metachar255
createddatetime190000-00-00 00:00:00
+

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

+

+
+Indexes: ++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
channelPerformanceAscchannel
createdPerformanceAsccreated
metaPerformanceAscmeta
tokenPerformanceAsctoken
typePerformanceAsctype
+
+
+
Close relationships:
+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
+
+ + -- cgit v1.2.3