Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
identifier | VARCHAR | 191 | null |
|
|
||||||||||||
library | VARCHAR | 191 | null |
|
|
||||||||||||
mapping | VARCHAR | 191 | √ | NULL |
|
|
|||||||||||
mapping_children | VARCHAR | 191 | √ | NULL |
|
|
|||||||||||
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 |
|
|
|||||||||||
nb_imp | INT | 10 | √ | NULL |
|
|
|||||||||||
type | VARCHAR | 255 | 'SIMPLE' |
|
|
||||||||||||
project | VARCHAR | 191 | √ | NULL |
|
|
|||||||||||
lot | VARCHAR | 191 | √ | NULL |
|
|
|||||||||||
add_mapping | VARCHAR | 255 | √ | NULL |
|
|
|||||||||||
parent | VARCHAR | 191 | √ | NULL |
|
|
|||||||||||
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 |