Order Attribute¶
Table name (referenced in Insights SQL queries): marts_mdc__order_attribute
Custom attributes attached to orders, provided by the merchant or by the integration. Contains one row per attribute, one order can have multiple attributes. Join with the Order model on order_id.
Columns¶
| Column | Type | Description |
|---|---|---|
order_id |
number |
Unique identifier for the order within the system. |
account_id |
number |
Identifier for the account that placed the order. |
attribute_name |
varchar |
Name of the custom order attribute. |
attribute_value |
varchar |
Value of the custom order attribute. |