bulk_validation_line


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
job_id BIGINT 19 null
bulk_validation_job.id FK_bulk_val_job_line_job R
line_number INT 10 null
stores_non_branded.number Implied Constraint R
status_id INT 10 null
process_date DATETIME 23 √ null
line 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 job_id + line_number

Relationships

Close relationships within degrees of separation