docName


Description

Document name definitions managing document names and types for patient document classification. This table defines document names and types to support document identification, categorization, and management for patient clinical documentation and administrative record keeping.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
docNameID int identity 4 √ null
PatientDocs.docNameID FK__PatientDo__docNa__4050666D C

Primary key - Unique identifier for each document name
docName varchar 50 √ null

Document name - Name or type of the document
DocumentName Unknown 0 null

Document name - Standardized name for the document type

Indexes

Constraint Name Type Sort Column(s)
PK__docName__38AF44A5 Primary key Asc docNameID

Relationships

Close relationships within degrees of separation