MedicationHistory


Columns

Column Type Size Nulls Auto Default Children Parents Comments
MedicationHistorySeq int identity 4 √ null
MedicationSeq int 4 √ null
MedicalConditionSeq int 4 √ null
ID int 4 √ null
MedicationTypeCode varchar 20 √ null
MedicationDetails varchar 2147483647 √ null
MedicationDosageDetails varchar 2147483647 √ null
MedicationAdministrationCode varchar 20 √ null
MedicationExpiryDate datetime 16,3 √ null
ActiveFlag bit 1 √ null
ModifiedBy int 4 √ null
ModifiedDate datetime 16,3 √ null
AuditAction varchar 30 √ null
Medication varchar 50 √ null
BatchNumber varchar 50 √ null
StoredIn varchar 20 √ null
Status varchar 20 √ null
Frequency varchar 20 √ null
PermissionToDispense bit 1 √ null
From datetime 16,3 √ null
To datetime 16,3 √ null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
PK_MedicationHistory_MedicationHistorySeq Primary key Asc MedicationHistorySeq