# Thinkific schema ERD

Table and field reference for the Fivetran Thinkific connector.

## Table & Field Reference

### collection

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| defaults | Unknown |  |
| description | Unknown |  |
| name | Unknown |  |
| slug | Unknown |  |

### groups

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| name | Unknown |  |
| token | Unknown |  |

### group_analyst

| Column | Type | Keys |
| --- | --- | --- |
| group_analyst | Unknown | PK |
| temp_group_analyst_group_id | Unknown | PK |

### course_administrator_user

| Column | Type | Keys |
| --- | --- | --- |
| administrator_user_id | Unknown | PK, FK |
| course_id | Unknown | PK, FK |

### course_chapter

| Column | Type | Keys |
| --- | --- | --- |
| chapter_id | Unknown | PK, FK |
| course_id | Unknown | PK, FK |

### course

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| instructor_id | Unknown | FK |
| product_id | Unknown | FK |
| user_id | Unknown | FK |
| banner_image_url | Unknown |  |
| contact_information | Unknown |  |
| course_card_image_url | Unknown |  |
| course_card_text | Unknown |  |
| description | Unknown |  |
| duration | Unknown |  |
| intro_video_wistia_identifier | Unknown |  |
| intro_video_youtube | Unknown |  |
| keyword | Unknown |  |
| name | Unknown |  |
| reviews_enabled | Unknown |  |
| slug | Unknown |  |
| subtitle | Unknown |  |

### instructor

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | FK |
| avatar_url | Unknown |  |
| bio | Unknown |  |
| created_at | Unknown |  |
| email | Unknown |  |
| first_name | Unknown |  |
| last_name | Unknown |  |
| slug | Unknown |  |
| title | Unknown |  |

### enrollment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| course_id | Unknown | FK |
| user_id | Unknown | FK |
| activated_at | Unknown |  |
| completed | Unknown |  |
| completed_at | Unknown |  |
| created_at | Unknown |  |
| expired | Unknown |  |
| expiry_date | Unknown |  |
| is_free_trial | Unknown |  |
| percentage_completed | Unknown |  |
| started_at | Unknown |  |
| updated_at | Unknown |  |

### product_collection

| Column | Type | Keys |
| --- | --- | --- |
| collection_id | Unknown | PK, FK |
| product_id | Unknown | PK, FK |

### product_price

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| product_id | Unknown | FK |
| currency | Unknown |  |
| custom_first_price | Unknown |  |
| days_until_expiry | Unknown |  |
| interval | Unknown |  |
| interval_count | Unknown |  |
| is_primary | Unknown |  |
| label | Unknown |  |
| number_of_payments | Unknown |  |
| pay_button_text | Unknown |  |
| payment_type | Unknown |  |
| price | Unknown |  |
| price_name | Unknown |  |
| trial_interval | Unknown |  |
| trial_interval_count | Unknown |  |

### related_product

| Column | Type | Keys |
| --- | --- | --- |
| product_id | Unknown | PK, FK |
| related_product_id | Unknown | PK, FK |

### product

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| card_image_url | Unknown |  |
| created_at | Unknown |  |
| days_until_expiry | Unknown |  |
| description | Unknown |  |
| has_certificate | Unknown |  |
| hidden | Unknown |  |
| instructor_name | Unknown |  |
| keyword | Unknown |  |
| name | Unknown |  |
| position | Unknown |  |
| price | Unknown |  |
| private | Unknown |  |
| productable_id | Unknown |  |
| productable_type | Unknown |  |
| seo_description | Unknown |  |
| seo_title | Unknown |  |
| slug | Unknown |  |
| status | Unknown |  |
| subscription | Unknown |  |

### orders

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| coupon_id | Unknown | FK |
| product_id | Unknown | FK |
| user_id | Unknown | FK |
| affiliate_referral_code | Unknown |  |
| amount_cent | Unknown |  |
| amount_dollar | Unknown |  |
| coupon_code | Unknown |  |
| created_at | Unknown |  |
| status | Unknown |  |
| subscription | Unknown |  |

### content

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| chapter_id | Unknown | FK |
| contentable_type | Unknown |  |
| free | Unknown |  |
| name | Unknown |  |
| position | Unknown |  |
| take_url | Unknown |  |

