Medication


Columns

Column Type Size Nulls Auto Default Children Parents Comments
MedicationSeq int identity 4 √ null
MedicalConditionMedication.MedicationSeq FK_MedicalConditionMedication_MedicationSeq_Medication_MedicationSeq R
MedicalPlanMedication.MedicationSeq FK_MedicalPlanMedication_MedicationSeq_Medication_MedicationSeq R
ID int 4 null
MedicationTypeCode varchar 20 ('')
MedicationDetails varchar 2147483647 √ null
MedicationDosageDetails varchar 2147483647 √ null
MedicationAdministrationCode varchar 20 √ ('')
MedicationExpiryDate datetime 16,3 √ null
ModifiedBy int 4 √ null
ModifiedDate datetime 16,3 √ null
ActiveFlag bit 1 √ ((0))
Medication varchar 50 ('')
BatchNumber varchar 50 √ null
StoredIn varchar 20 ('')
Status varchar 20 ('')
Frequency varchar 20 ('')
PermissionToDispense bit 1 ((0))
From datetime 16,3 √ null
To datetime 16,3 √ null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
PK_MedicationSeq Primary key Asc MedicationSeq
AK_Medication_ID Performance Asc ID

Relationships

Close relationships within degrees of separation