Footprints Data Model

Table
Name vt$item_fld_networkadapter$cha
Comment
This table is used in the upgrade to 12.1.03 to identify the "Network adapter
name" fields in dynamic tables like *_ws_000_asset that are too short.  It is
part of a bug fix to enable the insert a new asset from BCM integration with a
network adapter name longer than 255.  It identifies the specific configuration
settings that need to be updated.

Column
Name Datatype Comment Is PK Is FK
field_extlname_en_us varchar(255) field_externalName_en_US. No No
fieldrole varchar(255) fieldRole. No No
fieldlogicaldtype varchar(255) fieldLogicalDataType. No No
fld_defn_id bigint   No No
fld_defn_ver_id bigint   No No
draft_fld_defn_ver_id bigint   No No
active_cfg_setting_val_id bigint   No No
active_string_val varchar(255) active_string_val. No No
draft_cfg_setting_val_id bigint   No No
draft_string_val varchar(255) draft_string_val. No No
dyn_col_spec_id bigint   No No
logical_data_type_id int   No No
logical_data_type_name varchar(255) logical_data_type_name. No No
text_logical_data_type_id int   No No
schema_name varchar(30) schema_name. No No
table_name varchar(30) table_name. No No
col_name varchar(255) col_name. No No