product_datetime_properties
This table represents the content of the product properties with the format datetime. The product properties represent calculated data for each product which should be loaded in the Solr Index. By filling this table and declaring the properties in the product_properties_metada, the system will will automatically upload and create/update your product properties in the Solr Index.
Field name | Type | Mode | Description |
---|---|---|---|
product_id | STRING | REQUIRED | PK - the product id |
property_name | STRING | REQUIRED | PK - the product property name |
property_value | DATETIME | REQUIRED | PK - the product property value |
origin | STRING | REQUIRED | please provide a unique key defining the origin system of these data, not used, but useful for debugging / monitoring |
creation_tm | TIMESTAMP | REQUIRED | please provide timestampe of the initial creation of this row |
last_modified_tm | TIMESTAMP | REQUIRED | please provide timestampe of the last modification of this row |