dbo.primeContactRelationships

Info Generated by scripts/Generate-DataDictionary.ps1 - do not edit by hand. Edit descriptions in schemas/tables/dbo.primeContactRelationships.json and regenerate.

Columns

#	Column	Type	Nullable	Flags	Description
1	id	uniqueidentifier	no		Primary key / unique identifier for this record
2	jobId	uniqueidentifier	no		Foreign key to primeJobs
3	contactId	uniqueidentifier	no		Foreign key to primeContacts
4	contactName	varchar(255)	no		Display name of the contact
5	contactRelationshiptypeid	uniqueidentifier	yes		Foreign key to primeContactRelationshipTypes
6	contactRelationshiptypename	varchar(100)	yes		Name of the contact relationship type
7	version	int	no		Optimistic-concurrency row version number

Indexes

Name	Type	Unique	PK	Key columns	Included	Filter
PK__primeCon__3213E83FEC65029A	CLUSTERED	yes	yes	id

Relationships (inferred)

From	To	Confidence
dbo.primeContactRelationships.contactId	dbo.primeContacts.id	high
dbo.primeContactRelationships.jobId	dbo.primeJobs.Id	high

Referenced by

Procedures: dbo.spElevenLabsGetConversationInitialization, dbo.spEthGetQueuedIDs, dbo.spEthSyncQueueMissingObjects, dbo.spEthSyncQueueMissingObjectsByJobID, dbo.spMakeSafePhoneCallRelatedPrimeJobs, dbo.spPrimeGetJobContactRelationships, dbo.spPrimeGetRelationshipIdByName, dbo.spPrimeJobSearch, dbo.spPrimeUpsertContactRelationship, dbo.spPrimeUpsertJob