alm_m2m_stockroom_model

The table below describes the alm_m2m_stockroom_model table.

This table contains the following foldable columns:

  • sys_id_value
  • model_value
  • stockroom_value
  • model_display_value
  • stockroom_display_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

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

model_value

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

stockroom_value

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

model_display_value

 SQL_VARCHAR(500) True True

stockroom_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_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