Store catalog category information
Data model
Fields
| Field |
Type |
Description |
| cata_builtin* |
BIT |
Indicator if the category is predefined |
| cata_description |
NVARCHAR (500) |
Catalog Category Description |
| cata_id* |
INT |
Catalog category identifier |
| cata_name* |
NVARCHAR (400) |
Catalog category name |
| cata_parent_id |
INT |
Parent category identifier |
| cata_status* |
INT |
Catalog status |
| cata_type* |
NVARCHAR (2) |
Catalog Type |
| modification_date |
DATETIME |
Date of last modification |
| modified_by |
INT |
Identifier of the last user who modified the record |
Primary Key
References
| Column |
Referenced Table |
Referenced column |
Name |
| cata_parent_id |
dbo.AFW_CATALOG |
cata_id |
FK01_AFW_CATALOG |
