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 |
| parent_category_id | int | From v2.4.00 (October 2024) If this record represents the top level category, value will be NULL. If this record represents a sub-category, its parent is shown here. |