Thinkific

Explore the interactive ERD

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	PKFK
`course_id`	Unknown	PKFK

course_chapter

Column	Type	Keys
`chapter_id`	Unknown	PKFK
`course_id`	Unknown	PKFK

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	PKFK
`product_id`	Unknown	PKFK

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	PKFK
`related_product_id`	Unknown	PKFK

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	PKFK
`product_publish_request_id`	Unknown	PKFK

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	PKFK
`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	PKFK

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	PKFK
`role`	Unknown

users_administered_course

Column	Type	Keys
`administered_course_id`	Unknown	PKFK
`users_id`	Unknown	PKFK

users_custom_profile_field

Column	Type	Keys
`id`	Unknown	PK
`users_id`	Unknown	PKFK
`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