# Credly schema ERD

Table and field reference for the Fivetran Credly connector.

## Table & Field Reference

### recommendation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_id | Unknown | PK, FK |
| activity_url | Unknown |  |
| badge_templates_count | Unknown |  |
| title | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |

### employee

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_id | Unknown | PK, FK |
| country | Unknown |  |
| created_at | Unknown |  |
| department | Unknown |  |
| email | Unknown |  |
| employee_state | Unknown |  |
| employee_state_updated_at | Unknown |  |
| external_id | Unknown |  |
| first_name | Unknown |  |
| full_name | Unknown |  |
| job_family | Unknown |  |
| last_invitation_sent_at | Unknown |  |
| last_name | Unknown |  |
| location | Unknown |  |
| manager_external_id | Unknown |  |
| manager_first_name | Unknown |  |
| manager_last_name | Unknown |  |
| organization_level_1 | Unknown |  |
| organization_level_2 | Unknown |  |
| organization_level_3 | Unknown |  |
| photo_url | Unknown |  |
| position_title | Unknown |  |
| state_or_province | Unknown |  |
| team | Unknown |  |
| zip_code | Unknown |  |

### recommendation_badge_template

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_id | Unknown | PK, FK |
| recommendation_id | Unknown | PK, FK |
| image_id | Unknown |  |
| image_url | Unknown |  |
| name | Unknown |  |
| owner_id | Unknown |  |
| owner_name | Unknown |  |
| public | Unknown |  |
| updated_at | Unknown |  |

### organization_allowed_webhook

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| organization_id | Unknown | PK, FK |
| allowed_webhook | Unknown |  |

### organization

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| address | Unknown |  |
| allow_saml_debug | Unknown |  |
| bio | Unknown |  |
| city | Unknown |  |
| contact_email | Unknown |  |
| country | Unknown |  |
| created_at | Unknown |  |
| default_page | Unknown |  |
| display_logo_as_circle_in_emails | Unknown |  |
| enable_blockchain | Unknown |  |
| facebook_url | Unknown |  |
| featured_badge_templates | Json |  |
| has_employees | Unknown |  |
| hide_subscription | Unknown |  |
| industry_id | Unknown |  |
| integrated_with_faethm | Unknown |  |
| internationalize_badge_templates | Unknown |  |
| is_trial | Unknown |  |
| legal_contact_email | Unknown |  |
| linked_in_name | Unknown |  |
| linked_in_org_id | Unknown |  |
| linked_in_url | Unknown |  |
| linkedin_a_2_p_url | Unknown |  |
| location | Unknown |  |
| missing_required_info | Unknown |  |
| name | Unknown |  |
| organization_type | Unknown |  |
| pdf_id | Unknown |  |
| photo_id | Unknown |  |
| photo_url | Unknown |  |
| primary_hex_color | Unknown |  |
| print_method | Unknown |  |
| require_template_detail_attributes | Unknown |  |
| state_or_province | Unknown |  |
| support_email | Unknown |  |
| support_url | Unknown |  |
| technical_contact_email | Unknown |  |
| twitter_url | Unknown |  |
| updated_at | Unknown |  |
| url | Unknown |  |
| vanity_slug | Unknown |  |
| vanity_url | Unknown |  |
| verified | Unknown |  |
| verified_at | Unknown |  |
| webhook_url | Unknown |  |
| website_url | Unknown |  |
| workforce_enabled | Unknown |  |
| zip_or_postal_code | Unknown |  |

### badge_template_alignment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| badge_template_id | Unknown | PK, FK |
| description | Unknown |  |
| name | Unknown |  |
| url | Unknown |  |

### badge_template_recommendation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| badge_template_id | Unknown | PK, FK |
| activity_url | Unknown |  |
| recommended_badge_template_id | Unknown |  |
| recommended_badge_template_name | Unknown |  |
| recommended_badge_template_url | Unknown |  |
| title | Unknown |  |
| type | Unknown |  |

### badge_template_endorsement

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| badge_template_id | Unknown | PK, FK |
| description | Unknown |  |
| endorser_id | Unknown |  |
| url | Unknown |  |

### badge_template_activities

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| badge_template_id | Unknown | PK, FK |
| activity_type | Unknown |  |
| activity_url | Unknown |  |
| recommended_badge_template_id | Unknown |  |
| recommended_badge_template_name | Unknown |  |
| recommended_badge_template_url | Unknown |  |
| title | Unknown |  |

