Fivetran documentation

Search the docs

/

Trelica

Explore the interactive ERD

Table & Field Reference

application_users

Column	Type	Keys
`id`	Unknown	PK
`application_id`	Unknown	PKFK
`deleted`	Unknown
`email`	Unknown
`last_login_dtm`	Unknown
`last_modified_dtm`	Unknown
`status`	Unknown

application_license

Column	Type	Keys
`index`	Unknown	PK
`application_id`	Unknown	PKFK
`last_modified_dtm`	Unknown
`name`	Unknown
`renewal_date`	Unknown
`start_date`	Unknown
`terminated_date`	Unknown

application_role_member

Column	Type	Keys
`application_role_index`	Unknown	PKFK
`user_id`	Unknown	PKFK
`email`	Unknown
`name`	Unknown

application_role

Column	Type	Keys
`index`	Unknown	PK
`application_id`	Unknown	PKFK
`name`	Unknown

application

Column	Type	Keys
`id`	Unknown	PK
`created_by_user_id`	Unknown	FK
`created_dtm`	Unknown
`deleted`	Unknown
`last_modified_dtm`	Unknown
`name`	Unknown
`risk_level`	Unknown
`status`	Unknown
`vendor_name`	Unknown

audit_log_target

Column	Type	Keys
`id`	Unknown	PKFK
`audit_log_id`	Unknown	FK
`alternate_id`	Unknown
`display_name`	Unknown
`type`	Unknown

audit_log

Column	Type	Keys
`id`	Unknown	PK
`actor_id`	Unknown	FK
`details`	Json
`event_type`	Unknown
`published`	Unknown

contract_lineitem

Column	Type	Keys
`index`	Unknown	PK
`contract_id`	Unknown	PKFK
`amount`	Unknown
`base_amount`	Unknown
`base_currency`	Unknown
`currency`	Unknown
`description`	Unknown
`end_date`	Unknown
`start_date`	Unknown
`unit_count`	Unknown

contract_document

Column	Type	Keys
`index`	Unknown	PK
`contract_id`	Unknown	PKFK
`description`	Unknown
`link_url`	Unknown

contract

Column	Type	Keys
`id`	Unknown	PK
`created_by_user_id`	Unknown	FK
`last_modified_by_user_id`	Unknown	FK
`agreement_date`	Unknown
`business_owner_email`	Unknown
`created_dtm`	Unknown
`is_automatic_renewal`	Unknown
`last_modified_dtm`	Unknown
`ref`	Unknown
`renewal_date`	Unknown
`type`	Unknown
`vendor_name`	Unknown

asset

Column	Type	Keys
`id`	Unknown	PK
`created_by_user_id`	Unknown	FK
`last_modified_by_user_id`	Unknown	FK
`asset_tag`	Unknown
`created_dtm`	Unknown
`custom_fields`	Json
`device_name`	Unknown
`hardware_vendor`	Unknown
`is_encrypted`	Unknown
`last_modified_dtm`	Unknown
`location_country_code`	Unknown
`location_name`	Unknown
`model_name`	Unknown
`serial_number`	Unknown
`status`	Unknown

people_team

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

people_aliases

Column	Type	Keys
`index`	Unknown	PK
`people_id`	Unknown	PKFK
`aliases`	Unknown

people

Column	Type	Keys
`id`	Unknown	PKFK
`cost_center`	Unknown
`created_by`	Unknown
`created_dtm`	Unknown
`email`	Unknown
`first_name`	Unknown
`job_title`	Unknown
`last_modified_by`	Unknown
`last_modified_dtm`	Unknown
`last_name`	Unknown
`leaving_date`	Unknown
`location`	Unknown
`person_type`	Unknown
`start_date`	Unknown

users_schema

Column	Type	Keys
`index`	Unknown	PK
`users_id`	Unknown	PKFK
`schemas`	Unknown

users_email

Column	Type	Keys
`index`	Unknown	PK
`users_id`	Unknown	PKFK
`primaries`	Unknown
`type`	Unknown
`value`	Unknown

users_phone_number

Column	Type	Keys
`index`	Unknown	PK
`users_id`	Unknown	PKFK
`type`	Unknown
`value`	Unknown

users_role

Column	Type	Keys
`index`	Unknown	PK
`users_id`	Unknown	PKFK
`primaries`	Unknown
`value`	Unknown

users

Column	Type	Keys
`id`	Unknown	PK
`active`	Unknown
`display_name`	Unknown
`external_id`	Unknown
`locale`	Unknown
`meta_created`	Unknown
`meta_resource_type`	Unknown
`preferred_language`	Unknown
`user_name`	Unknown

workflow_run_step

Column	Type	Keys
`id`	Unknown	PK
`workflow_run_id`	Unknown	PKFK
`completed`	Json
`failed`	Json
`name`	Unknown
`status`	Unknown
`type`	Unknown
`waiting`	Json

workflow_run

Column	Type	Keys
`id`	Unknown	PK
`created_by_user_id`	Unknown	FK
`last_modified_by_user_id`	Unknown	FK
`workflow_id`	Unknown	FK
`context`	Json
`created_dtm`	Unknown
`deleted`	Unknown
`last_modified_dtm`	Unknown
`name`	Unknown
`status`	Unknown
`trigger`	Json
`waiting_until_dtm`	Unknown

workflow_step

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

workflow

Column	Type	Keys
`id`	Unknown	PK
`created_by_user_id`	Unknown	FK
`last_modified_by_user_id`	Unknown	FK
`created_dtm`	Unknown
`enabled`	Unknown
`last_modified_dtm`	Unknown
`name`	Unknown
`trigger_day_of_week`	Unknown
`trigger_every_n_periods`	Unknown
`trigger_hour`	Unknown
`trigger_id`	Unknown
`trigger_name`	Unknown
`trigger_period`	Unknown
`trigger_start_date`	Unknown
`trigger_type`	Unknown