SiteResources Table

  • Article

The SiteResources table serves as a lookup mechanism for all resources installed in a site. Together with the ResourceProps, Resources, and Sites tables, this table stores the data for the Administration database.

Entries in the SiteResources table have a many-to-many relationship with entries in the Resources table. For more information about many-to-many relations, see Many-To-Many Relation.

The columns of the SiteResources table are described in the following table.

SiteResources Columns Description
i_SiteID An integer that identifies the particular site associated with the corresponding resource.

This column corresponds to the i_SiteID columns in the PupDBScripts and Sites tables.
i_ResourceID An integer that associates the identified resource with its corresponding site. Values in this column correspond to the values in the i_ResourceID columns in the PupDBScript, ResourceProps, and Resources tables.


All rights reserved.