Table topp.deprecated.files Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
fileid int4 10
textfiles.fileid Implied Constraint R
sessionid int4 10  √  null
session.sessionid Implied Constraint R
fileoid int4 10  √  null
tagid int4 10  √  null
conventionaltags.tagid Implied Constraint R
tagmodelid int4 10  √  null
tagmodels.tagmodelid Implied Constraint R
projectid int4 10  √  null
projects.projectid Implied Constraint R
speciescode varchar 2  √  null
species.speciescode Implied Constraint R
server text 2147483647  √  null
path text 2147483647  √  null
filename varchar 255  √  null
filetype text 2147483647  √  null
fileformat text 2147483647  √  null
useclassid int4 10  √  null
fileuseclasses.useclassid Implied Constraint R
subclassid int4 10  √  null
oldpath text 2147483647  √  null
oldname text 2147483647  √  null
datetime timestamptz 35,6  √  null
hashcode int8 19  √  null
processid int4 10  √  null
dataprocessingdefs.processid Implied Constraint R
version varchar 80  √  null
sequenceno int4 10  √  null
deploymentid int4 10  √  null
filecomment varchar 1023  √  null

Table contained 2,604 rows at Wed Dec 27 13:21 PST 2017

Indexes:
Column(s) Type Sort Constraint Name Anomalies
fileid Primary key Asc files_pkey  
sessionid + filetype + fileformat Must be unique Asc/Asc/Asc filesuniqueattributes These unique columns are also nullable

Close relationships: