program_file


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
program_workflow.published_file_id FK_gasdkt7mql4ca7c13i3gtyq7l R
program_workflow_log.file_id FK_bf5r00hkf89qhvsa0mjhyk1vm R
date_created DATETIME 19 √ null
description VARCHAR 255 √ null
extension VARCHAR 255 √ null
file_size BIGINT 19 √ null
folder_id BIGINT 19 null
program_folder.id FK_tdy9ta026virwhrdkpabir6e6 R
last_update_user_id INT 10 √ null
sys_users.user_id FK_xhg8cvicwaj2e2od1ngcwq4j R
last_updated DATETIME 19 √ null
name VARCHAR 255 null
s3name VARCHAR 255 √ null
system BIT 1 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_xhg8cvicwaj2e2od1ngcwq4j Performance Asc last_update_user_id
unique_name Must be unique Asc/Asc folder_id + name

Relationships

Close relationships within degrees of separation