Table 1: topic_analysis.schedule_history

schedule_history_id

bigserial

(Integer)

The row id indicates sequence of data

schedule_list_id

Integer

The value indicates the row of data that stores in the schedule_list

company

String

The name of a company data that has been processed in the Topic Analysis function

organisation

String

The organisation that related to the company field

folder

String

The folder location that the company data are stored

comprehend_job_id

String

The id of a specific process_date, which is created by Comprehend service

process_date

Date

The start date of the processed data

dats_to_analyse

Integer

This field indicates how many days of data were analysed, which counting backwards from the process_date

update_time

Date/Time

The date and time that data is updated

insert_time

Date/Time

The date and time that data is written into the table