Database table properties
Usage
The table properties contains values of various properties.
Properties are a clientwide ressources.
Table structure
| Field name | Field specification | Comment / Explanation |
|---|---|---|
| idproperty | int(11) | Primary key (auto increment) |
| idclient | int(11) | Foreign key to table clients |
| itemtype | varchar(64) | Type of the property item |
| itemid | varchar(255) | ID of the property item |
| type | varchar(96) | Type of the property |
| name | varchar(96) | Name of the property |
| value | text | Value of the property |
| author | varchar(32) | Username of the creator |
| created | datetime | Date and time of creation |
| modified | datetime | Date and time of last modification |
| modifiedby | varchar(32) | Username of the last modifier |
Generic DB information
| ItemCollection | Item |
|---|---|
| cApiPropertyCollection | cApiProperty |
Previous changes of this table
This table was not changed since the final release of CONTENIDO 4.9.