exc_import_report


Columns

Column Type Size Nulls Auto Default Children Parents Comments
identifier VARCHAR 191 null
exc_doc_unit.report fk_exc_doc_unit_report R
exc_import_file.report fk_exc_import_file_report R
exc_import_report.parent fk_exc_import_report_parent R
library VARCHAR 191 null
lib_library.identifier fk_exc_import_report_library R
mapping VARCHAR 191 √ NULL
exc_mapping.identifier fk_exc_import_report_mapping R
mapping_children VARCHAR 191 √ NULL
exc_mapping.identifier fk_exc_import_report_mapping_perio R
file_format VARCHAR 255 √ NULL
data_encoding VARCHAR 255 √ NULL
start_import TIMESTAMP 19 √ NULL
end_import TIMESTAMP 19 √ NULL
run_by VARCHAR 255 √ NULL
status VARCHAR 255 √ NULL
message TEXT 65535 √ NULL
version BIGINT 19 null
created_by VARCHAR 255 'system'
last_modified_by VARCHAR 255 'system'
created_date TIMESTAMP 19 current_timestamp()
last_modified_date TIMESTAMP 19 current_timestamp()
csv_mapping VARCHAR 191 √ NULL
exc_csv_mapping.identifier fk_exc_import_report_csv_mapping R
nb_imp INT 10 √ NULL
type VARCHAR 255 'SIMPLE'
project VARCHAR 191 √ NULL
proj_project.identifier fk_exc_import_report_project R
lot VARCHAR 191 √ NULL
lot_lot.identifier fk_exc_import_report_lot R
add_mapping VARCHAR 255 √ NULL
parent VARCHAR 191 √ NULL
exc_import_report.identifier fk_exc_import_report_parent R
join_expression TEXT 65535 √ NULL

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc identifier
fk_exc_import_report_csv_mapping Performance Asc csv_mapping
idx_exc_import_report_library Performance Asc library
idx_exc_import_report_lot Performance Asc lot
idx_exc_import_report_mapping Performance Asc mapping
idx_exc_import_report_mapping_perio Performance Asc mapping_children
idx_exc_import_report_parent Performance Asc parent
idx_exc_import_report_project Performance Asc project

Relationships

Close relationships within degrees of separation