PatientIDList


Description

Patient identifier management storing multiple identifier types and values for patients to support various identification systems and external integrations. This table manages patient identifiers including ID values, type classifications, and patient associations, supporting multiple identification systems, external system integration, and comprehensive patient identification for healthcare services.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
pIDTypes int identity 4 √ null

Primary key - Unique identifier for each patient ID record
patientID int 4 √ null
Patient.PatientID FK__PatientIDs__Patient C

Patient reference - Links to Patient table for the patient who has this identifier (foreign key to Patient.PatientID)
IDvalue varchar 30 √ null

Identifier value - The actual identifier value or number
IDTypeID int 4 √ null

ID type reference - Links to identifier type classification

Indexes

Constraint Name Type Sort Column(s)
PK__PatientIDTypes__04908221 Primary key Asc pIDTypes
IX_IDtypeID Performance Asc IDTypeID
IX_IDValue Performance Asc IDvalue
IX_PatientID Performance Asc patientID

Relationships

Close relationships within degrees of separation