docStatus


Description

Document status definitions managing document status types for document workflow and approval processes. This table defines document status categories to support document lifecycle management, approval workflows, and status tracking for patient clinical documentation and administrative processes.

Columns

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

Primary key - Unique identifier for each document status
docStatusName varchar 50 √ null

Status name - Name of the document status (Draft, Approved, Pending, etc.)
StatusID Unknown 0 null

Primary key - Unique identifier for each document status
StatusName Unknown 0 null

Status name - Name of the document status

Indexes

Constraint Name Type Sort Column(s)
PK__docStatus__3C7FD589 Primary key Asc docStatusID

Relationships

Close relationships within degrees of separation