Sitefinity Table Structure

Configuration in database

• dbo.sf_xml_config_items

Dynamic Modules / Content Type

• (module_name)_(content_type)

• sf_mb_dynamic_module

• sf_dynamic_content

Images of dynamic content

• (module_name)_(content_type) base_id - sf_dynamic_content base_id (system_parent_type)

• sf_dynamic_content url_name_ + original_content_id - sf_media_content url_name_ + original_content_id

• sf_media_content content_id - sf_media_file_links content_id

• sf_media_file_links file_id - sf_chunks file_id

Images / Documents / Files / Videos

• sf_libraries content_id - sf_media_content parent_id

• sf_media_content content_id - sf_media_file_links content_id

• sf_media_file_links file_id - sf_chunks file_id

Schedule Tasks

• sf_scheduled_tasks

User & User Profile

• sf_users id - sf_user_profile user_id

• sf_user_profile id - sf_sitefinity_profile id

User & Roles & Permission

• sf_users id - sf_user_link user_id

• sf_user_link role_id - sf_roles id

• sf_roles id - sf_permissions principal_id

example: Permission on Page

• sf_permissions object_id - sf_permissions child_object_id (recursive)

• sf_permissions object_id - sf_page_data page_node_id

Content Block in a page

• sf_page_node content_id - sf_object_data page_id

• sf_object_data object_type = Telerik.Sitefinity.Mvc.Proxy.MvcControllerProxy (MVC)

• sf_object_data object_type = Telerik.Sitefinity.Modules.GenericContent.Web.UI.ContentBlock (WebForm)

• sf_object_data id - sf_control_properties control_id (ControllerName, ID, Settings)

• sf_control_properties prnt_prop_id - sf_control_properties control_id (Settings - MVC Content)

Clean orphaned record from sf_chunks

• Sitefinity KB - Remove Orphaned Entries

Reference

• Sitefinity Community - Get Value of Content Blocks in DB