Table: dbo.Recorded_Event_Searchable_Attribute
Collection of attribute values associated with a Recorded_Event that can be searched on. One event can have many attribute values
Columns
NameTypeConstraintsDescription
recorded_event_searchable_attribute_KEYint (4)NOT NULLPrimary key.
recorded_event_KEYint (4)NOT NULLEvent that occurred that has the attribute.
recorded_event_searchable_attribute_type_KEYint (4)NOT NULLType of attribute.
attribute_valuenvarchar (200)NOT NULLThe attribute data.
Primary key
NameColumnsDescription
PK_Recorded_Event_Searchable_Attributerecorded_event_searchable_attribute_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Recorded_Event_Searchable_Attribute__Recorded_Event__recorded_event_KEYrecorded_event_KEYRecorded_Event (recorded_event_KEY)
FK_Recorded_Event_Searchable_Attribute__Recorded_Event_Searchable_Attribute_Type__recorded_event_searchable_attribute_type_KEYrecorded_event_searchable_attribute_type_KEYRecorded_Event_Searchable_Attribute_Type (recorded_event_searchable_attribute_type_KEY)

Schema diagram