Entity Relationship (EntityRelationship) table/entity reference (Microsoft Dataverse)

Messages

The following table lists the messages for the Entity Relationship (EntityRelationship) table. Messages represent operations that can be performed on the table. They may also be events.

Name Is Event?	Web API Operation	SDK for .NET
Associate Event: True	Associate records	Associate records
Disassociate Event: True	Disassociate records	Disassociate records
RetrieveMultiple Event: False	GET /entityrelationships See Query data	Query data

Properties

The following table lists selected properties for the Entity Relationship (EntityRelationship) table.

Property	Value
DisplayName	Entity Relationship
DisplayCollectionName	Entity Relationships
SchemaName	EntityRelationship
CollectionSchemaName	EntityRelationships
EntitySetName	entityrelationships
LogicalName	entityrelationship
LogicalCollectionName	entityrelationships
PrimaryIdAttribute	entityrelationshipid
PrimaryNameAttribute	schemaname
TableType	Standard
OwnershipType	None

Writable columns/attributes

These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.

• EntityRelationshipId
• SchemaName

EntityRelationshipId

Property	Value
Description	Unique identifier of the entity relationship.
DisplayName	Entity Relationship
IsValidForForm	False
IsValidForRead	True
LogicalName	entityrelationshipid
RequiredLevel	SystemRequired
Type	Uniqueidentifier

SchemaName

Property	Value
Description	The name of this Entity Relationship.
DisplayName	Name
IsValidForForm	True
IsValidForRead	True
LogicalName	schemaname
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	100

Read-only columns/attributes

These columns/attributes return false for both IsValidForCreate and IsValidForUpdate. Listed by SchemaName.

• ComponentState
• OverwriteTime
• SolutionId

ComponentState

Property	Value
Description	For internal use only.
DisplayName	Component State
IsValidForForm	False
IsValidForRead	True
LogicalName	componentstate
RequiredLevel	SystemRequired
Type	Picklist
DefaultFormValue	-1
GlobalChoiceName	componentstate

ComponentState Choices/Options

Value	Label
0	Published
1	Unpublished
2	Deleted
3	Deleted Unpublished

OverwriteTime

Property	Value
Description	For internal use only.
DisplayName	Record Overwrite Time
IsValidForForm	False
IsValidForRead	True
LogicalName	overwritetime
RequiredLevel	SystemRequired
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateOnly
ImeMode	Inactive
SourceTypeMask	0

SolutionId

Property	Value
Description	Unique identifier of the associated solution.
DisplayName	Solution
IsValidForForm	False
IsValidForRead	True
LogicalName	solutionid
RequiredLevel	SystemRequired
Type	Uniqueidentifier

One-to-Many relationships

These relationships are one-to-many. Listed by SchemaName.

entityrelationship_config

Many-To-One Relationship: solutioncomponentrelationshipconfiguration entityrelationship_config

Property	Value
ReferencingEntity	solutioncomponentrelationshipconfiguration
ReferencingAttribute	entityrelationshipid
ReferencedEntityNavigationPropertyName	entityrelationship_config
IsCustomizable	False
AssociatedMenuConfiguration	AvailableOffline: True Behavior: UseCollectionName Group: Details Label: MenuId: null Order: 10000 QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000

See also

Dataverse table/entity reference
Dataverse Web API Reference
entityrelationship