Skip to main content

Article (table: articles)

Field Name Data Type
content string
date_created datetime
date_end datetime
date_published datetime
end_action string
hidden_status string
id number
language_id number
num_comments number
num_ratings number
person_id number
slug string
status string
title string
total_rating number
view_count number
attachments Article Attachment
custom_data Custom Data Article
custom_data[#] Custom Data Article(data for article field with ID #)
labels Label Article
language Language
person Person
revisions Article Revision

Article Attachment (table: article_attachments)

Field Name Data Type
article_id number
blob_id number
date_created datetime
id number
person_id number
article Article
blob Blob
person Person

Article Comment (table: article_comments)

Field Name Data Type
article_id number
content string
date_created datetime
email string
id number
ip_address string
is_reviewed boolean
name string
person_id number
status string
validating string
visitor_id number
website string
article Article
person Person
visitor Visitor

Article Revision

Field Name Data Type
article_id number
content string
date_created datetime
id number
person_id number
status string
title string
article Article
person Person
Authors list

First published: 16/03/2017

Last updated: Mar 16, 2017 by Lauren Cumming