Table 4: topic_analysis.topic_terms

This table is used for expanding topic data in the doc_topics table which can be joined by topic_number and comprehend_job_id. It contains groups of 10 words in a topic, weight score and word counter.

Field	Type	Description

Field	Type	Description
comprehend_job_id	String	The unique identification that can be retrieved Amazon Comprehend job details, and uses for joining data with doc_topic table
topic_number	Integer	The number of a topic that calls possibly related
dict_data	String	A collection of data can be used as dictionary object or JSON. term: Word/ Vocaburary weight: a score explaining how a word contribute to the topic count: the frequency of a word found in a transcroption
company	String	Name of the company who owns a record data
organisation	String	Group of a company that helps to scope record data
folder	String	The Folder field that store data in Wordbench.
insert_time	Date/ Time	The date and time that data has been written into this table