jrobin_database

The table below describes the jrobin_database table.

This table contains the following foldable columns:

  • sys_id_value
  • cmdb_ci_value
  • definition_value
  • snc_mi_value
  • bytes_display_value
  • bytes_value
  • cmdb_ci_display_value
  • definition_display_value
  • name_display_value
  • name_value
  • patch_display_value
  • patch_value
  • snc_mi_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

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

cmdb_ci_value

Foreign Key linked to column sys_id_value in cmdb_ci table
 SQL_VARCHAR(64) True True

definition_value

Foreign Key linked to column sys_id_value in jrobin_definition table
 SQL_VARCHAR(64) True True

snc_mi_value

Foreign Key linked to column sys_id_value in snc_monitorable_item table
 SQL_VARCHAR(64) True True

bytes_display_value

 SQL_LONGVARCHAR(1024) True True

bytes_value

 SQL_LONGVARCHAR(1024) True True

cmdb_ci_display_value

 SQL_VARCHAR(500) True True

definition_display_value

 SQL_VARCHAR(500) True True

name_display_value

 SQL_VARCHAR(500) True True

name_value

 SQL_VARCHAR(400) True True

patch_display_value

 SQL_VARCHAR(7000) True True

patch_value

 SQL_VARCHAR(7000) True True

snc_mi_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