Extension Documentation

Articles Table
Prev	Chapter 7. Database Design	Next

Articles Table

The table that holds details of each article.

Table 7.2. Articles table description

Column Name	Type	Size	Not Null?	Constraints	Description
id	Number	11	Yes	Primary key	A unique numeric identification for each article. Populated by an auto-sequence.
asset_id	Int	10	No	None	FK to the #__assets table.
title	Varchar	255	Yes	Unique key	The unique title of the article.
category_id	Int	na	No	None	The FK to the category table. The category to which the article belongs.
alias	Varchar	255	Yes	None	Article Alias.
featured	Varchar	255	Yes	None	Indicates whether the article is a 'featured' article.
hits	Int	10	Yes	None	The number of times the article has been viewed.
full_text	Text	64K	No	None	The article text.
ordering	Int	11	No	None	The column used for ordering records.
state	TinyInt	1	No	None	State of the specific record. i.e. Published, archived, trashed etc.
language	Character	7	No	None	Language code.
access	TinyInt	3	Yes	None	Access levels required to view the article. [ACL]
checked_out	Integer	11	Yes	None	The id of the Joomla user editing the record.
checked_out_time	Datetime	na	Yes	None	The date/time the record was checked out for editing.
metakey	Text	-	Yes	None	Metadata keys. Not fully implemented.
metadesc	Text	-	Yes	None	Meta description of the article. Not fully implemented.
metadata	Text	-	Yes	None	Metadata for the article. (Not fully implemented.)
created_by	Int	11	Yes	None	The id of the Joomla user who created the article.
created_at	Timestamp	-	No	None	The date and time the record was created. Default NULL.
modified_by	Int	11	Yes	None	The id of the Joomla user who last modified the article.
modified_on	Timestamp	-	No	None	If populated the date and time the record was last modified.

	Note
1) Articles are always assigned to a specific category. 2) Article attachment details are stored in a separate table. See below.

Note

1) Articles are always assigned to a specific category.

2) Article attachment details are stored in a separate table. See below.

Prev	Up	Next
Categories Table	Home	Attachments Table