tblAO_NEUTROPENIC_SEPSIS


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ReferralID int 4 null
lnkAO_ASSESSED_BY_CNS_NEUTROPENIC_SEPSIS.ReferralID FK_lnkAO_ASSESSED_BY_CNS_NEUTROPENIC_SEPSIS_tblAO_NEUTROPENIC_SEPSISR
lnkAO_ASSESSED_BY_CONSULTANT_NEUTROPENIC_SEPSIS.ReferralID FK_lnkAO_ASSESSED_BY_CONSULTANT_NEUTROPENIC_SEPSIS_tblAO_NEUTROPENIC_SEPSISR
tblAO_REFERRAL.ReferralID FK_tblAO_NEUTROPENIC_SEPSIS_tblAO_REFERRALR
DateSuspected date 20 √ null
DateArrival date 20 √ null
TimeArrival time 32 √ null
DateAntibioticsPrescribed date 20 √ null
TimeAntibioticsPrescribed time 32 √ null
DateAntibioticsAdministered date 20 √ null
TimeAntibioticsAdministered time 32 √ null
ConfirmedYN int 4 √ ((0))
DateConfirmed date 20 √ null
AdministrationServiceID int 4 √ null
ltblAO_ADMINISTRATION_SERVICE.AdministrationServiceID FK_tblAO_NEUTROPENIC_SEPSIS_ltblAO_ADMINISTRATION_SERVICER
OtherService varchar 250 √ null
CorrectMedicationGivenYN int 4 √ ((0))
CorrectMedicationGivenComment varchar 250 √ null
AntibioticGivenName varchar 250 √ null
AntibioticGivenDose varchar 250 √ null
ContributingFactors varchar 2147483647 √ null
AuditID int 4 √ null
tblAUDIT_RECORD.AuditID Implied ConstraintR
TimeSuspected time 32 √ null
DateAssessment date 20 √ null
TimeAssessment time 32 √ null
DateCompleted date 20 √ null
TimeCompleted time 32 √ null
Lymphoma int 4 √ null
Systolic int 4 √ null
Dehydrated int 4 √ null
COPD int 4 √ null
MildSymptoms int 4 √ null
ModerateSymptoms int 4 √ null
Patient60Years int 4 √ null
Febrile int 4 √ null
SevereSymptoms int 4 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_tblAO_NEUTROPENIC_SEPSIS Primary key Asc ReferralID

Relationships

Close relationships within degrees of separation