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/attach.html | 513 +++++++++++++++++++++++++++++++++++++++++ 1 file changed, 513 insertions(+) create mode 100644 hubzilla_er/tables/attach.html (limited to 'hubzilla_er/tables/attach.html') diff --git a/hubzilla_er/tables/attach.html b/hubzilla_er/tables/attach.html new file mode 100644 index 000000000..ea0353d38 --- /dev/null +++ b/hubzilla_er/tables/attach.html @@ -0,0 +1,513 @@ + + + + + SchemaSpy - Table zot.attach + + + + + + + +
+ +
+
+ + + + + +
Table zot.attachGenerated 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
+
aidint unsigned100
uidint unsigned100
hashchar64
creatorchar128
filenamechar255
filetypechar64
filesizeint unsigned100
revisionint unsigned100
folderchar64
flagsint unsigned100
is_dirbit00
is_photobit00
os_storagebit00
os_pathmediumtext16777215
display_pathmediumtext16777215
datalongblob2147483647
createddatetime190000-00-00 00:00:00
editeddatetime190000-00-00 00:00:00
allow_cidmediumtext16777215
allow_gidmediumtext16777215
deny_cidmediumtext16777215
deny_gidmediumtext16777215
+

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

+

+
+Indexes: ++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
aidPerformanceAscaid
createdPerformanceAsccreated
creatorPerformanceAsccreator
editedPerformanceAscedited
filenamePerformanceAscfilename
filesizePerformanceAscfilesize
filetypePerformanceAscfiletype
flagsPerformanceAscflags
folderPerformanceAscfolder
hashPerformanceAschash
is_dirPerformanceAscis_dir
is_photoPerformanceAscis_photo
os_storagePerformanceAscos_storage
revisionPerformanceAscrevision
uidPerformanceAscuid
+
+
+
Close relationships:
+ + + + + + + + + + + + + + + + + + + + + + + + + + + + +
+
+ + -- cgit v1.2.3