ltblCNS_NAME


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID int identity 4 √ null
AspNetUsers.AssociatedCNSId FK_AspNetUsers_AssociatedCNSIdR
DEPRECATED_21_02_tblUSER_PROFILE.ASSOCIATED_CNS FK_tblUSER_PROFILE_ltblCNS_NAMER
lnkAO_ASSESSED_BY_CNS.CnsID FK_lnkAO_ASSESSED_BY_CNS_ltblCNS_NAMER
lnkAO_ASSESSED_BY_CNS_MSCC.CnsID FK_lnkAO_ASSESSED_BY_CNS_MSCC_ltblCNS_NAMER
lnkAO_ASSESSED_BY_CNS_NEUTROPENIC_SEPSIS.CnsID FK_lnkAO_ASSESSED_BY_CNS_NEUTROPENIC_SEPSIS_ltblCNS_NAMER
tblCNSContact.L_CNS FK_tblCNSContact_L_CNSC
tblCNSTriage.TriagedBy FK_tblCNSTriage_TriagedByC
CNS_NAME varchar 50 null
IS_DELETED bit 1 ((0))
USER_ID int 4 √ null
UserId uniqueidentifier 16 √ null
DEPRECATED_21_02_aspnet_Users.UserId FK_ltblCNS_NAME_aspnet_UsersR
RoleID tinyint 1 √ null
CNSRoles.ID FK_RoleIDR
ContactNumber nvarchar 100 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_ltblPC_CNS Primary key Asc ID

Relationships

Close relationships within degrees of separation