Database table cat
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 name | Field specification | Comment / Explanation |
|---|---|---|
| idcat | int(11) | Primary key (auto increment) |
| idclient | int(11) | Foreign key to table clients |
| parentid | int(11) | Foreign key to this table as reference for the parent category |
| preid | int(11) | Foreign key to this table as reference for the previous category |
| postid | int(11) | Foreign key to this table as reference for the following category |
| status | int(11) | Unused. |
| author | varchar(32) | Username of the categories creator |
| created | datetime | Date and time of creation |
| lastmodified | datetime | Date and time of last modification |
Generic DB information
| ItemCollection | Item |
|---|---|
| cApiCategoryCollection | cApiCategory |
Previous changes of this table
This table was not changed since the final release of CONTENIDO 4.9.