Data schema structure
The structure of the Canada Address Fabric™ 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.
- The two worksheets labeled as Data Schema and Changelog Data Schema, are now represented in one worksheet called Data Schema.
- 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:
- table_friendly_name
- field_friendly_name
- index
- grouping
- primary_key
- type_code
- table_name
- The following field column names have changed:
Old field column name New field column name Table Name product_friendly_name Seq. sequence_number Field Name field_name Data Type (Length) data_type Data Type (Length) field_length Field Value Key Reference field_value_key_reference Field Description description