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

Published

Last updated

3
-2