### product_publish_request_coupon

| Column | Type | Keys |
| --- | --- | --- |
| coupon_id | Unknown | PK, FK |
| product_publish_request_id | Unknown | PK, FK |

### product_publish_request

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| amount | Unknown |  |
| description | Unknown |  |
| discount_type | Unknown |  |
| duration | Unknown |  |
| expires_at | Unknown |  |
| name | Unknown |  |
| starts_at | Unknown |  |

### custom_profile_field_definition

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| field_type | Unknown |  |
| label | Unknown |  |
| required | Unknown |  |

### site_script_page_scope

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| site_script_id | Unknown | PK, FK |
| page_scope | Unknown |  |

### site_script

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| category | Unknown |  |
| description | Unknown |  |
| load_method | Unknown |  |
| location | Unknown |  |
| name | Unknown |  |
| src | Unknown |  |

### coupon

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| promotion_id | Unknown | FK |
| code | Unknown |  |
| created_at | Unknown |  |
| note | Unknown |  |
| quantity | Unknown |  |
| quantity_used | Unknown |  |

### chapter_content

| Column | Type | Keys |
| --- | --- | --- |
| content_id | Unknown | PK |
| chapter_id | Unknown | PK, FK |

### chapter

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| description | Unknown |  |
| duration_in_second | Unknown |  |
| name | Unknown |  |
| position | Unknown |  |

### promotion

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| amount | Unknown |  |
| description | Unknown |  |
| discount_type | Unknown |  |
| duration | Unknown |  |
| expires_at | Unknown |  |
| name | Unknown |  |
| starts_at | Unknown |  |

### course_review

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| course_id | Unknown | FK |
| user_id | Unknown | FK |
| approved | Unknown |  |
| created_at | Unknown |  |
| rating | Unknown |  |
| review_text | Unknown |  |
| title | Unknown |  |

### users_role

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| users_id | Unknown | PK, FK |
| role | Unknown |  |

### users_administered_course

| Column | Type | Keys |
| --- | --- | --- |
| administered_course_id | Unknown | PK, FK |
| users_id | Unknown | PK, FK |

### users_custom_profile_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| users_id | Unknown | PK, FK |
| custom_profile_field_definition_id | Unknown | FK |
| label | Unknown |  |
| value | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| affiliate_code | Unknown |  |
| affiliate_commission | Unknown |  |
| affiliate_commission_type | Unknown |  |
| affiliate_payout_email | Unknown |  |
| avatar_url | Unknown |  |
| bio | Unknown |  |
| company | Unknown |  |
| created_at | Unknown |  |
| email | Unknown |  |
| external_source | Unknown |  |
| first_name | Unknown |  |
| full_name | Unknown |  |
| headline | Unknown |  |
| last_name | Unknown |  |

## Relationships

- course_administrator_user(administrator_user_id) → users(id)
- course_administrator_user(course_id) → course(id)
- course_chapter(chapter_id) → chapter(id)
- course_chapter(course_id) → course(id)
- course(product_id) → product(id)
- course(user_id) → users(id)
- course(instructor_id) → instructor(id)
- instructor(user_id) → users(id)
- enrollment(user_id) → users(id)
- enrollment(course_id) → course(id)
- product_collection(collection_id) → collection(id)
- product_collection(product_id) → product(id)
- product_price(product_id) → product(id)
- related_product(related_product_id) → product(id)
- related_product(product_id) → product(id)
- orders(product_id) → product(id)
- orders(user_id) → users(id)
- orders(coupon_id) → coupon(id)
- content(chapter_id) → chapter(id)
- product_publish_request_coupon(coupon_id) → coupon(id)
- product_publish_request_coupon(product_publish_request_id) → product_publish_request(id)
- site_script_page_scope(site_script_id) → site_script(id)
- coupon(promotion_id) → promotion(id)
- chapter_content(chapter_id) → chapter(id)
- course_review(user_id) → users(id)
- course_review(course_id) → course(id)
- users_role(users_id) → users(id)
- users_administered_course(administered_course_id) → course(id)
- users_administered_course(users_id) → users(id)
- users_custom_profile_field(custom_profile_field_definition_id) → custom_profile_field_definition(id)
- users_custom_profile_field(users_id) → users(id)