# Trelica schema ERD

Table and field reference for the Fivetran Trelica connector.

## Table & Field Reference

### application_users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| application_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| user_id | Unknown | PK, FK |
| email | Unknown |  |
| name | Unknown |  |

### application_role

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| application_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| name | Unknown |  |

### people_aliases

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| people_id | Unknown | PK, FK |
| aliases | Unknown |  |

### people

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| 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 | PK, FK |
| schemas | Unknown |  |

### users_email

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| users_id | Unknown | PK, FK |
| primaries | Unknown |  |
| type | Unknown |  |
| value | Unknown |  |

### users_phone_number

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| users_id | Unknown | PK, FK |
| type | Unknown |  |
| value | Unknown |  |

### users_role

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| users_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 |  |

## Relationships

- application_users(application_id) → application(id)
- application_license(application_id) → application(id)
- application_role_member(user_id) → users(id)
- application_role_member(application_role_index) → application_role(index)
- application_role(application_id) → application(id)
- application(created_by_user_id) → users(id)
- audit_log_target(id) → application(id)
- audit_log_target(audit_log_id) → audit_log(id)
- audit_log(actor_id) → users(id)
- contract_lineitem(contract_id) → contract(id)
- contract_document(contract_id) → contract(id)
- contract(created_by_user_id) → users(id)
- contract(last_modified_by_user_id) → users(id)
- asset(created_by_user_id) → users(id)
- asset(last_modified_by_user_id) → users(id)
- people_team(people_id) → people(id)
- people_aliases(people_id) → people(id)
- people(id) → users(id)
- users_schema(users_id) → users(id)
- users_email(users_id) → users(id)
- users_phone_number(users_id) → users(id)
- users_role(users_id) → users(id)
- workflow_run_step(workflow_run_id) → workflow_run(id)
- workflow_run(created_by_user_id) → users(id)
- workflow_run(last_modified_by_user_id) → users(id)
- workflow_run(workflow_id) → workflow(id)
- workflow_step(workflow_id) → workflow(id)
- workflow(created_by_user_id) → users(id)
- workflow(last_modified_by_user_id) → users(id)