Local Ld Import Logs Status Table Schema (local_ld_import_logs_status)


Description

Current status of the import logs task

local_ld_import_logs_status table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
adhoctaskid BIGINT 19 √ null
task_adhoc.id localdimpologsstat_adh2_fk R

Import logs task id
status VARCHAR 20 notscheduled

Current status of the import log task ('notscheduled', 'scheduled', 'inprogress', 'finished')
progress DECIMAL 10,2 0.00

Percentage of work done (0 - 100)
timestarted BIGINT 19 √ null

When the import logs task started
timemodified BIGINT 19 √ null

Time of last status update. Used to predict remaining time left.
timefinished BIGINT 19 √ null

When the import logs tash finished

Table contained -1 rows

local_ld_import_logs_status table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
localdimpologsstat_adh_ix Performance Asc adhoctaskid

local_ld_import_logs_status table relationships

Close relationships within degrees of separation