sc_item_option

The table below describes the sc_item_option table.

This table contains the following foldable columns:

  • sys_id_value
  • cart_item_value
  • item_option_new_value
  • sc_cat_item_option_value
  • cart_item_display_value
  • item_option_new_display_value
  • order_display_value
  • order_value
  • sc_cat_item_option_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
  • value_display_value
  • value_value
Column Name SQL Type Updatable Nullable

sys_id_value

Primary Key
 SQL_VARCHAR(64) False False

cart_item_value

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

item_option_new_value

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

sc_cat_item_option_value

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

cart_item_display_value

 SQL_VARCHAR(500) True True

item_option_new_display_value

 SQL_VARCHAR(500) True True

order_display_value

 SQL_VARCHAR(500) True True

order_value

 SQL_INTEGER(signed) True True

sc_cat_item_option_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

value_display_value

 SQL_VARCHAR(8000) True True

value_value

 SQL_VARCHAR(8000) True True