Table Schema: mf_order_item

This topic describes the columns in the mf_order_item_options table.

Column Name: The name of the column.
Data Type: The data type of the column.
Primary Key: The value is 1 if the column is part of the primary key; 0 if not.
Is Nullable: The value is 1 if the column can have a NULL value; 0 if not.
Column ID: The ID number of the column.
Comment: Text describing the column data (if available).
Reference Count: The number of other columns that have a foreign key pointing to this column. Only tables that exist in the reporting database are considered.
Reference To: The parent table and column (if there is an upward constraint). Only tables that exist in the reporting database are considered.

Column Name	Data Type	Primary Key	Is Nullable	Column ID	Reference Count	Reference To
order_item_option_guid	uniqueidentifier	1	0	1	1
order_guid	uniqueidentifier	0	0	2	0
order_item_guid	uniqueidentifier	0	0	3	0	mf_order_items.order_item_guid
order_item_option_id	varchar (50)	0	1	4	0
order_item_option_label	varchar (50)	0	1	5	0
order_item_option_description	varchar (255)	0	1	6	0
order_item_option_value_id	varchar (50)	0	1	7	0
order_item_option_value_label	varchar (50)	0	1	8	0
order_item_option_value_description	varchar (255)	0	1	9	0
order_item_option_unit_price	decimal (16,6)	0	0	10	0
order_item_option_tax	money	0	0	11	0
order_item_option_extended_price	money	0	0	18	0
order_item_option_quantity	int	0	0	19	0
order_item_option_unit_price_ref	decimal (16,6)	0	0	20	0
order_item_option_price_adjustment	money	0	0	21	0
order_item_option_price_adjustment_tax	money	0	0	22	0

Table Schema: mf_order_item_options