feed_export


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
feed_encryption_key.feed_export_id FK_hl813fpda46detm96hy4cw9t4 R
feed_log.export_id FKF494B923DC70672A R
feed_schedule.export_id FK18015018DC70672A R
version BIGINT 19 null
user_id INT 10 √ null
sys_users.user_id FK1BA73D7528C762A3 R
description TEXT 65535 √ null
destination VARCHAR 200 null
exported DATETIME 19 √ null
name VARCHAR 100 null
password VARCHAR 100 √ null
rows INT 10 null
list_id INT 10 √ null
projectlist_custom.id FK1BA73D7568603D9C R
report_id INT 10 √ null
reports.report_id FK1BA73D757D387CEC R
username VARCHAR 40 √ null
append_date BIT 1 √ null
date_format VARCHAR 255 √ null
export_start_time DATETIME 23 √ null
feed_status INT 10 √ null
last_failure_time DATETIME 23 √ null
last_result LONGTEXT 2147483647 √ null
last_success_time DATETIME 23 √ null
last_file_name VARCHAR 255 √ null
custom_footer VARCHAR 512 √ null
custom_header VARCHAR 512 √ null
delimiter VARCHAR 1 ,
encrypt BIT 1 b'0'
quote_char VARCHAR 1 √ "
skip_column_headers BIT 1 b'0'
active BIT 1 b'1'
business_poc VARCHAR 200 √ null
technical_poc VARCHAR 200 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK1BA73D7528C762A3 Performance Asc user_id
FK1BA73D7568603D9C Performance Asc list_id
FK1BA73D757D387CEC Performance Asc report_id

Relationships

Close relationships within degrees of separation