fileresources


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
datasetfileresources.fileresource_id datasetfileresources_ibfk_2 C

The primary id.
name VARCHAR 255 null

The name of the file resource.
path TEXT 65535 √ null

The file name of the actual data file.
description TEXT 65535 √ null

A description of the file contents.
filesize BIGINT 19 √ null

The file size in bytes.
fileresourcetype_id INT 10 null
fileresourcetypes.id fileresources_ibfk_1 C

Foreign key to fileresourcetypes.
project_id INT 10 √ null
projects.id fileresources_ibfk_2 N
created_on DATETIME 19 √ CURRENT_TIMESTAMP

When this record was created.
updated_on TIMESTAMP 19 √ CURRENT_TIMESTAMP

When this record was last updated.

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
fileresource_name Performance Asc name
fileresourcetype_id Performance Asc fileresourcetype_id
project_id Performance Asc project_id

Relationships

Close relationships within degrees of separation