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 |
| 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 |
Please log in or register to submit a comment.