This website uses cookies We use cookies on this website to provide services, features and to analyze our traffic. You consent to our cookies if you continue to use our website. Accept Cookies Find out more

Table: content_item

KB45 Last reviewed 27 November 2013
A description of the content_item table within the Camino CMS database schema.

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


Keyname Type Cardinality Field(s) Description
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
 Loading ...