Table listing
Here is the list of all tables created in the database.
Clic on a table name for more informations.
Sidebar
model:reportsubscription
Table of Contents
Table reportsubscription
Remarks
This table contains subscriptions on a report. The primary key is composed of ReportTemplateId and UserId.
Schema
| Name | Type | Not Null | Primary Key | Foreign Key | Remarks |
| :——— | :——— | :————- | :—————- | :—————- | :———— |
| reporttemplateid | integer | X | X | reporttemplate(reporttemplateid) | This is a foreign key to the table ReportTemplate. |
| userid | integer | X | X | userlogin(userid) | This is a foreign key to the table userlogin. |
| subscribed | bool | X | It indicates if the user related has subscribed to the report. | ||
| invitinguserid | integer | X | userlogin(userid) | It corresponds to the user that had invited the user subscribed here. |
Diagram
model/reportsubscription.txt · Last modified: 2016/01/11 21:38 (external edit)
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
