Entity Relationship (EntityRelationship) table/entity reference

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
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

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

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