Sites Table
The Sites table is the starting point for retrieving data about a site. It maps the site name with a site ID. This ID is not the same as the Internet Information Services (IIS) metabase ID for the site. Together with the ResourceProps, Resources, and SiteResources tables, this table stores the data for the Administration database.
Entries in the Sites table have a one-to-many relationship with entries in the SiteResources table. For more information about one-to-many relations, see One-To-Many Relation.
The columns of the Sites table are described in the following table.
Sites Columns | Description |
i_SiteID | An integer that identifies a particular site.
This column corresponds to the i_SiteID columns in the PupDBScripts and SiteResources tables. |
s_Name | A string containing a user-friendly name for the site. |
s_Description | An optional string containing a user-friendly description for the site. |
i_Status | This column is not currently used. |
d_DateCreated | The date and time that this site entry was created. |
d_DateModified | The date and time that this site entry was last modified. |