Alert table relationships in SCOM DW database

Here's the alert schema in Operations Manager Data Warehouse database:

It can be very useful for custom reports.

For example report of alertname, raised time, userId. TicketId.

Why, when and who created a ticket.

use operationsmanagerdw
select AlertName, RaisedDateTime, DBLastModifiedByUserId, TicketId
FROM Alert.vAlertDetail INNER JOIN
Alert.vAlert ON Alert.vAlertDetail.AlertGuid = Alert.vAlert.AlertGuid
WHERE (TicketID > '0') AND (RaisedDateTime > '2011-02-01') AND (RaisedDateTime < '2011-03-01') AND (DBLastModifiedByUserId <> 'System')
Order by RaisedDateTime ASC