projects


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
experiments.project_id experiments_ibfk_1 N
fileresources.project_id fileresources_ibfk_2 N
projectcollaborators.project_id projectcollaborators_ibfk_2 C
projectgroups.project_id projectgroups_ibfk_2 C
projectpublications.project_id projectpublications_ibfk_1 C
stories.project_id stories_ibfk_2 N
name VARCHAR 255 null
description TEXT 65535 √ null
page_content LONGTEXT 2147483647 √ null
external_url TEXT 65535 √ null
image_id INT 10 √ null
images.id projects_ibfk_1 N
start_date DATETIME 19 √ null
end_date DATETIME 19 √ null
created_on DATETIME 19 CURRENT_TIMESTAMP
updated_on TIMESTAMP 19 CURRENT_TIMESTAMP

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
image_id Performance Asc image_id

Relationships

Close relationships within degrees of separation