Skip to content

Data Model

Data model and entity relationships in Flexible Team Share.

Main Data Model

Record_Id__c (Text - composite key) User_Id__c Triggers share record creation Parent Record (Account, Case, etc.) • Id• OwnerId• Name ObjectTeamMember__c • Record_Id__c• User_Id__c• Access_Level__c• Role__c• End_Date__c User (Standard Object) • Id• Name• Email [Object]Share (AccountShare, CaseShare, etc.) • ParentId• UserOrGroupId• AccessLevel• RowCause = 'Manual'

Entity Relationship Diagram

Record_Id__c User_Id__c triggers creation PARENT_RECORD Id Id PK Id OwnerId String Name User Id Id PK String Name String Email ObjectTeamMember__c Id Id PK Text Record_Id__c FK Lookup User_Id__c FK Picklist Access_Level__c Picklist Role__c Date End_Date__c OBJECT_SHARE Id Id PK Id ParentId FK Id UserOrGroupId FK String AccessLevel String RowCause

Custom Objects

ObjectTeamMember__c

Stores team member assignments linking a user to a parent record.

FieldTypeDescription
Record_Id__cTextComposite key in format ObjectName:RecordId
User_Id__cLookup(User)The team member user
Access_Level__cPicklistRead Only, Read/Write
Role__cPicklistOwner, Manager, User
End_Date__cDateOptional expiration date for temporary access

Team_Sharing_Config__c

Per-object configuration for team sharing.

FieldTypeDescription
Object_Api_Name__cTextAPI name of the configured object
Object_Label__cTextDisplay label for the object
Is_Active__cCheckboxWhether team sharing is active for this object

FlexiTeamShare_Config__mdt

App-level configuration stored as Custom Metadata.

FieldTypeDescription
IsActive__cCheckboxMaster toggle for the app
Cleanup_Batch_Size__cNumberBatch size for cleanup jobs
Enable_Batch_Logging__cCheckboxEnable debug logging in batch jobs
Enable_Expired_Member_Cleanup__cCheckboxEnable automatic cleanup of expired members

Configuration Objects

Configuresbehavior Enablesobject FlexiTeamShare_Config__mdt (Custom Metadata) • IsActive__c• Cleanup_Batch_Size__c• Enable_Batch_Logging__c• Enable_Expired_Member_Cleanup__c Team_Sharing_Config__c • Object_Api_Name__c• Object_Label__c• Is_Active__c Parent Objects (Account, Case, etc.)

Complete Model Overview

FlexiTeamShare_Config__mdt Parent Record(Account, Case, etc.) User Team_Sharing_Config__c ObjectTeamMember__c [Object]Share