file_extract_job


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
file_extract_file.file_extract_job_id FK_mfj4d4yvk43tbwmrkhce36pip R
complete_date DATETIME 19 √ null
create_date DATETIME 19 null
expiration_date DATETIME 19 √ null
file_size BIGINT 19 null
file_type VARCHAR 20 null
message LONGTEXT 2147483647 √ null
name VARCHAR 80 null
status INT 10 null
storage_path VARCHAR 1024 null
storage_type INT 10 null
sys_monitor_types.type Implied Constraint R
temporary_path VARCHAR 1024 √ null
user_id INT 10 null
sys_users.user_id FK_kcgosi7hupastpro89k58ovjg R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_kcgosi7hupastpro89k58ovjg Performance Asc user_id

Relationships

Close relationships within degrees of separation