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
Name | Type | Constraints | Description
recorded_event_searchable_attribute_KEY | int (4) | NOT NULL | Primary key.
recorded_event_KEY | int (4) | NOT NULL | Event that occurred that has the attribute.
recorded_event_searchable_attribute_type_KEY | int (4) | NOT NULL | Type of attribute.
attribute_value | nvarchar (200) | NOT NULL | The attribute data.

Primary key
Name | Columns | Description
PK_Recorded_Event_Searchable_Attribute | recorded_event_searchable_attribute_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Recorded_Event_Searchable_Attribute__Recorded_Event__recorded_event_KEY | recorded_event_KEY | Recorded_Event (recorded_event_KEY) |
FK_Recorded_Event_Searchable_Attribute__Recorded_Event_Searchable_Attribute_Type__recorded_event_searchable_attribute_type_KEY | recorded_event_searchable_attribute_type_KEY | Recorded_Event_Searchable_Attribute_Type (recorded_event_searchable_attribute_type_KEY) |