Table Type: Metadata
This table contains the knowledgebase question and answer articles.
Columns
| Column | Type | Modifiers | Notes |
|---|---|---|---|
| category_id | string | The ID 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. | |
| 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 |