reportschedulerecipients

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ReportScheduleID INT 10 null
reportschedules.ReportScheduleID Implied ConstraintR
ReportScheduleRecipientID INT 10 √ null
reportdeliveries.ReportScheduleRecipientID Implied ConstraintR
v_rc_reportscheduledeliveries.ReportScheduleRecipientID Implied ConstraintR
v_rc_reportschedulerecipients.ReportScheduleRecipientID Implied ConstraintR
RecipientName VARCHAR 150 null
RecipientEmail VARCHAR 150 null
RecipientType INT 10 null
RecipientTypeID INT 10 null
ClientID INT 10 √ null
DateAdded DATETIME 19 null
UserIDAdded INT 10 null
LastUpdate DATETIME 19 null
UserIDLastUpdate INT 10 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc ReportScheduleRecipientID

Relationships

Close relationships within degrees of separation