temporary_files


Description

Temporary files, e.g. where files are kept during an upload process before they are moved somewhere more appropriate.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
file_id BIGINT 19 √ null
user_id BIGINT 19 null
users.user_id temporary_files_user_idC
file_name VARCHAR 90 null
file_type VARCHAR 255 √ NULL
file_size BIGINT 19 null
original_file_name VARCHAR 127 √ NULL
date_uploaded DATETIME 19 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc file_id
temporary_files_user_id Performance Asc user_id

Relationships

Close relationships within degrees of separation