prescripTypes


Description

Prescription type definitions managing categories and types of prescriptions for medication management and patient care. This lookup table defines prescription types including names, descriptions, and alert timing to support prescription tracking, medication management, and automated alert systems for healthcare providers and patient safety monitoring.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
prescripTypeID int identity 4 √ null
PatientPrescriptions.PrescripTypeID FK__PatientPr__Presc__69D19EED R

Primary key - Unique identifier for each prescription type
prescripName varchar 50 √ null

Prescription type name - Name of the prescription type (e.g., ‘Daily Medication’, ‘PRN’, ‘Emergency’)
prescripDesc varchar 100 √ null

Prescription description - Detailed description of the prescription type and its use
daysForAlert int 4 √ null

Alert days - Number of days before prescription expiration to trigger alerts

Indexes

Constraint Name Type Sort Column(s)
PK__prescripTypes__66F53242 Primary key Asc prescripTypeID

Relationships

Close relationships within degrees of separation