Fivetran documentation

Search the docs

/

Loopio

Explore the interactive ERD

Table & Field Reference

project

Column	Type	Keys
`id`	Unknown	PK
`creator_id`	Unknown	FK
`owner_id`	Unknown	FK
`company_name`	Unknown
`created_date`	Unknown
`creator_name`	Unknown
`description`	Unknown
`due_date`	Unknown
`name`	Unknown
`status`	Unknown
`type`	Unknown

view_basic_information

Column	Type	Keys
`id`	Unknown	PK
`creator_id`	Unknown	FK
`project_id`	Unknown	FK
`created_date`	Unknown
`creator_name`	Unknown
`file_extension`	Unknown
`file_name`	Unknown
`guid`	Unknown
`is_import_document`	Unknown
`last_updated`	Unknown
`last_updated_date`	Unknown
`size`	Unknown
`status`	Unknown
`url`	Unknown

compliance_set_option

Column	Type	Keys
`index`	Unknown	PK
`compliance_set_id`	Unknown	PKFK
`label`	Unknown

compliance_set

Column	Type	Keys
`id`	Unknown	PKFK
`label`	Unknown
`project_id`	Unknown
`short_name`	Unknown

project_merge_variable_value

Column	Type	Keys
`_fivetran_id`	String	PK
`project_id`	Unknown	FK
`deal_size`	Unknown
`uninitialized_variable`	Unknown

custom_project_fields_value

Column	Type	Keys
`_fivetran_id`	String	PK
`project_id`	Unknown	FK
`accessed_the_trust_portal`	Unknown
`amount`	Unknown
`blocked_reason`	Unknown
`is_blocked`	Unknown
`msa_or_mnda_signed_`	Unknown
`opportunity_owner`	Unknown
`opportunity_url`	Unknown
`priority`	Unknown
`product_being_pitched`	Unknown
`security_packet_shared_already`	Unknown
`uninitialized_field`	Unknown

project_subsection

Column	Type	Keys
`id`	Unknown	PK
`project_id`	Unknown	FK
`section_id`	Unknown	FK
`name`	Unknown

project_summary

Column	Type	Keys
`id`	Unknown	PK
`project_id`	Unknown	FK
`is_complete`	Unknown
`questions_assigned`	Unknown
`questions_complete`	Unknown
`questions_review`	Unknown
`questions_total`	Unknown
`questions_unassigned`	Unknown
`workdays_elapsed`	Unknown
`workdays_lefts`	Unknown
`workdays_total`	Unknown

project_entries_compliance_answer

Column	Type	Keys
`id`	Unknown	PK
`project_entries_id`	Unknown	PKFK
`option`	Unknown

project_entries

Column	Type	Keys
`id`	Unknown	PK
`project_id`	Unknown	FK
`section_id`	Unknown	FK
`sub_section_id`	Unknown	FK

library_entries_question

Column	Type	Keys
`id`	Unknown	PK
`library_entries_id`	Unknown	PKFK
`compliance_option_id`	Unknown	FK
`compliance_option_text`	Unknown
`text`	Unknown

library_entries_tag

Column	Type	Keys
`index`	Unknown	PK
`library_entries_id`	Unknown	PKFK
`tags`	Json

library_entries_answer_footnote

Column	Type	Keys
`_fivetran_id`	String	PK
`library_entries_id`	Unknown	FK
`answer_export_text`	Unknown
`answer_text`	Unknown
`footnote_id`	Unknown
`footnote_name`	Unknown
`footnote_text`	Unknown

library_entries_inline_image

Column	Type	Keys
`id`	Unknown	PK
`library_entries_id`	Unknown	PKFK
`url`	Unknown

library_entries

Column	Type	Keys
`id`	Unknown	PK
`category_id`	Unknown	FK
`creator_id`	Unknown	FK
`last_reviewed_by_id`	Unknown	FK
`last_updated_by_id`	Unknown	FK
`library_entry_owner_id`	Unknown	FK
`stack_id`	Unknown	FK
`sub_category_id`	Unknown	FK
`answer_text`	Unknown
`attachment_count`	Unknown
`category_name`	Unknown
`created_date`	Unknown
`creator_name`	Unknown
`language_code`	Unknown
`last_reviewed_by_name`	Unknown
`last_reviewed_date`	Unknown
`last_updated_by_name`	Unknown
`last_updated_date`	Unknown
`library_entry_owner_initials`	Unknown
`library_entry_owner_name`	Unknown
`location_stack_name`	Unknown
`location_stack_stack_id`	Unknown
`scores_freshness`	Unknown
`scores_time`	Unknown
`scores_usage`	Unknown
`status`	Unknown
`sub_category_name`	Unknown

user_role

Column	Type	Keys
`id`	Unknown	PK
`name`	Unknown
`type`	Unknown

users

Column	Type	Keys
`id`	Unknown	PK
`role_id`	Unknown	FK
`email`	Unknown
`first_name`	Unknown
`guid`	Unknown
`last_name`	Unknown
`status`	Unknown

accessible_stack_sub_categories

Column	Type	Keys
`id`	Unknown	PK
`category_id`	Unknown	PKFK
`stack_id`	Unknown	FK
`name`	Unknown

accessible_stack_categories

Column	Type	Keys
`id`	Unknown	PK
`stack_id`	Unknown	PKFK
`name`	Unknown

accessible_stack

Column	Type	Keys
`id`	Unknown	PK
`name`	Unknown

project_section

Column	Type	Keys
`id`	Unknown	PK
`project_id`	Unknown	FK
`name`	Unknown