2022-01-20

Sitefinity Table Structure

Configuration in database

  • dbo.sf_xml_config_items

Dynamic Modules / Content Type

  • (modulename)(content_type)

  • sf_mb_dynamic_module

  • sf_dynamic_content

Images of dynamic content

  • (modulename)(content_type) base_id - sf_dynamic_content base_id (system_parent_type)

  • sfdynamic_content url_name + originalcontent_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

Clean orphaned record from sf_chunks