enqreg_topic
Table name: enqreg_topic
Contains/Role: Three enqreg tables are related together in order to store the so-called enquiry registration data (see database diagram). This table is the “child” of the table enqreg_category, holding one record for each topic that has been registered within each category within enquiry registrations.
| Column Name | Datatype | Description |
|---|---|---|
| enqreg_topic_recid |
int Primary key. |
Internal, auto-numbered (in this database). A unique id for each record. |
| enqreg_category_recid |
int Foreign key |
Refers to the “owner” record in table enqreg_category. |
| topic_id | int | A unique id (generated by back-end) for the topic. |
| topic_name | nvarchar(255) | The name of the topic |