os_bulk_import_jobs

9 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDENTIFIER BIGINT 19 √ null
os_bulk_import_job_params.JOB_ID FK_JOB_PARAMS_JOB_IDR
NAME VARCHAR 32 null
TYPE VARCHAR 16 null
STATUS VARCHAR 16 null
TOTAL_RECORDS BIGINT 19 √ null
FAILED_RECORDS BIGINT 19 √ null
CREATED_BY BIGINT 19 null
catissue_user.IDENTIFIER FK_OS_BLK_IMP_JOBS_CREATED_BYR
CREATION_TIME TIMESTAMP 19 null
END_TIME TIMESTAMP 19 √ null
PARAMS VARCHAR 512 √ null
DATE_FORMAT VARCHAR 16 √ null
TIME_FORMAT VARCHAR 16 √ null
ATOMIC BIT 1 √ null
FIELD_SEPARATOR VARCHAR 1 √ null
TIME_ZONE VARCHAR 32 √ null
RUN_BY_NODE VARCHAR 32 √ none
STOP_RUNNING BIT 1 √ b'0'
IP_ADDRESS VARCHAR 255 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc IDENTIFIER
FK_OS_BLK_IMP_JOBS_CREATED_BY Performance Asc CREATED_BY

Relationships

Close relationships within degrees of separation