Database – Data Import Entity (data_import_entity)
This holds record information for various data import entities.
Column | Data Type | Column Info | Value Notes | Other |
id | int(10) | The id of the entity | ||
entity | varchar(255) | Encoded information about the entity being imported | ||
status | varchar(35) | Status code of the entity | ||
description | varchar(100) | The description of the entity instance | ||
file_name | varchar(255) | Name of the file being imported | ||
reverse_file_name | varchar(100) | Name of the reverse import file | Unused | |
stats_new | int(11) | Number of new entities from the import | ||
stats_upd | int(11) | Number of updated entities from the import | ||
stats_del | int(11) | Number of deleted entities from the import | ||
stats_err | int(11) | Number of rows with errors | ||
by_pass_warnings | tinyint(4) | Whether or not to bypass system warnings | 1 - yes, 0 - no | |
skip_calc | tinyint(4) | Whether or not to bypass running the calculator | 1 - yes, 0 - no | |
errors | mediumtext | List of error codes | ||
lastUpdated | timestamp | Timestamp of when the entity was last updated | ||
created | datetime | Timestamp of when the entity was created | ||
created_by | int(11) | ID of agent user that created the entity | ||
deleted | tinyint(4) | Whether or not the entity was deleted | 1 - yes, 0 - no | |
charged | tinyint(4) | Whether or not to charge for the import | 1 - yes, 0 - no | |
num_rows | int(10) | |||
total_blocks | int(10) | |||
verified_blocks | int(10) | |||
imported_blocks | int(11) |