Tables/content
From Joomla! Documentation
< Tables
< Tables
Usage
- Since:
This table is used to store the content of your Joomla! core articles.
Description
Field | Type | Nullable | Default | Key | Extra | Comments |
id | integer unsigned | NOT NULL | PK | auto_increment | ||
asset_id | integer unsigned | NOT NULL | 0 | FK to the #__assets table. | ||
title | varchar(255) | NOT NULL | ||||
alias | varchar(255) | NOT NULL | ||||
title_alias | varchar(255) | NOT NULL | ||||
introtext | mediumtext | NOT NULL | ||||
fulltext | mediumtext | NOT NULL | ||||
state | tinyint(3) | NOT NULL | 0 | |||
sectionid | integer unsigned | NOT NULL | 0 | |||
mask | integer unsigned | NOT NULL | 0 | |||
catid | integer unsigned | NOT NULL | 0 | |||
created | datetime | NOT NULL | '0000-00-00 00:00:00' | |||
created_by | integer unsigned | NOT NULL | 0 | |||
created_by_alias | varchar(255) | NOT NULL | ||||
modified | datetime | NOT NULL | '0000-00-00 00:00:00' | |||
modified_by | integer unsigned | NOT NULL | 0 | |||
checked_out | integer unsigned | NOT NULL | 0 | |||
checked_out_time | datetime | NOT NULL | '0000-00-00 00:00:00' | |||
publish_up | datetime | NOT NULL | '0000-00-00 00:00:00' | |||
publish_down | datetime | NOT NULL | '0000-00-00 00:00:00' | |||
images | text | NOT NULL | ||||
urls | text | NOT NULL | ||||
attribs | varchar(5120) | NOT NULL | ||||
version | integer unsigned | NOT NULL | 1 | |||
parentid | integer unsigned | NOT NULL | 0 | |||
ordering | integer | NOT NULL | 0 | |||
metakey | text | NOT NULL | ||||
metadesc | text | NOT NULL | ||||
access | integer unsigned | NOT NULL | 0 | This maps to the id of #__viewlevels | ||
hits | integer unsigned | NOT NULL | 0 | |||
metadata | text | NOT NULL | ||||
featured | tinyint(3) unsigned | NOT NULL | 0 | Flag indicating if article is featured. | ||
language | char(7) | NOT NULL | The language code for the article. | |||
xreference | varchar(50) | NOT NULL | A reference to enable linkages to external data sets. |
Notes
Index Name | Column(s) | Unique? |
idx_access | access | No |
idx_checkout | checked_out | No |
idx_state | state | No |
idx_catid | catid | No |
idx_createdby | created_by | No |
idx_featured_cati | featured,catid | No |
idx_language | language | No |
idx_xreference | xreference | No |
- Default character set: utf8