Information concerning the predefined queries for users is stored in the table shown in the diagram below.
| Column | Data type | Description |
|---|---|---|
| UserName | varchar (50) | Name of the user who created this SQL
string Default value: user_name() |
| SQLStringIdentifier | varchar (50) | Identifier for the selection string as shown in a user interface |
| ItemTable | varchar (50) | Main table from which the data sets should
be selected Default value: 'TaxonName' |
| SQLString | varchar (MAX) | SQL string for selecting data sets from the database |
| Description | nvarchar (MAX) | Description of the results set and the purpose of the query |
| LogCreatedWhen | datetime | Point in time when this
data set was created Default value: getdate() |
| LogCreatedBy | nvarchar (50) | Name of the creator of this data set Default value: user_name() |
| LogUpdatedWhen | datetime | Point in time when this
data set was updated last Default value: getdate() |
| LogUpdatedBy | nvarchar (50) | Name of the person to update this data set
last Default value: user_name() |