Credly
Explore the interactive ERD
Table & Field Reference
recommendation
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
organization_id | Unknown | PKFK |
activity_url | Unknown | |
badge_templates_count | Unknown | |
title | Unknown | |
type | Unknown | |
updated_at | Unknown |
employee
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
organization_id | Unknown | PKFK |
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 | PKFK |
recommendation_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
description | Unknown | |
name | Unknown | |
url | Unknown |
badge_template_recommendation
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
badge_template_id | Unknown | PKFK |
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 | PKFK |
description | Unknown | |
endorser_id | Unknown | |
url | Unknown |
badge_template_activities
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
badge_template_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
employee_skill_employee_id | Unknown | PKFK |
type | Unknown |
employee_skill
| Column | Type | Keys |
|---|---|---|
employee_id | Unknown | PKFK |
organization_id | Unknown | PKFK |
external_id | Unknown | |
skill | Unknown |
issued_badge_issuer_entity
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
issued_badge_id | Unknown | PKFK |
label | Unknown | |
name | Unknown | |
primary_boolean | Unknown | |
type | Unknown |
issued_badge
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
organization_id | Unknown | PKFK |
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 |