kb_knowledge
The table below describes the kb_knowledge table.
This table contains the following foldable columns:
- sys_id_value
- author_value
- cmdb_ci_value
- kb_category_value
- kb_knowledge_base_value
- source_value
- active_display_value
- active_value
- article_type_display_value
- article_type_value
- author_display_value
- category_display_value
- category_value
- cmdb_ci_display_value
- description_display_value
- description_value
- direct_display_value
- direct_value
- disable_commenting_display_value
- disable_commenting_value
- disable_suggesting_display_value
- disable_suggesting_value
- display_attachments_display_value
- display_attachments_value
- flagged_display_value
- flagged_value
- image_display_value
- image_value
- kb_category_display_value
- kb_knowledge_base_display_value
- meta_display_value
- meta_value
- number_display_value
- number_value
- published_display_value
- published_value
- rating_display_value
- rating_value
- retired_display_value
- retired_value
- roles_display_value
- roles_value
- short_description_display_value
- short_description_value
- source_display_value
- sys_class_name_display_value
- sys_class_name_value
- sys_created_by_display_value
- sys_created_by_value
- sys_created_on_display_value
- sys_created_on_value
- sys_domain_display_value
- sys_domain_path_display_value
- sys_domain_path_value
- sys_domain_value
- sys_id_display_value
- sys_mod_count_display_value
- sys_mod_count_value
- sys_tags_display_value
- sys_tags_value
- sys_updated_by_display_value
- sys_updated_by_value
- sys_updated_on_display_value
- sys_updated_on_value
- sys_view_count_display_value
- sys_view_count_value
- text_display_value
- text_value
- topic_display_value
- topic_value
- use_count_display_value
- use_count_value
- valid_to_display_value
- valid_to_value
- wiki_display_value
- wiki_value
- workflow_state_display_value
- workflow_state_value
| Column Name | SQL Type | Updatable | Nullable |
|---|---|---|---|
|
sys_id_value Primary Key |
SQL_VARCHAR(64) | False | False |
|
author_value Foreign Key linked to column sys_id_value in sys_user table |
SQL_VARCHAR(64) | True | True |
|
cmdb_ci_value Foreign Key linked to column sys_id_value in cmdb_ci table |
SQL_VARCHAR(64) | True | True |
|
kb_category_value Foreign Key linked to column sys_id_value in kb_category table |
SQL_VARCHAR(64) | True | True |
|
kb_knowledge_base_value Foreign Key linked to column sys_id_value in kb_knowledge_base table |
SQL_VARCHAR(64) | True | True |
|
source_value Foreign Key linked to column sys_id_value in task table |
SQL_VARCHAR(64) | True | True |
|
active_display_value |
SQL_VARCHAR(500) | True | True |
|
active_value |
SQL_BIT | True | True |
|
article_type_display_value |
SQL_VARCHAR(500) | True | True |
|
article_type_value |
SQL_VARCHAR(80) | True | True |
|
author_display_value |
SQL_VARCHAR(500) | True | True |
|
category_display_value |
SQL_VARCHAR(500) | True | True |
|
category_value |
SQL_VARCHAR(80) | True | True |
|
cmdb_ci_display_value |
SQL_VARCHAR(500) | True | True |
|
description_display_value |
SQL_VARCHAR(8000) | True | True |
|
description_value |
SQL_VARCHAR(8000) | True | True |
|
direct_display_value |
SQL_VARCHAR(500) | True | True |
|
direct_value |
SQL_BIT | True | True |
|
disable_commenting_display_value |
SQL_VARCHAR(500) | True | True |
|
disable_commenting_value |
SQL_BIT | True | True |
|
disable_suggesting_display_value |
SQL_VARCHAR(500) | True | True |
|
disable_suggesting_value |
SQL_BIT | True | True |
|
display_attachments_display_value |
SQL_VARCHAR(500) | True | True |
|
display_attachments_value |
SQL_BIT | True | True |
|
flagged_display_value |
SQL_VARCHAR(500) | True | True |
|
flagged_value |
SQL_BIT | True | True |
|
image_display_value |
SQL_VARCHAR(500) | True | True |
|
image_value |
SQL_VARCHAR(256) | True | True |
|
kb_category_display_value |
SQL_VARCHAR(500) | True | True |
|
kb_knowledge_base_display_value |
SQL_VARCHAR(500) | True | True |
|
meta_display_value |
SQL_VARCHAR(8000) | True | True |
|
meta_value |
SQL_VARCHAR(8000) | True | True |
|
number_display_value |
SQL_VARCHAR(500) | True | True |
|
number_value |
SQL_VARCHAR(80) | True | True |
|
published_display_value |
SQL_VARCHAR(500) | True | True |
|
published_value |
SQL_DATE | True | True |
|
rating_display_value |
SQL_VARCHAR(500) | True | True |
|
rating_value |
SQL_NUMERIC(38,3) | True | True |
|
retired_display_value |
SQL_VARCHAR(500) | True | True |
|
retired_value |
SQL_DATE | True | True |
|
roles_display_value |
SQL_VARCHAR(500) | True | True |
|
roles_value |
SQL_VARCHAR(256) | True | True |
|
short_description_display_value |
SQL_VARCHAR(500) | True | True |
|
short_description_value |
SQL_VARCHAR(200) | True | True |
|
source_display_value |
SQL_VARCHAR(500) | True | True |
|
sys_class_name_display_value |
SQL_VARCHAR(500) | False | True |
|
sys_class_name_value |
SQL_VARCHAR(160) | False | True |
|
sys_created_by_display_value |
SQL_VARCHAR(500) | False | True |
|
sys_created_by_value |
SQL_VARCHAR(80) | False | True |
|
sys_created_on_display_value |
SQL_VARCHAR(500) | False | True |
|
sys_created_on_value |
SQL_TIMESTAMP | False | True |
|
sys_domain_display_value |
SQL_VARCHAR(500) | False | True |
|
sys_domain_path_display_value |
SQL_VARCHAR(500) | False | True |
|
sys_domain_path_value |
SQL_VARCHAR(510) | False | True |
|
sys_domain_value |
SQL_VARCHAR(64) | False | True |
|
sys_id_display_value |
SQL_VARCHAR(500) | False | False |
|
sys_mod_count_display_value |
SQL_VARCHAR(500) | False | True |
|
sys_mod_count_value |
SQL_INTEGER(signed) | False | True |
|
sys_tags_display_value |
SQL_VARCHAR(500) | False | True |
|
sys_tags_value |
SQL_VARCHAR(256) | False | True |
|
sys_updated_by_display_value |
SQL_VARCHAR(500) | False | True |
|
sys_updated_by_value |
SQL_VARCHAR(80) | False | True |
|
sys_updated_on_display_value |
SQL_VARCHAR(500) | False | True |
|
sys_updated_on_value |
SQL_TIMESTAMP | False | True |
|
sys_view_count_display_value |
SQL_VARCHAR(500) | True | True |
|
sys_view_count_value |
SQL_INTEGER(signed) | True | True |
|
text_display_value |
SQL_LONGVARCHAR(1024) | True | True |
|
text_value |
SQL_LONGVARCHAR(1024) | True | True |
|
topic_display_value |
SQL_VARCHAR(500) | True | True |
|
topic_value |
SQL_VARCHAR(80) | True | True |
|
use_count_display_value |
SQL_VARCHAR(500) | True | True |
|
use_count_value |
SQL_INTEGER(signed) | True | True |
|
valid_to_display_value |
SQL_VARCHAR(500) | True | True |
|
valid_to_value |
SQL_DATE | True | True |
|
wiki_display_value |
SQL_LONGVARCHAR(1024) | True | True |
|
wiki_value |
SQL_LONGVARCHAR(1024) | True | True |
|
workflow_state_display_value |
SQL_VARCHAR(500) | True | True |
|
workflow_state_value |
SQL_VARCHAR(256) | True | True |