# SkillsTX schema ERD

Table and field reference for the Fivetran SkillsTX connector.

## Table & Field Reference

### account_lor

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| account_id | Unknown | PK, FK |
| lor | Unknown |  |

### account_skill_level

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| account_id | Unknown | PK, FK |
| account_skill_index | Unknown | PK, FK |
| level | Unknown |  |
| value | Unknown |  |

### account_skill

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| account_id | Unknown | PK, FK |
| attributes | Json |  |
| skill_code | Unknown |  |

### account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| active | Unknown |  |
| answered_questions | Unknown |  |
| email | Unknown |  |
| endorsed_by | Unknown |  |
| endorsement_last_approved_by | Unknown |  |
| endorsement_last_approved_on | Unknown |  |
| endorsement_last_approved_version | Unknown |  |
| endorsement_last_reviewed_by | Unknown |  |
| endorsement_last_reviewed_on | Unknown |  |
| endorsement_last_reviewed_version | Unknown |  |
| endorsement_last_updated_by | Unknown |  |
| endorsement_last_updated_on | Unknown |  |
| endorsement_last_updated_version | Unknown |  |
| endorsement_status | Unknown |  |
| first_name | Unknown |  |
| fluency_rating | Unknown |  |
| invitation_email_sent | Unknown |  |
| invited_on | Unknown |  |
| is_assigned | Unknown |  |
| is_invited | Unknown |  |
| last_name | Unknown |  |
| percentage | Unknown |  |
| preferred_name | Unknown |  |
| reference | Unknown |  |
| status | Unknown |  |
| total_questions | Unknown |  |
| total_time_taken | Unknown |  |

### evidence_skill_level

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| evidence_id | Unknown | PK, FK |
| skill_level | Unknown |  |

### evidence_lor_level

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| evidence_id | Unknown | PK, FK |
| lor_level | Unknown |  |

### evidence

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_share_key | Unknown | FK |
| account_email | Unknown |  |
| account_reference | Unknown |  |
| created_on | Unknown |  |
| evidence_type | Unknown |  |
| expiry_on | Unknown |  |
| file_data | Unknown |  |
| file_name | Unknown |  |
| label | Unknown |  |
| link | Unknown |  |

## Relationships

- account_lor(account_id) → account(id)
- account_skill_level(account_skill_index) → account_skill(index)
- account_skill_level(account_id) → account_skill(account_id)
- account_skill(account_id) → account(id)
- evidence_skill_level(evidence_id) → evidence(id)
- evidence_lor_level(evidence_id) → evidence(id)
- evidence(account_share_key) → account(id)