kb_use

The table below describes the kb_use table.

This table contains the following foldable columns:

• sys_id_value
• article_value
• user_value
• article_display_value
• sys_created_by_display_value
• sys_created_by_value
• sys_created_on_display_value
• sys_created_on_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
• times_viewed_display_value
• times_viewed_value
• used_display_value
• used_value
• user_display_value
• viewed_display_value
• viewed_value

The primary key columns in this table are returnable.

Column Name	SQL Type	Updatable	Nullable
sys_id_value Primary Key	SQL_VARCHAR(64)	False	False
article_value Foreign Key linked to column sys_id_value in kb_knowledge table	SQL_VARCHAR(64)	True	True
user_value Foreign Key linked to column sys_id_value in sys_user table	SQL_VARCHAR(64)	True	True
article_display_value	SQL_VARCHAR(500)	True	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_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
times_viewed_display_value	SQL_VARCHAR(500)	True	True
times_viewed_value	SQL_INTEGER(signed)	True	True
used_display_value	SQL_VARCHAR(500)	True	True
used_value	SQL_BIT	True	True
user_display_value	SQL_VARCHAR(500)	True	True
viewed_display_value	SQL_VARCHAR(500)	True	True
viewed_value	SQL_BIT	True	True