# Malomo schema ERD

Table and field reference for the Fivetran Malomo connector.

## Table & Field Reference

### order_discount_code

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| order_id | Unknown | PK, FK |
| amount | Unknown |  |
| code | Unknown |  |
| type | Unknown |  |

### order_shopify_line_item_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| order_id | Unknown | PK, FK |
| order_shopify_line_item_id | Unknown | PK, FK |
| tags | Unknown |  |

### order_shopify_line_item_property

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| order_id | Unknown | PK, FK |
| order_shopify_line_item_id | Unknown | PK, FK |
| name | Unknown |  |
| value | Unknown |  |

### order_shopify_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| order_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| order_shipment_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 |  |

## Relationships

- order_discount_code(order_id) → orders(id)
- order_shopify_line_item_tag(order_shopify_line_item_id) → order_shopify_line_item(id)
- order_shopify_line_item_tag(order_id) → order_shopify_line_item(order_id)
- order_shopify_line_item_property(order_shopify_line_item_id) → order_shopify_line_item(id)
- order_shopify_line_item_property(order_id) → order_shopify_line_item(order_id)
- order_shopify_line_item(order_id) → orders(id)
- order_line_item(order_id) → orders(id)
- order_shipment_scan_event(order_id) → order_shipment(order_id)
- order_shipment_scan_event(order_shipment_id) → order_shipment(id)
- order_shipment(order_id) → orders(id)
- orders(shopify_order_id) → orders(alternate_id)
- orders(customer_id) → customer(id)