Tables [dbo].[Visit_ConsultingProvider]
Table to contain multiple Consulting Providers associated to the Visit
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDescription
Indexes TWstat_Visit_ConsultingProvider_ID_VisitID_ProviderIDIDnumeric(16,0)9NOT NULL1 - 1Unique Identifier for the record
Cluster Key ix_Visit_ConsultingProvider: VisitID\ProviderIDIndexes TWstat_Visit_ConsultingProvider_ID_VisitID_ProviderID, TWstat_Visit_ConsultingProvider_ProviderID_VisitID(2)Foreign Keys FK_Visit_ConsultingProvider_VisitID_Visit_ID: [dbo].[Visit].VisitIDVisitID[dbo].[uniqueid]9NOT NULLThe ID of the associated visit. Link to Visit.ID
Cluster Key ix_Visit_ConsultingProvider: VisitID\ProviderIDIndexes TWstat_Visit_ConsultingProvider_ID_VisitID_ProviderID, TWstat_Visit_ConsultingProvider_ProviderID_VisitID(2)ProviderID[dbo].[uniqueid]9NOT NULLThe ID of an associated Consulting Provider for this Visit. Link to Provider.ID