Data schema structure
The structure of the Community Link, Market Link, and Master Link Data Schema has been changed to support Precisely's Data Integrity Suite and SaaS solutions. The changes are as follows:
- Refer to the field column definitions on the Notices worksheet. Some of these fields are specific for use with Precisely Software Solutions.
- All CHAR and VARCHAR fields types are represented as TEXT.
- Data type and length are added in two separate columns.
- The following new field columns have been added to the Data Schema:
- product_table_name
- index
- primary_key
- type_code
- table_name
- The following field column names have changed:
Old field column name New field column name Table Name table_friendly_name Information Type grouping Seq. sequence_number Field Name field_name Long Name field_friendly_name Data Type (Length) data_type Data Type (Length) field_length Field Value Key field_value_key_reference Description description