Table Type:
This table contains the knowledgebase question and answer articles.
Columns
| Column | Type | Modifiers | Notes |
|---|---|---|---|
| category_date_created | datetime | The date the category was created. | |
| category_date_modified | datetime | The date the category was last modified. | |
| category_description | string | The description of the category. | |
| category_document_count | int32 | The number of documents in the category. | |
| category_external_id | string | The external ID of the category. | |
| category_id | string | The ID of the category this article is in | |
| category_name | string | The name of the category this article is in | |
| created_by_id | string | The ID of the user who created the article. | |
| date_created | datetime | The date the article was created. | |
| date_imported | datetime | The date the article was imported. | |
| date_modified | datetime | The date the article was last modified. | |
| date_published | datetime | The date the article was published. | |
| document_version_id | string | The ID of the document version. | |
| external_id | string | The external ID of the article. | |
| knowledge_base_id | string | The ID of the knowledge base this article is in. | |
| last_published_version_number | int32 | The last published version number. | |
| modified_by_id | string | The ID of the user who last modified the article. | |
| polled | boolean | Indicates whether the article has been polled. | |
| state | string | The state of the article - one of: Draft, Published, Archived | |
| title | string | The title of the article. | |
| visible | boolean | Indicates whether the article is visible. | |
| db_last_updated | datetime | The time the record was last updated in the database in UTC | |
| db_when_created | datetime | Required | The time the record was created in the database in UTC |
| db_when_deleted | datetime | The time the record was deleted in the database in UTC or NULL | |
| id | string | Primary Key | The unique id for this entity |