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

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
3
Please wait, loading ...
Copyright © 2011 - 2017 Calzada Media Limited. All Rights Reserved.