Sitefinity Table Structure
sitefinity | NET, CMS, Sitefinity | 2022-01-20
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)