Adding the Critique Table
The Critique table stores some of the critique's information. Elements not in this table — critique text and technical, relevance, and clarity ratings — are stored in the Exchange information store. The Critique table diagram shows the column properties of the table.
- The critique# column is the primary key for a critique. The Identity attribute guarantees that a unique number will be generated for each new critique added to the table. The identity seed and identity increment are 1. The first critique# to be assigned is 1, and each subsequently added critique# will be incremented by 1.
- The bib# column is the foreign key that links the Critique table to the title table. The Critique table represents the many and the title table the one in this one-to-many relationship. The bib# is not an identity column in the Critique table. The bib# is required and the value is verified by a bib# in the title table. It would not make sense to allow a record in the Critique table that did not reference a record in the title table.
- The borrower# column is the foreign key that links the Critique table to the borrower table. The Critique table represents the many and the borrower table the one in this one-to-many relationship. The borrower# is not an identity column in the Critique table. The borrower# is required, and the value is verified by a borrower# in the borrower table.
- The objectId column contains the unique identifier (ID) assigned to the critique message object when the critique is first posted to the LitCrit Exchange public folder. The objectId is used to retrieve the message and make the properties of the message (critique text and ratings) available to the library Web application. The data type is char because this identifier is a string.
- The title column contains the title the reviewer creates for the critique. When no title for the critique is entered, this field contains the title of the item critiqued, prefixed by "Critique of:".
- The rating column contains the numeric equivalent of the rating the reviewer assigned to the title. The number is the integer 1, 2, 3, or 4.
- The dateOfCritique column contains the date on which the critique was submitted.
- The isApproved column indicates whether or not the critique is approved. A critique must be approved to be available to users of the Corporate Media Library application. This is a Boolean field and the data type is tinyint. The default value is 0, indicating this field value defaults to False.