1144 Length of NDT_Name of 40 characters is too short

We have hit a situation that the identifier field of 40 characters is too short to accomodate some data being migrated from legacy databases. We have had to extend the following columns to 50 characters as a temporary workaround, but would like to see a general extension of the NDT_Name field to 50 or more characters covering all attributes that are based on NDT_Name: Table Name Attribute Name ============ ============== BSASC bsasc_id BSASC_ALIAS id, COORDINATE_SYS coordinate_sys_id, CORD_SYS_ALIAS id, FIELD field_id, ERTH_SFTR_ALIAS id, WELL well_id, WELL_ALIAS id, WELLBORE_ALIAS id. Note that while the wellbore_id in table WELLBORE is defined as 50 characters, the id column in WELLBORE_ALIAS is only 40!

Consolidated changes: (0761)

name domain too short for some requirements

40 characters is too short for Geopoliticial_feature names. The identifier inherited from the supertype, Earth_surface_feature, was modified to have a new ndt, ndt_long_name. The Earth_surface_feature_alias identifier was changed to ndt_long_name to correspond. The identifier was moved from the supertype of Earth_surface_feature_alias, object_alias, and put into all of its subtypes, with the same ndt domain (ndt_name) for everything except for Earth_surface_feature alias. Earth_surface_feature_alias has been made a subtype of reference_behavior.

Modified objects:
earth_surface_feature.identifier (Attribute)
earth_surface_feature_alias (Entity)
geodetic_datum.identifier (Attribute)
wellbore.identifier (Attribute)
wellbore_alias.identifier (Attribute)

move identifier attributes from object_alias to subtypes

To handle name length change for earth_surface_feature and its alias, the identifier attribute of object_alias has been removed and an equivalent attribute added at the subtype level.

Added objects:
business_associate_alias.identifier (Attribute)
catalog_equipment_alias.identifier (Attribute)
contract_alias.identifier (Attribute)
coordinate_system_alias.identifier (Attribute)
earth_surface_feature_alias.identifier (Attribute)
ellipsoid_alias.identifier (Attribute)
geodetic_datum_alias.identifier (Attribute)
inventory_object_alias.identifier (Attribute)
land_property_parcel_alias.identifier (Attribute)
log_trace_alias.identifier (Attribute)
rock_feature_alias.identifier (Attribute)
seismic_geometry_alias.identifier (Attribute)
stratigraphic_marker_alias.identifier (Attribute)
temporal_object_alias.identifier (Attribute)
typical_material_alias.identifier (Attribute)
well_alias.identifier (Attribute)

lengthen earth_surface_feature name and remove identifier from object_alias

To handle name length change for earth_surface_feature and its alias, the identifier attribute of object_alias has been removed and an equivalent attribute added at the subtype level

Deleted objects:
object_alias.identifier (Attribute)