Malomo

Explore the interactive ERD

Table & Field Reference

order_discount_code

Column	Type	Keys
`index`	Unknown	PK
`order_id`	Unknown	PKFK
`amount`	Unknown
`code`	Unknown
`type`	Unknown

order_shopify_line_item_tag

Column	Type	Keys
`index`	Unknown	PK
`order_id`	Unknown	PKFK
`order_shopify_line_item_id`	Unknown	PKFK
`tags`	Unknown

order_shopify_line_item_property

Column	Type	Keys
`index`	Unknown	PK
`order_id`	Unknown	PKFK
`order_shopify_line_item_id`	Unknown	PKFK
`name`	Unknown
`value`	Unknown

order_shopify_line_item

Column	Type	Keys
`id`	Unknown	PK
`order_id`	Unknown	PKFK
`admin_graphql_api_id`	Unknown
`current_quantity`	Unknown
`final_line_price`	Unknown
`final_price`	Unknown
`fulfillment_service`	Unknown
`line_item_featured_image_alt`	Unknown
`line_item_featured_image_id`	Unknown
`line_item_featured_image_src`	Unknown
`line_item_image_alt`	Unknown
`line_item_image_id`	Unknown
`line_item_image_src`	Unknown
`line_item_product_description`	Unknown
`line_item_product_id`	Unknown
`line_item_product_title`	Unknown
`line_item_product_type`	Unknown
`line_item_product_url`	Unknown
`line_item_product_vendor`	Unknown
`line_item_variant_barcode`	Unknown
`line_item_variant_compare_at_price`	Unknown
`line_item_variant_id`	Unknown
`line_item_variant_image_alt`	Unknown
`line_item_variant_image_id`	Unknown
`line_item_variant_image_src`	Unknown
`line_item_variant_inventory_policy`	Unknown
`line_item_variant_inventory_quantity`	Unknown
`line_item_variant_option_1`	Unknown
`line_item_variant_option_2`	Unknown
`line_item_variant_option_3`	Unknown
`line_item_variant_price`	Unknown
`line_item_variant_require_shipping`	Unknown
`line_item_variant_sku`	Unknown
`line_item_variant_taxable`	Unknown
`line_item_variant_title`	Unknown
`line_item_variant_weight`	Unknown
`line_item_variant_weight_unit`	Unknown
`line_level_total_discount`	Unknown
`original_line_price`	Unknown
`original_price`	Unknown
`quantity`	Unknown
`require_shipping`	Unknown
`sku`	Unknown
`taxable`	Unknown
`title`	Unknown
`vendor`	Unknown

order_line_item

Column	Type	Keys
`index`	Unknown	PK
`order_id`	Unknown	PKFK
`final_line_price_amount`	Unknown
`final_line_price_currency`	Unknown
`fulfillable_quantity`	Unknown
`original_line_price_amount`	Unknown
`original_line_price_currency`	Unknown
`product_handle`	Unknown
`total_discount_amount`	Unknown
`total_discount_currency`	Unknown

order_shipment_scan_event

Column	Type	Keys
`index`	Unknown	PK
`order_id`	Unknown	PKFK
`order_shipment_id`	Unknown	PKFK
`carrier_code`	Unknown
`description`	Unknown
`location_city`	Unknown
`location_country`	Unknown
`location_postal_code`	Unknown
`location_state`	Unknown
`message`	Unknown
`scanned_at`	Unknown
`source`	Unknown
`status`	Unknown
`status_detail`	Unknown

order_shipment

Column	Type	Keys
`id`	Unknown	PK
`order_id`	Unknown	PKFK
`alternative_carrier_identifier`	Unknown
`carrier`	Unknown
`carrier_name`	Unknown
`carrier_service`	Unknown
`carrier_url`	Unknown
`container_type`	Unknown
`delivered_at`	Unknown
`destination_city`	Unknown
`destination_country`	Unknown
`destination_postal_code`	Unknown
`destination_state`	Unknown
`estimated_delivered_at`	Unknown
`estimated_local_delivered_at`	Unknown
`estimated_local_delivered_on`	Unknown
`guaranteed_delivered_at`	Unknown
`initial_delivery_attempted_at`	Unknown
`is_return`	Unknown
`origin_city`	Unknown
`origin_country`	Unknown
`origin_postal_code`	Unknown
`origin_state`	Unknown
`original_estimated_delivered_at`	Unknown
`signed_by`	Unknown
`status`	Unknown
`tracking_code`	Unknown
`weight`	Unknown

orders

