Child pages
  • Database table cat
Skip to end of metadata
Go to start of metadata

Usage

The table cat links a Category to a Client and defines it position within the category tree.

Category is clientwide ressource.

Table structure

Field nameField specificationComment / Explanation
idcatint(11) Primary key (auto increment)
idclientint(11)Foreign key to table clients
parentidint(11)Foreign key to this table as reference for the parent category
preidint(11)Foreign key to this table as reference for the previous category
postidint(11)Foreign key to this table as reference for the following category
statusint(11)Unused.
authorvarchar(32)Username of the categories creator
createddatetimeDate and time of creation
lastmodifieddatetimeDate and time of last modification

Generic DB information

ItemCollectionItem
cApiCategoryCollectioncApiCategory

Previous changes of this table

This table was not changed since the final release of CONTENIDO 4.9.