Data schema structure
The structure of the Property Historical Sales Data Schema has been changed to support Precisely's Data Integrity Suite and SaaS solutions. The changes are as follows:
- Please 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 are 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
Additionally, new database loadable files built from the new Data Schema structure, can be downloaded using the links provided in the Property Historical Sales Getting Started Guide.