Column	Type	Keys
`id`	Unknown	PK
`customer_id`	Unknown	FK
`shopify_order_id`	Unknown	FK
`alternate_id`	Unknown
`billing_address_address_1`	Unknown
`billing_address_address_2`	Unknown
`billing_address_city`	Unknown
`billing_address_company`	Unknown
`billing_address_country`	Unknown
`billing_address_country_code`	Unknown
`billing_address_first_name`	Unknown
`billing_address_id`	Unknown
`billing_address_last_name`	Unknown
`billing_address_name`	Unknown
`billing_address_phone`	Unknown
`billing_address_province`	Unknown
`billing_address_province_code`	Unknown
`billing_address_zip`	Unknown
`cancelled_at`	Unknown
`created_at`	Unknown
`default_address_address_1`	Unknown
`default_address_address_2`	Unknown
`default_address_city`	Unknown
`default_address_company`	Unknown
`default_address_country`	Unknown
`default_address_country_code`	Unknown
`default_address_first_name`	Unknown
`default_address_id`	Unknown
`default_address_last_name`	Unknown
`default_address_name`	Unknown
`default_address_phone`	Unknown
`default_address_province`	Unknown
`default_address_province_code`	Unknown
`default_address_zip`	Unknown
`delivered_at`	Unknown
`email`	Unknown
`fulfilled_at`	Unknown
`name`	Unknown
`number`	Unknown
`placed_at`	Unknown
`presentment_current_subtotal_price_amount`	Unknown
`presentment_current_subtotal_price_currency`	Unknown
`presentment_current_total_discount_amount`	Unknown
`presentment_current_total_discount_currency`	Unknown
`presentment_current_total_price_amount`	Unknown
`presentment_current_total_price_currency`	Unknown
`presentment_current_total_tax_amount`	Unknown
`presentment_current_total_tax_currency`	Unknown
`presentment_total_shipping_price_amount`	Unknown
`presentment_total_shipping_price_currency`	Unknown
`require_shipping`	Unknown
`return`	Json
`return_url`	Unknown
`shipping_address_address_1`	Unknown
`shipping_address_address_2`	Unknown
`shipping_address_city`	Unknown
`shipping_address_company`	Unknown
`shipping_address_country`	Unknown
`shipping_address_country_code`	Unknown
`shipping_address_first_name`	Unknown
`shipping_address_id`	Unknown
`shipping_address_last_name`	Unknown
`shipping_address_name`	Unknown
`shipping_address_phone`	Unknown
`shipping_address_province`	Unknown
`shipping_address_province_code`	Unknown
`shipping_address_updated_at`	Unknown
`shipping_address_zip`	Unknown
`shopify_order_cancel_reason`	Unknown
`shopify_order_cancelled_at`	Unknown
`shopify_order_created_at`	Unknown
`shopify_order_current_subtotal_price`	Unknown
`shopify_order_current_total_discount`	Unknown
`shopify_order_current_total_price`	Unknown
`shopify_order_current_total_tax`	Unknown
`shopify_order_customer_accept_marketing`	Unknown
`shopify_order_customer_address`	Json
`shopify_order_customer_email`	Unknown
`shopify_order_customer_first_name`	Unknown
`shopify_order_customer_id`	Unknown
`shopify_order_customer_last_name`	Unknown
`shopify_order_customer_order_count`	Unknown
`shopify_order_customer_phone`	Unknown
`shopify_order_customer_tax_exempt`	Unknown
`shopify_order_customer_total_spent`	Unknown
`shopify_order_email`	Unknown
`shopify_order_financial_status`	Unknown
`shopify_order_fulfillment`	Json
`shopify_order_fulfillment_status`	Unknown
`shopify_order_item_count`	Unknown
`shopify_order_line_item_count`	Unknown
`shopify_order_name`	Unknown
`shopify_order_note`	Unknown
`shopify_order_order_number`	Unknown
`shopify_order_order_status_url`	Unknown
`shopify_order_phone`	Unknown
`shopify_order_presentment_currency`	Unknown
`shopify_order_shipment_count`	Unknown
`shopify_order_shipping_price`	Unknown
`shopify_order_subtotal_price`	Unknown
`shopify_order_tax_price`	Unknown
`shopify_order_total_discount`	Unknown
`shopify_order_total_line_items_price`	Unknown
`shopify_order_total_net_amount`	Unknown
`shopify_order_total_price`	Unknown
`shopify_order_total_refunded_amount`	Unknown
`shopify_order_total_shipping_price`	Unknown
`updated_at`	Unknown
`url`	Unknown
`custom_`

customer

Column	Type	Keys
`id`	Unknown	PK
`created_at`	Unknown
`email`	Unknown
`first_name`	Unknown
`last_name`	Unknown
`phone_number`	Unknown
`updated_at`	Unknown