feed_import


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
feed_log.import_id FKF494B923BD0D958A R
feed_schedule.import_id FK18015018BD0D958A R
version BIGINT 19 null
description TEXT 65535 √ null
header LONGTEXT 2147483647 √ null
imported DATETIME 19 √ null
name VARCHAR 100 null
password VARCHAR 100 √ null
source VARCHAR 200 null
username VARCHAR 40 √ null
feed_status INT 10 √ null
import_start_time DATETIME 23 √ null
last_failure_time DATETIME 23 √ null
last_result LONGTEXT 2147483647 √ null
last_success_time DATETIME 23 √ null
last_file_name VARCHAR 255 √ null
valid_from_address VARCHAR 200 √ null
post_process_action LONGTEXT 2147483647 √ null
post_process_type VARCHAR 255 √ null
column_based_processing BIT 1 null
business_poc VARCHAR 200 √ null
technical_poc VARCHAR 200 √ null
last_new_file_date DATETIME 23 √ null
last_file_checksum VARCHAR 64 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
name Must be unique Asc name

Relationships

Close relationships within degrees of separation