WellbeingEvents


Columns

Column Type Size Nulls Auto Default Children Parents Comments
WellbeingEventID int identity 4 √ null
BIvwWellbeingEvents.WellbeingEventID Implied ConstraintR
WellbeingEventsDetail.WellbeingEventID Implied ConstraintR
CNSContactID int 4 null
tblCNSContact.CNSContactID FK_WellbeingEvents_tblCNSContactC
EventStatus int 4 √ null
ltblWellbeingEvent.WellbeingID FK_WellbeingEvents_ltblWellbeingEventR
ReasonEventNotOffered nvarchar 100 √ null
EventName varchar 100 √ null
SuitableForWellbeingEvent int 4 √ null
ltblYN.YN_ID FK_WellbeingEvents_ltblYNR
PointOfPathway int 4 √ null
ltblPOINT_OF_PATHWAY.ID FK_WellbeingEvents_ltblPOINT_OF_PATHWAYR
OtherPointOfPathway varchar 150 √ null
DateAttended date 20 √ null
IsDeleted bit 1 ((0))

Indexes

Constraint Name Type Sort Column(s)
PK_WellbeingEvents Primary key Asc WellbeingEventID

Relationships

Close relationships within degrees of separation