Table: content_item
Published:
21 Aug 2012, last updated 27 Nov 2013 16:01
Stores content item data. Just what and how a content item is handled is defined by its' module and genre.
|
Field |
Type |
Null |
Key |
Default |
Description |
|
item_id |
int(10) |
|
Primary |
|
|
|
organisation_id |
int(10) |
No |
Multiple |
0 |
Organisation ID |
|
parent_itemid |
int(10) |
No |
Multiple |
0 |
The ID of the parent content item |
|
content_module |
varchar(30) |
Yes |
Multiple |
|
The identity of the Camino CMS module that this content belongs to |
|
content_genre |
varchar(30) |
Yes |
Multiple |
|
The identity of the content genre for the Camino CMS module |
|
item_uuid |
varchar(40) |
Yes |
item_uuid |
|
The unique string identifier for this content item |
|
item_name |
varchar(250) |
Yes |
|
|
The item's name |
|
item_description |
longtext |
Yes |
search_index1 |
|
The item's content |
|
item_excerpt |
text |
Yes |
search_index1 |
|
A short description or overview of the item's content |
|
item_keywords |
varchar(255) |
Yes |
search_index1 |
|
Keywords for this content item |
|
item_listweight |
tinyint(3) |
No |
Multiple |
50 |
Weighting for this content item - the lower the weight, the higher the importance |
|
item_state |
tinyint(2) |
No |
Multiple |
0 |
The item state. Typically used to indicate publication status |
|
item_rendermasterpage |
varchar(255) |
Yes |
|
|
The ASP.Net MasterPage for this item |
|
item_renderusercontrol |
varchar(255) |
Yes |
|
|
The ASP.Net UserControl for this item |
|
item_commentsstatus |
varchar(10) |
No |
|
0 |
Comments configuration for this item |
|
item_permitedit |
tinyint(2) |
No |
|
0 |
1/0 setting that enables/blocks editing of content through site |
|
item_permitdeletion |
tinyint(2) |
No |
|
0 |
1/0 setting that enables/block deletion of item through site |
|
item_viewcount |
int(10) |
No |
|
0 |
The number of times the item has been viewed (public site only, where enabled) |
|
item_title |
varchar(250) |
Yes |
|
|
An alternative item title, typically used for HTML title |
|
item_metaoverride |
tinyint(1) |
No |
|
0 |
1/0 value that blocks/inherits global meta data for item |
|
item_metaauthor |
varchar(128) |
Yes |
|
|
Custom Meta Author for this item |
|
item_metadescription |
varchar(255) |
Yes |
|
|
Custom Meta description for this item |
|
item_metakeywords |
varchar(255) |
Yes |
|
|
Custom meta keywords for this item |
|
item_publicationdate |
datetime |
No |
Multiple |
0000-00-00 00:00:00 |
The declared MySQL timestamp when this item was published |
|
item_created |
datetime |
No |
|
0000-00-00 00:00:00 |
The MySQL timestamp of when this item was created |
|
item_lastmodified |
datetime |
No |
|
0000-00-00 00:00:00 |
The MySQL timestamp of when this item was last edited or updated |
|
creator_uid |
int(10) |
No |
|
0 |
The ID of the user who created this item |
Indexes
|
Keyname |
Type |
Cardinality |
Field(s) |
Description |
|
PRIMARY |
PRIMARY |
0 |
item_id |
|
|
item_uuid |
FULLTEXT |
None |
item_uuid |
|
|
breadcrumb |
|
|
item_id, parent_itemid |
Used in breadcrumb queries |
|
parent_category |
|
|
organisation_id, parent_itemid, item_name, item_listweight, item_state |
Used in public item listings |
|
parent_item |
|
|
item_id, organisation_id, parent_itemid, content_module, content_genre |
Used in public listings |
|
administration_listing |
|
|
organisation_id, parent_itemid, content_module, content_genre, item_state, item_created, item_lastmodified |
Used in administration listings |
|
parent_itemid |
|
|
parent_itemid |
|
|
search_index1 |
FULLTEXT |
|
item_name, item_description, item_excerpt, item_keywords |
Used in search queries |