Local Ld Import Logs Status Table Schema (local_ld_import_logs_status)


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