site_file


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
site_file_rendition.file_id FK_site_file_rendition_site_file C
version BIGINT 19 null
date_created DATETIME 19 √ null
description VARCHAR 255 √ null
folder_id BIGINT 19 null
site_folder.id FKE0304374D4B1C6AE R
last_updated DATETIME 19 √ null
name VARCHAR 255 null
type VARCHAR 255 √ null
expiration_date DATETIME 19 √ null
file_size BIGINT 19 √ null
priority INT 10 √ null
s3name VARCHAR 255 √ null
frequency_id BIGINT 19 √ null
site_file_frequency.id FK_llyrsutfqcac85qnwmc99phh4 R
jurisdiction_id BIGINT 19 √ null
site_file_jurisdiction.id FK_tb1an0gc6vjyfs497g7w6cdi3 R
retained_by_id BIGINT 19 √ null
site_file_retained_by.id FK_gl3q64eqs0ikwep7s0y53atyb R
doc_type_id BIGINT 19 √ null
site_document_type.id FK_n11xfyou23jsxbf80d16jxlyt R
flags INT 10 null
dealer_request_lease_id INT 10 0
license_status VARCHAR 255 √ null
license_type VARCHAR 255 √ null
project_id INT 10 √ null
project.id FK_i26ess8cryx0ii6dyvju3dj8q R
project_manager_id INT 10 √ null
sys_users.user_id FK_j1ne6x668vgh8py3yy7t3753h R
uploader_id INT 10 √ null
sys_users.user_id FK_dn5oc32uovgkoaq0bghjdfyj0 R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_dn5oc32uovgkoaq0bghjdfyj0 Performance Asc uploader_id
FK_gl3q64eqs0ikwep7s0y53atyb Performance Asc retained_by_id
FK_i26ess8cryx0ii6dyvju3dj8q Performance Asc project_id
FK_j1ne6x668vgh8py3yy7t3753h Performance Asc project_manager_id
FK_llyrsutfqcac85qnwmc99phh4 Performance Asc frequency_id
FK_n11xfyou23jsxbf80d16jxlyt Performance Asc doc_type_id
FK_tb1an0gc6vjyfs497g7w6cdi3 Performance Asc jurisdiction_id
FKE0304374D4B1C6AE Performance Asc folder_id
folder_id Must be unique Asc/Asc folder_id + name
unique_name Must be unique Asc/Asc folder_id + name

Relationships

Close relationships within degrees of separation