dealer_request_file


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
date_created DATETIME 19 √ null
description VARCHAR 255 √ null
folder_id BIGINT 19 null
dealer_request_folder.id fk_drfi_folder_id R
last_updated DATETIME 19 √ null
name VARCHAR 255 null
type VARCHAR 255 √ null
file_size BIGINT 19 √ null
s3name VARCHAR 255 √ null
original_creation_date DATETIME 19 √ null
label VARCHAR 50 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
fk_drfi_folder_id Performance Asc folder_id
uk_drfi_folder_id Must be unique Asc/Asc folder_id + name
uk_drfi_unique_name Must be unique Asc/Asc folder_id + name

Relationships

Close relationships within degrees of separation