project_folder


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
project_file.folder_id FK37FA6AE28DB3D838 R
project_folder.parent_id FK235FD054E9A9B27C R
vendor_task.photo_album_id FK_p0g96mntnormr9hhy733wcheo R
version BIGINT 19 null
date_created DATETIME 19 √ null
description VARCHAR 255 √ null
last_updated DATETIME 19 √ null
name VARCHAR 255 null
parent_id BIGINT 19 √ null
project_folder.id FK235FD054E9A9B27C R
project_id INT 10 null
project.id FK235FD054FE2B983 R
system BIT 1 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK235FD054E9A9B27C Performance Asc parent_id
FK235FD054FE2B983 Performance Asc project_id
name Must be unique Asc/Asc/Asc project_id + parent_id + name
unique_name Must be unique Asc/Asc/Asc parent_id + project_id + name

Relationships

Close relationships within degrees of separation