bulk_validation_job


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
bulk_validation_line.job_id FK_bulk_val_job_line_job R
status_id INT 10 null
job_type VARCHAR 128 null
user_id INT 10 null
create_date DATETIME 23 √ null
complete_date DATETIME 23 √ null
job_id BIGINT 19 √ null
header TEXT 65535 √ null
props TEXT 65535 √ null
file_name TEXT 65535 √ null
s3_name TEXT 65535 √ null
data_cache LONGTEXT 2147483647 √ null
errors LONGTEXT 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
IX_bulk_val_job_status Performance Asc/Asc status_id + user_id

Relationships

Close relationships within degrees of separation