wsspoonlog


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id_batch int8 19 null
wsspoonlog_aud.id_batch Implied Constraint R
transname varchar 255 √ null
status varchar 15 √ null
lines_rollback int8 19 √ null
lines_updated int8 19 √ null
lines_read int8 19 √ null
lines_insert int8 19 √ null
lines_fatal int8 19 √ null
errors int8 19 √ null
startdate timestamp 29,6 √ null
enddate timestamp 29,6 √ null
logdate timestamp 29,6 √ null
depdate timestamp 29,6 √ null
lines_processed int8 19 √ null
wsversao int8 19 √ null

Indexes

Constraint Name Type Sort Column(s)
pk3628118f Primary key Asc id_batch
idx_wsspoonlog_1 Performance Asc id_batch
idx_wsspoonlog_2 Performance Asc/Asc/Asc errors + status + transname
idxwsversao_3628118f Performance Desc wsversao

Relationships

Close relationships within degrees of separation