### badge_template

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_id | Unknown | PK, FK |
| allow_archive | Unknown |  |
| allow_delete | Unknown |  |
| allow_duplicate_badges | Unknown |  |
| available_locales | Json |  |
| badges_count | Unknown |  |
| certification | Unknown |  |
| cost | Unknown |  |
| created_at | Unknown |  |
| criteria_url | Unknown |  |
| criteria_url_name | Unknown |  |
| default_expires_at | Unknown |  |
| default_expires_at_date | Unknown |  |
| default_expires_at_type | Unknown |  |
| description | Unknown |  |
| earn_this_badge_url | Unknown |  |
| enable_detail_attribute_visibility | Unknown |  |
| enable_earn_this_badge | Unknown |  |
| get_issue_count | Unknown |  |
| get_variants_issue_count | Unknown |  |
| global_activity_url | Unknown |  |
| image_id | Unknown |  |
| image_url | Unknown |  |
| job_board_url | Unknown |  |
| level | Unknown |  |
| linkedin_share_default_message | Unknown |  |
| lock_badge_state | Unknown |  |
| name | Unknown |  |
| only_one_skill_required | Unknown |  |
| owner_id | Unknown |  |
| primary_badge_template_id | Unknown |  |
| printing_disabled | Unknown |  |
| public | Unknown |  |
| recipient_type | Unknown |  |
| record_to_blockchain | Unknown |  |
| reporting_tags | Json |  |
| required_badge_templates | Json |  |
| send_expiring_badge_notifications | Unknown |  |
| settings_enable_related_badges | Unknown |  |
| show_badge_lmi | Unknown |  |
| show_lmi_jobs | Unknown |  |
| show_skill_tag_links | Unknown |  |
| show_template_settings | Unknown |  |
| skills | Json |  |
| state | Unknown |  |
| state_updated_at | Unknown |  |
| time_to_earn | Unknown |  |
| translatable | Unknown |  |
| type_category | Unknown |  |
| updated_at | Unknown |  |
| vanity_slug | Unknown |  |
| variant_name | Unknown |  |
| variant_type | Unknown |  |
| variants_allowed | Unknown |  |
| visibility | Unknown |  |

### employee_skill_evidence

| Column | Type | Keys |
| --- | --- | --- |
| badge_id | Unknown | PK, FK |
| employee_skill_employee_id | Unknown | PK, FK |
| type | Unknown |  |

### employee_skill

| Column | Type | Keys |
| --- | --- | --- |
| employee_id | Unknown | PK, FK |
| organization_id | Unknown | PK, FK |
| external_id | Unknown |  |
| skill | Unknown |  |

### issued_badge_issuer_entity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| issued_badge_id | Unknown | PK, FK |
| label | Unknown |  |
| name | Unknown |  |
| primary_boolean | Unknown |  |
| type | Unknown |  |

### issued_badge

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_id | Unknown | PK, FK |
| badge_template_id | Unknown | FK |
| badge_url | Unknown |  |
| created_at | Unknown |  |
| created_by_id | Unknown |  |
| created_by_type | Unknown |  |
| expires_at | Unknown |  |
| expires_at_date | Unknown |  |
| issued_at | Unknown |  |
| issued_at_date | Unknown |  |
| issued_to | Unknown |  |
| issued_to_first_name | Unknown |  |
| issued_to_last_name | Unknown |  |
| issued_to_middle_name | Unknown |  |
| issuer_earner_id | Unknown |  |
| issuer_summary | Unknown |  |
| locale | Unknown |  |
| public | Unknown |  |
| recipient_email | Unknown |  |
| replacement_badge_id | Unknown |  |
| revocation_reason | Unknown |  |
| state | Unknown |  |
| state_updated_at | Unknown |  |
| suppress_badge_notification_email | Unknown |  |
| updated_at | Unknown |  |
| user_id | Unknown |  |

## Relationships

- recommendation(organization_id) → organization(id)
- employee(organization_id) → organization(id)
- recommendation_badge_template(organization_id) → organization(id)
- recommendation_badge_template(recommendation_id) → recommendation(id)
- organization_allowed_webhook(organization_id) → organization(id)
- badge_template_alignment(badge_template_id) → badge_template(id)
- badge_template_recommendation(badge_template_id) → badge_template(id)
- badge_template_endorsement(badge_template_id) → badge_template(id)
- badge_template_activities(badge_template_id) → badge_template(id)
- badge_template(organization_id) → organization(id)
- employee_skill_evidence(badge_id) → issued_badge(id)
- employee_skill_evidence(employee_skill_employee_id) → employee_skill(employee_id)
- employee_skill(employee_id) → employee(id)
- employee_skill(organization_id) → organization(id)
- issued_badge_issuer_entity(issued_badge_id) → issued_badge(id)
- issued_badge(badge_template_id) → badge_template(id)
- issued_badge(organization_id) → organization(id)