Subject Table

The subject table holds subject descriptions. The subject table diagram shows the column properties of the table.

• The sub# column is the primary key for a subject. The Identity attribute guarantees that a unique number will be generated for each new subject added to the table. The identity seed and identity increment are 1. The first sub# to be assigned is 1, and each subsequently added sub# will be incremented by 1.
• The text column is the description of the subject. This column is registered for full-text search. CML and Full-Text Search describes full-text search in detail.
• The timestamp column holds a database-wide unique number. The value in the timestamp column is updated every time a row containing a timestamp column is inserted or updated. A table can have only one timestamp column. The timestamp provides a way to incrementally rebuild the full-text index on the table. All the CML database tables registered for full-text search (author, subject, and title) have a timestamp column. Null values are not allowed. Storage size is 8 bytes.