ApplicationCore Domain
This page presents the ERD for each AggregateRoot, grouping related entities into domain boundaries. Each AggregateRoot enforces business rules, processes commands synchronously, and defines consistency borders within a single transactional scope. An indicative json schema is created to how the export of a aggregate root will approximitly look like
Category
Aggregate Root: Category
Represents categories for organizing and classifying data and entities across the system.
erDiagram
"ApplicationCore.Categories" {
uniqueidentifier Id PK
nvarchar Name
int DisplayOrderIndex
int CategoryType
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
int CategoryUsageFlags
bit Concealed
int AppliesTo
}
"ApplicationCore.CategoryLabels" {
uniqueidentifier Id PK
uniqueidentifier CategoryId FK
nvarchar Name
nvarchar ShortCode
nvarchar Color
int DisplayOrderIndex
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"ApplicationCore.CategoryLabels" }o--|| "ApplicationCore.Categories" : "CategoryId"
erDiagram
"ApplicationCore.Categories" {
uniqueidentifier Id PK
nvarchar Name
int DisplayOrderIndex
int CategoryType
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
int CategoryUsageFlags
bit Concealed
int AppliesTo
}
"ApplicationCore.CategoryLabels" {
uniqueidentifier Id PK
uniqueidentifier CategoryId FK
nvarchar Name
nvarchar ShortCode
nvarchar Color
int DisplayOrderIndex
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"ApplicationCore.CategoryLabels" }o--|| "ApplicationCore.Categories" : "CategoryId"{
"definitions": {
"ApplicationCore.Categories": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"Name": {
"type": "string",
"description": "nvarchar"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"AppliesTo": {
"type": "integer",
"description": "int"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"CategoryType": {
"type": "integer",
"description": "int"
},
"DisplayOrderIndex": {
"type": "integer",
"description": "int"
},
"CategoryUsageFlags": {
"type": "integer",
"description": "int"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"ApplicationCore.CategoryLabels": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"ShortCode": {
"type": "string",
"description": "nvarchar"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Name": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"DisplayOrderIndex": {
"type": "integer",
"description": "int"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Color": {
"type": "string",
"description": "nvarchar"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"CategoryId": {
"type": "string",
"description": "FK to ApplicationCore.Categories"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
}
},
"type": "object"
}
},
"title": "ApplicationCore.Category",
"$comment": "Generated from Mermaid ERD with property-level descriptions",
"$schema": "http://json-schema.org/draft-07/schema#",
"type": "object"
}Correspondence
Aggregate Root: Correspondence
Represents correspondence and communication records with associated conversations and messages.
erDiagram
"ApplicationCore.Correspondences" {
uniqueidentifier Id PK
uniqueidentifier ChatId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"ApplicationCore.Conversations" }o--|| "ApplicationCore.Correspondences" : "CorrespondenceId"
"ApplicationCore.Correspondences" }o--|| "ApplicationCore.Chats" : "ChatId"
erDiagram
"ApplicationCore.Correspondences" {
uniqueidentifier Id PK
uniqueidentifier ChatId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"ApplicationCore.Conversations" }o--|| "ApplicationCore.Correspondences" : "CorrespondenceId"
"ApplicationCore.Correspondences" }o--|| "ApplicationCore.Chats" : "ChatId"{
"definitions": {
"ApplicationCore.Correspondences": {
"properties": {
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"ChatId": {
"type": "string",
"description": "FK to ApplicationCore.Chats"
}
},
"type": "object"
}
},
"title": "ApplicationCore.Correspondence",
"$comment": "Generated from Mermaid ERD with property-level descriptions",
"$schema": "http://json-schema.org/draft-07/schema#",
"type": "object"
}Conversation
Aggregate Root: Conversation
Represents conversations between users with associated messages and participants.
erDiagram
"ApplicationCore.ConversationContactDetails" {
uniqueidentifier ConversationId PK
uniqueidentifier ContactDetailsId PK
}
"ApplicationCore.ConversationMessageAttachments" {
uniqueidentifier Id PK
uniqueidentifier ConversationMessageId FK
uniqueidentifier DocumentId
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"ApplicationCore.ConversationMessages" {
uniqueidentifier Id PK
uniqueidentifier ConversationId FK
uniqueidentifier SenderId FK
nvarchar Subject
nvarchar Message
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"ApplicationCore.Conversations" {
uniqueidentifier Id PK
uniqueidentifier CorrespondenceId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"ApplicationCore.ConversationContactDetails" }o--|| "ApplicationCore.ContactDetails" : "ContactDetailsId"
"ApplicationCore.ConversationContactDetails" }o--|| "ApplicationCore.Conversations" : "ConversationId"
"ApplicationCore.ConversationMessageAttachments" }o--|| "ApplicationCore.ConversationMessages" : "ConversationMessageId"
"ApplicationCore.ConversationMessages" }o--|| "ApplicationCore.ContactDetails" : "SenderId"
"ApplicationCore.ConversationMessages" }o--|| "ApplicationCore.Conversations" : "ConversationId"
"ApplicationCore.Conversations" }o--|| "ApplicationCore.Correspondences" : "CorrespondenceId"
erDiagram
"ApplicationCore.ConversationContactDetails" {
uniqueidentifier ConversationId PK
uniqueidentifier ContactDetailsId PK
}
"ApplicationCore.ConversationMessageAttachments" {
uniqueidentifier Id PK
uniqueidentifier ConversationMessageId FK
uniqueidentifier DocumentId
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"ApplicationCore.ConversationMessages" {
uniqueidentifier Id PK
uniqueidentifier ConversationId FK
uniqueidentifier SenderId FK
nvarchar Subject
nvarchar Message
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"ApplicationCore.Conversations" {
uniqueidentifier Id PK
uniqueidentifier CorrespondenceId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"ApplicationCore.ConversationContactDetails" }o--|| "ApplicationCore.ContactDetails" : "ContactDetailsId"
"ApplicationCore.ConversationContactDetails" }o--|| "ApplicationCore.Conversations" : "ConversationId"
"ApplicationCore.ConversationMessageAttachments" }o--|| "ApplicationCore.ConversationMessages" : "ConversationMessageId"
"ApplicationCore.ConversationMessages" }o--|| "ApplicationCore.ContactDetails" : "SenderId"
"ApplicationCore.ConversationMessages" }o--|| "ApplicationCore.Conversations" : "ConversationId"
"ApplicationCore.Conversations" }o--|| "ApplicationCore.Correspondences" : "CorrespondenceId"{
"definitions": {
"ApplicationCore.ConversationMessageAttachments": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"ConversationMessageId": {
"type": "string",
"description": "FK to ApplicationCore.ConversationMessages"
},
"DocumentId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"ApplicationCore.ConversationContactDetails": {
"properties": {
"ConversationId": {
"type": "string",
"description": "FK to ApplicationCore.Conversations"
},
"ContactDetailsId": {
"type": "string",
"description": "FK to ApplicationCore.ContactDetails"
}
},
"type": "object"
},
"ApplicationCore.Conversations": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"CorrespondenceId": {
"type": "string",
"description": "FK to ApplicationCore.Correspondences"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"ApplicationCore.ConversationMessages": {
"properties": {
"Message": {
"type": "string",
"description": "nvarchar"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"SenderId": {
"type": "string",
"description": "FK to ApplicationCore.ContactDetails"
},
"ConversationId": {
"type": "string",
"description": "FK to ApplicationCore.Conversations"
},
"Subject": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
}
},
"title": "ApplicationCore.Conversation",
"$comment": "Generated from Mermaid ERD with property-level descriptions",
"$schema": "http://json-schema.org/draft-07/schema#",
"type": "object"
}Chat
Aggregate Root: Chat
Represents chat sessions with comments, mentions, and associated documents for real-time communication.
erDiagram
"ApplicationCore.Chats" {
uniqueidentifier Id PK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"ApplicationCore.CommentDocuments" {
uniqueidentifier CommentId PK
uniqueidentifier DocumentId PK
}
"ApplicationCore.CommentMentionedUsers" {
uniqueidentifier CommentId PK
uniqueidentifier UserId PK
}
"ApplicationCore.Comments" {
uniqueidentifier Id PK
uniqueidentifier ChatId FK
datetimeoffset CreatedDateTime
datetimeoffset EditedDateTime
uniqueidentifier CreatorUserId
nvarchar Content
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"ApplicationCore.ContactDetails" {
uniqueidentifier Id PK
uniqueidentifier UserId
nvarchar FirstName
nvarchar LastName
int GenderType
nvarchar Email
nvarchar PhoneNumber
nvarchar MobileNumber
nvarchar Fax
nvarchar Street
nvarchar HouseNumber
nvarchar Suffix
nvarchar City
nvarchar PostalCode
nvarchar CountryCode
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"ApplicationCore.Comments" }o--|| "ApplicationCore.Chats" : "ChatId"
"ApplicationCore.Correspondences" }o--|| "ApplicationCore.Chats" : "ChatId"
"ApplicationCore.CommentDocuments" }o--|| "ApplicationCore.Comments" : "CommentId"
"ApplicationCore.CommentMentionedUsers" }o--|| "ApplicationCore.Comments" : "CommentId"
"ApplicationCore.ConversationContactDetails" }o--|| "ApplicationCore.ContactDetails" : "ContactDetailsId"
"ApplicationCore.ConversationMessages" }o--|| "ApplicationCore.ContactDetails" : "SenderId"
erDiagram
"ApplicationCore.Chats" {
uniqueidentifier Id PK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"ApplicationCore.CommentDocuments" {
uniqueidentifier CommentId PK
uniqueidentifier DocumentId PK
}
"ApplicationCore.CommentMentionedUsers" {
uniqueidentifier CommentId PK
uniqueidentifier UserId PK
}
"ApplicationCore.Comments" {
uniqueidentifier Id PK
uniqueidentifier ChatId FK
datetimeoffset CreatedDateTime
datetimeoffset EditedDateTime
uniqueidentifier CreatorUserId
nvarchar Content
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"ApplicationCore.ContactDetails" {
uniqueidentifier Id PK
uniqueidentifier UserId
nvarchar FirstName
nvarchar LastName
int GenderType
nvarchar Email
nvarchar PhoneNumber
nvarchar MobileNumber
nvarchar Fax
nvarchar Street
nvarchar HouseNumber
nvarchar Suffix
nvarchar City
nvarchar PostalCode
nvarchar CountryCode
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"ApplicationCore.Comments" }o--|| "ApplicationCore.Chats" : "ChatId"
"ApplicationCore.Correspondences" }o--|| "ApplicationCore.Chats" : "ChatId"
"ApplicationCore.CommentDocuments" }o--|| "ApplicationCore.Comments" : "CommentId"
"ApplicationCore.CommentMentionedUsers" }o--|| "ApplicationCore.Comments" : "CommentId"
"ApplicationCore.ConversationContactDetails" }o--|| "ApplicationCore.ContactDetails" : "ContactDetailsId"
"ApplicationCore.ConversationMessages" }o--|| "ApplicationCore.ContactDetails" : "SenderId"{
"definitions": {
"ApplicationCore.Comments": {
"properties": {
"EditedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"CreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"CreatorUserId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Content": {
"type": "string",
"description": "nvarchar"
},
"ChatId": {
"type": "string",
"description": "FK to ApplicationCore.Chats"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
}
},
"type": "object"
},
"ApplicationCore.ContactDetails": {
"properties": {
"Street": {
"type": "string",
"description": "nvarchar"
},
"LastName": {
"type": "string",
"description": "nvarchar"
},
"CountryCode": {
"type": "string",
"description": "nvarchar"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"MobileNumber": {
"type": "string",
"description": "nvarchar"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"FirstName": {
"type": "string",
"description": "nvarchar"
},
"HouseNumber": {
"type": "string",
"description": "nvarchar"
},
"City": {
"type": "string",
"description": "nvarchar"
},
"Suffix": {
"type": "string",
"description": "nvarchar"
},
"UserId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Fax": {
"type": "string",
"description": "nvarchar"
},
"GenderType": {
"type": "integer",
"description": "int"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"PhoneNumber": {
"type": "string",
"description": "nvarchar"
},
"PostalCode": {
"type": "string",
"description": "nvarchar"
},
"Email": {
"type": "string",
"description": "nvarchar"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"ApplicationCore.Chats": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"ApplicationCore.CommentDocuments": {
"properties": {
"CommentId": {
"type": "string",
"description": "FK to ApplicationCore.Comments"
},
"DocumentId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"ApplicationCore.CommentMentionedUsers": {
"properties": {
"UserId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"CommentId": {
"type": "string",
"description": "FK to ApplicationCore.Comments"
}
},
"type": "object"
}
},
"title": "ApplicationCore.Chat",
"$comment": "Generated from Mermaid ERD with property-level descriptions",
"$schema": "http://json-schema.org/draft-07/schema#",
"type": "object"
}Custom Enum
Aggregate Root: CustomEnum
Represents custom enumerations with components, values, and key values for flexible data classification.
erDiagram
"ApplicationCore.CustomEnumComponentValueKeyValues" {
uniqueidentifier Id PK
uniqueidentifier CustomEnumComponentValueId FK
nvarchar Key
nvarchar Value
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"ApplicationCore.CustomEnumComponentValues" {
uniqueidentifier Id PK
uniqueidentifier CustomEnumComponentId FK
nvarchar Value
datetimeoffset StartDate
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
nvarchar ScriptValue
bit Concealed
}
"ApplicationCore.CustomEnumComponents" {
uniqueidentifier Id PK
uniqueidentifier CustomEnumId FK
nvarchar Name
datetimeoffset StartDate
datetimeoffset EndDate
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
nvarchar ExternalReference
bit Concealed
}
"ApplicationCore.CustomEnums" {
uniqueidentifier Id PK
nvarchar Name
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
nvarchar Description
bit Concealed
}
"PM.CustomEnumComponentValueKeyValues" }o--|| "CRM.CustomEnumComponentValues" : "CustomEnumComponentValueId"
"PM.CustomEnumComponentValueKeyValues" }o--|| "Pricing.CustomEnumComponentValues" : "CustomEnumComponentValueId"
"PM.CustomEnumComponentValueKeyValues" }o--|| "ApplicationCore.CustomEnumComponentValues" : "CustomEnumComponentValueId"
"PM.CustomEnumComponentValueKeyValues" }o--|| "PM.CustomEnumComponentValues" : "CustomEnumComponentValueId"
"ApplicationCore.CustomEnumComponentValueKeyValues" }o--|| "CRM.CustomEnumComponentValues" : "CustomEnumComponentValueId"
"ApplicationCore.CustomEnumComponentValueKeyValues" }o--|| "Pricing.CustomEnumComponentValues" : "CustomEnumComponentValueId"
"ApplicationCore.CustomEnumComponentValueKeyValues" }o--|| "ApplicationCore.CustomEnumComponentValues" : "CustomEnumComponentValueId"
"ApplicationCore.CustomEnumComponentValueKeyValues" }o--|| "PM.CustomEnumComponentValues" : "CustomEnumComponentValueId"
"Pricing.CustomEnumComponentValueKeyValues" }o--|| "CRM.CustomEnumComponentValues" : "CustomEnumComponentValueId"
"Pricing.CustomEnumComponentValueKeyValues" }o--|| "Pricing.CustomEnumComponentValues" : "CustomEnumComponentValueId"
"Pricing.CustomEnumComponentValueKeyValues" }o--|| "ApplicationCore.CustomEnumComponentValues" : "CustomEnumComponentValueId"
"Pricing.CustomEnumComponentValueKeyValues" }o--|| "PM.CustomEnumComponentValues" : "CustomEnumComponentValueId"
"CRM.CustomEnumComponentValueKeyValues" }o--|| "CRM.CustomEnumComponentValues" : "CustomEnumComponentValueId"
"CRM.CustomEnumComponentValueKeyValues" }o--|| "Pricing.CustomEnumComponentValues" : "CustomEnumComponentValueId"
"CRM.CustomEnumComponentValueKeyValues" }o--|| "ApplicationCore.CustomEnumComponentValues" : "CustomEnumComponentValueId"
"CRM.CustomEnumComponentValueKeyValues" }o--|| "PM.CustomEnumComponentValues" : "CustomEnumComponentValueId"
"PM.CustomEnumComponentValues" }o--|| "CRM.CustomEnumComponents" : "CustomEnumComponentId"
"PM.CustomEnumComponentValues" }o--|| "Pricing.CustomEnumComponents" : "CustomEnumComponentId"
"PM.CustomEnumComponentValues" }o--|| "ApplicationCore.CustomEnumComponents" : "CustomEnumComponentId"
"PM.CustomEnumComponentValues" }o--|| "PM.CustomEnumComponents" : "CustomEnumComponentId"
"ApplicationCore.CustomEnumComponentValues" }o--|| "CRM.CustomEnumComponents" : "CustomEnumComponentId"
"ApplicationCore.CustomEnumComponentValues" }o--|| "Pricing.CustomEnumComponents" : "CustomEnumComponentId"
"ApplicationCore.CustomEnumComponentValues" }o--|| "ApplicationCore.CustomEnumComponents" : "CustomEnumComponentId"
"ApplicationCore.CustomEnumComponentValues" }o--|| "PM.CustomEnumComponents" : "CustomEnumComponentId"
"Pricing.CustomEnumComponentValues" }o--|| "CRM.CustomEnumComponents" : "CustomEnumComponentId"
"Pricing.CustomEnumComponentValues" }o--|| "Pricing.CustomEnumComponents" : "CustomEnumComponentId"
"Pricing.CustomEnumComponentValues" }o--|| "ApplicationCore.CustomEnumComponents" : "CustomEnumComponentId"
"Pricing.CustomEnumComponentValues" }o--|| "PM.CustomEnumComponents" : "CustomEnumComponentId"
"CRM.CustomEnumComponentValues" }o--|| "CRM.CustomEnumComponents" : "CustomEnumComponentId"
"CRM.CustomEnumComponentValues" }o--|| "Pricing.CustomEnumComponents" : "CustomEnumComponentId"
"CRM.CustomEnumComponentValues" }o--|| "ApplicationCore.CustomEnumComponents" : "CustomEnumComponentId"
"CRM.CustomEnumComponentValues" }o--|| "PM.CustomEnumComponents" : "CustomEnumComponentId"
"PM.CustomEnumComponents" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"PM.CustomEnumComponents" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"PM.CustomEnumComponents" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"PM.CustomEnumComponents" }o--|| "PM.CustomEnums" : "CustomEnumId"
"ApplicationCore.CustomEnumComponents" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"ApplicationCore.CustomEnumComponents" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"ApplicationCore.CustomEnumComponents" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"ApplicationCore.CustomEnumComponents" }o--|| "PM.CustomEnums" : "CustomEnumId"
"Pricing.CustomEnumComponents" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"Pricing.CustomEnumComponents" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"Pricing.CustomEnumComponents" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"Pricing.CustomEnumComponents" }o--|| "PM.CustomEnums" : "CustomEnumId"
"CRM.CustomEnumComponents" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"CRM.CustomEnumComponents" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"CRM.CustomEnumComponents" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"CRM.CustomEnumComponents" }o--|| "PM.CustomEnums" : "CustomEnumId"
erDiagram
"ApplicationCore.CustomEnumComponentValueKeyValues" {
uniqueidentifier Id PK
uniqueidentifier CustomEnumComponentValueId FK
nvarchar Key
nvarchar Value
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"ApplicationCore.CustomEnumComponentValues" {
uniqueidentifier Id PK
uniqueidentifier CustomEnumComponentId FK
nvarchar Value
datetimeoffset StartDate
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
nvarchar ScriptValue
bit Concealed
}
"ApplicationCore.CustomEnumComponents" {
uniqueidentifier Id PK
uniqueidentifier CustomEnumId FK
nvarchar Name
datetimeoffset StartDate
datetimeoffset EndDate
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
nvarchar ExternalReference
bit Concealed
}
"ApplicationCore.CustomEnums" {
uniqueidentifier Id PK
nvarchar Name
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
nvarchar Description
bit Concealed
}
"PM.CustomEnumComponentValueKeyValues" }o--|| "CRM.CustomEnumComponentValues" : "CustomEnumComponentValueId"
"PM.CustomEnumComponentValueKeyValues" }o--|| "Pricing.CustomEnumComponentValues" : "CustomEnumComponentValueId"
"PM.CustomEnumComponentValueKeyValues" }o--|| "ApplicationCore.CustomEnumComponentValues" : "CustomEnumComponentValueId"
"PM.CustomEnumComponentValueKeyValues" }o--|| "PM.CustomEnumComponentValues" : "CustomEnumComponentValueId"
"ApplicationCore.CustomEnumComponentValueKeyValues" }o--|| "CRM.CustomEnumComponentValues" : "CustomEnumComponentValueId"
"ApplicationCore.CustomEnumComponentValueKeyValues" }o--|| "Pricing.CustomEnumComponentValues" : "CustomEnumComponentValueId"
"ApplicationCore.CustomEnumComponentValueKeyValues" }o--|| "ApplicationCore.CustomEnumComponentValues" : "CustomEnumComponentValueId"
"ApplicationCore.CustomEnumComponentValueKeyValues" }o--|| "PM.CustomEnumComponentValues" : "CustomEnumComponentValueId"
"Pricing.CustomEnumComponentValueKeyValues" }o--|| "CRM.CustomEnumComponentValues" : "CustomEnumComponentValueId"
"Pricing.CustomEnumComponentValueKeyValues" }o--|| "Pricing.CustomEnumComponentValues" : "CustomEnumComponentValueId"
"Pricing.CustomEnumComponentValueKeyValues" }o--|| "ApplicationCore.CustomEnumComponentValues" : "CustomEnumComponentValueId"
"Pricing.CustomEnumComponentValueKeyValues" }o--|| "PM.CustomEnumComponentValues" : "CustomEnumComponentValueId"
"CRM.CustomEnumComponentValueKeyValues" }o--|| "CRM.CustomEnumComponentValues" : "CustomEnumComponentValueId"
"CRM.CustomEnumComponentValueKeyValues" }o--|| "Pricing.CustomEnumComponentValues" : "CustomEnumComponentValueId"
"CRM.CustomEnumComponentValueKeyValues" }o--|| "ApplicationCore.CustomEnumComponentValues" : "CustomEnumComponentValueId"
"CRM.CustomEnumComponentValueKeyValues" }o--|| "PM.CustomEnumComponentValues" : "CustomEnumComponentValueId"
"PM.CustomEnumComponentValues" }o--|| "CRM.CustomEnumComponents" : "CustomEnumComponentId"
"PM.CustomEnumComponentValues" }o--|| "Pricing.CustomEnumComponents" : "CustomEnumComponentId"
"PM.CustomEnumComponentValues" }o--|| "ApplicationCore.CustomEnumComponents" : "CustomEnumComponentId"
"PM.CustomEnumComponentValues" }o--|| "PM.CustomEnumComponents" : "CustomEnumComponentId"
"ApplicationCore.CustomEnumComponentValues" }o--|| "CRM.CustomEnumComponents" : "CustomEnumComponentId"
"ApplicationCore.CustomEnumComponentValues" }o--|| "Pricing.CustomEnumComponents" : "CustomEnumComponentId"
"ApplicationCore.CustomEnumComponentValues" }o--|| "ApplicationCore.CustomEnumComponents" : "CustomEnumComponentId"
"ApplicationCore.CustomEnumComponentValues" }o--|| "PM.CustomEnumComponents" : "CustomEnumComponentId"
"Pricing.CustomEnumComponentValues" }o--|| "CRM.CustomEnumComponents" : "CustomEnumComponentId"
"Pricing.CustomEnumComponentValues" }o--|| "Pricing.CustomEnumComponents" : "CustomEnumComponentId"
"Pricing.CustomEnumComponentValues" }o--|| "ApplicationCore.CustomEnumComponents" : "CustomEnumComponentId"
"Pricing.CustomEnumComponentValues" }o--|| "PM.CustomEnumComponents" : "CustomEnumComponentId"
"CRM.CustomEnumComponentValues" }o--|| "CRM.CustomEnumComponents" : "CustomEnumComponentId"
"CRM.CustomEnumComponentValues" }o--|| "Pricing.CustomEnumComponents" : "CustomEnumComponentId"
"CRM.CustomEnumComponentValues" }o--|| "ApplicationCore.CustomEnumComponents" : "CustomEnumComponentId"
"CRM.CustomEnumComponentValues" }o--|| "PM.CustomEnumComponents" : "CustomEnumComponentId"
"PM.CustomEnumComponents" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"PM.CustomEnumComponents" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"PM.CustomEnumComponents" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"PM.CustomEnumComponents" }o--|| "PM.CustomEnums" : "CustomEnumId"
"ApplicationCore.CustomEnumComponents" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"ApplicationCore.CustomEnumComponents" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"ApplicationCore.CustomEnumComponents" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"ApplicationCore.CustomEnumComponents" }o--|| "PM.CustomEnums" : "CustomEnumId"
"Pricing.CustomEnumComponents" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"Pricing.CustomEnumComponents" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"Pricing.CustomEnumComponents" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"Pricing.CustomEnumComponents" }o--|| "PM.CustomEnums" : "CustomEnumId"
"CRM.CustomEnumComponents" }o--|| "CRM.CustomEnums" : "CustomEnumId"
"CRM.CustomEnumComponents" }o--|| "Pricing.CustomEnums" : "CustomEnumId"
"CRM.CustomEnumComponents" }o--|| "ApplicationCore.CustomEnums" : "CustomEnumId"
"CRM.CustomEnumComponents" }o--|| "PM.CustomEnums" : "CustomEnumId"{
"definitions": {
"ApplicationCore.CustomEnumComponentValueKeyValues": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Key": {
"type": "string",
"description": "nvarchar"
},
"CustomEnumComponentValueId": {
"type": "string",
"description": "FK to PM.CustomEnumComponentValues"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Value": {
"type": "string",
"description": "nvarchar"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"ApplicationCore.CustomEnumComponents": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Name": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EndDate": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"ExternalReference": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"StartDate": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"CustomEnumId": {
"type": "string",
"description": "FK to PM.CustomEnums"
}
},
"type": "object"
},
"ApplicationCore.CustomEnums": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Description": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Name": {
"type": "string",
"description": "nvarchar"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"ApplicationCore.CustomEnumComponentValues": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"CustomEnumComponentId": {
"type": "string",
"description": "FK to PM.CustomEnumComponents"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"ScriptValue": {
"type": "string",
"description": "nvarchar"
},
"Value": {
"type": "string",
"description": "nvarchar"
},
"StartDate": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
}
},
"title": "ApplicationCore.CustomEnum",
"$comment": "Generated from Mermaid ERD with property-level descriptions",
"$schema": "http://json-schema.org/draft-07/schema#",
"type": "object"
}