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 |