enqreg_category
Table name: enqreg_category
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_header, holding one record for each category that has been registered within enquiry registrations.
| Column Name | Datatype | Description |
|---|---|---|
| enqreg_category_recid |
int Primary key. |
Internal, auto-numbered (in this database). A unique id for each record. |
| enqreg_header_recid |
int Foreign key |
Refers to the “owner” record in table enqreg_header. |
| category_id | int | A unique id (generated by back-end) for the category. |
| category_name | nvarchar(255) | The name of the category |