News (table: news)

Field Name Data Type
category_id number
content string
date_created datetime
date_published datetime
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
category News Category
labels Label News
language Language
person Person
revisions News Revision

News Category (table: news_categories)

Field Name Data Type
depth number
display_order number
id number
parent_id number
root number
title string
children News Category
parent News Category

News Comment (table: news_comments)

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

News Revision (table: news_revisions)

Field Name Data Type
content string
date_created datetime
id number
news_id number
person_id number
status string
title string
news News
person Person

Published: 16/03/2017

Last updated: 16/03/2017