PatientDocs


Description

Patient documents and files managing patient document uploads, file attachments, and document metadata with status tracking and categorization. This table stores patient-related documents including file names, upload dates, content types, status tracking, and grouping to support comprehensive patient record management, document organization, and clinical documentation for healthcare services.

Columns

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

Primary key - Unique identifier for each patient document
patientID int 4 √ null
Patient.PatientID FK__PatientDo__patie__3F5C4234 C

Patient reference - Links to Patient table for the patient this document belongs to
docDate smalldatetime 16 √ null

Document date - Date associated with the document content or creation
comments varchar 100 √ null

Document comments - Comments or description about the document
docNameID int 4 √ null
docName.docNameID FK__PatientDo__docNa__4050666D C

Document name reference - Links to document name/type lookup table
docStatusID int 4 √ null
docStatus.docStatusID FK__PatientDo__docSt__41448AA6 C

Document status reference - Links to document status lookup table
docGroupID int 4 √ null
docGroups.docGroupID FK__PatientDo__docGr__4238AEDF C

Document group reference - Links to document group/category lookup table
docFileName varchar 100 √ null

File name - Name of the uploaded document file
dateUpload datetime 16,3 null

Upload date - Date when the document was uploaded to the system
userUpload int 4 √ null

Uploaded by user - UserID of the person who uploaded the document
contentType varchar 100 √ null

Content type - MIME type of the uploaded file (PDF, DOC, JPG, etc.)

Indexes

Constraint Name Type Sort Column(s)
PK__PatientDocs__3E681DFB Primary key Asc docID

Relationships

Close relationships within degrees of separation