# Rithum schema ERD

Table and field reference for the Fivetran Rithum connector.

## Table & Field Reference

### order_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| order_id | Unknown | FK |
| product_id | Unknown | FK |
| profile_id | Unknown | FK |
| gift_price | Unknown |  |
| gift_tax_price | Unknown |  |
| is_bundle | Unknown |  |
| quantity | Unknown |  |
| recycling_fee | Unknown |  |
| shipping_price | Unknown |  |
| shipping_tax_price | Unknown |  |
| site_id | Unknown |  |
| site_listing_id | Unknown |  |
| site_order_item_id | Unknown |  |
| sku | Unknown |  |
| tax_price | Unknown |  |
| title | Unknown |  |
| unit_estimated_shipping_cost | Unknown |  |
| unit_price | Unknown |  |

### product_bundle_component

| Column | Type | Keys |
| --- | --- | --- |
| component_id | Unknown | PK |
| product_id | Unknown | PK, FK |
| profile_id | Unknown | FK |
| component_sku | Unknown |  |
| quantity | Unknown |  |

### distribution_center

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| address_1 | Unknown |  |
| address_2 | Unknown |  |
| alt_phone | Unknown |  |
| business_description | Unknown |  |
| city | Unknown |  |
| code | Unknown |  |
| contact_email | Unknown |  |
| contact_name | Unknown |  |
| contact_phone | Unknown |  |
| country | Unknown |  |
| delivery_available | Unknown |  |
| district | Unknown |  |
| email | Unknown |  |
| fulfillment_partner_name | Unknown |  |
| handling_time_minute | Unknown |  |
| home_page | Unknown |  |
| is_externally_managed | Unknown |  |
| latitude | Unknown |  |
| longitude | Unknown |  |
| main_phone | Unknown |  |
| name | Unknown |  |
| pickup_location | Unknown |  |
| pickup_order_hold_minute | Unknown |  |
| postal_code | Unknown |  |
| ship_location | Unknown |  |
| state_or_province | Unknown |  |
| store_categories | Unknown |  |
| throughput_limit_number | Unknown |  |
| throughput_limit_unit | Unknown |  |
| time_zone | Unknown |  |
| type | Unknown |  |

### distributed_center_operating_hour

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| distribution_center_id | Unknown | FK |
| close_time | Unknown |  |
| day_id | Unknown |  |
| open_time | Unknown |  |

### shipping_label_partner_account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| profile_id | Unknown | PK, FK |
| account_name | Unknown |  |
| partner_name | Unknown |  |

### site_account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| site_id | Unknown | PK |
| profile_id | Unknown | FK |
| enabled | Unknown |  |
| name | Unknown |  |
| site_name | Unknown |  |

### profile

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_name | Unknown |  |
| company_name | Unknown |  |
| currency_code | Unknown |  |
| default_distribution_center_id | Unknown |  |
| time_zone_description | Unknown |  |
| time_zone_region | Unknown |  |

### package

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| profile_id | Unknown | FK |
| description | Unknown |  |
| name | Unknown |  |
| shipping_carrier | Unknown |  |

### buyer_initiated_return_adjustment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| order_id | Unknown | FK |
| order_item_id | Unknown | FK |
| profile_id | Unknown | FK |
| comment | Unknown |  |
| created_date | Unknown |  |
| gift_wrap_adjustment | Unknown |  |
| gift_wrap_tax_adjustment | Unknown |  |
| is_restock | Unknown |  |
| item_adjustment | Unknown |  |
| public_note | Unknown |  |
| quantity | Unknown |  |
| reason | Unknown |  |
| recycling_fee_adjustment | Unknown |  |
| request_status | Unknown |  |
| restock_status | Unknown |  |
| restocking_fee | Unknown |  |
| return_shipping_fee | Unknown |  |
| return_shipping_method | Unknown |  |
| return_tracking_number_or_url | Unknown |  |
| rma_number | Unknown |  |
| seller_adjustment_id | Unknown |  |
| shipping_adjustment | Unknown |  |
| shipping_tax_adjustment | Unknown |  |
| tax_adjustment | Unknown |  |
| type | Unknown |  |

### buyer_initiated_return

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| order_id | Unknown | FK |
| product_id | Unknown | FK |
| profile_id | Unknown | FK |
| gift_message | Unknown |  |
| gift_notes | Unknown |  |
| gift_price | Unknown |  |
| gift_tax_price | Unknown |  |
| is_bundle | Unknown |  |
| item_url | Unknown |  |
| quantity | Unknown |  |
| recycling_fee | Unknown |  |
| shipping_price | Unknown |  |
| shipping_tax_price | Unknown |  |
| site_listing_id | Unknown |  |
| site_order_item_id | Unknown |  |
| sku | Unknown |  |
| tax_price | Unknown |  |
| title | Unknown |  |
| unit_price | Unknown |  |

### product

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| profile_id | Unknown | FK |
| asin | Unknown |  |
| block_comment | Unknown |  |
| blocked_date | Unknown |  |
| brand | Unknown |  |
| bundle_type | Unknown |  |
| buy_it_now_price | Unknown |  |
| classification | Unknown |  |
| condition | Unknown |  |
| cost | Unknown |  |
| description | Unknown |  |
| ean | Unknown |  |
| flag | Unknown |  |
| flag_description | Unknown |  |
| harmonized_code | Unknown |  |
| is_available_in_store | Unknown |  |
| is_blocked | Unknown |  |
| is_display_in_store | Unknown |  |
| is_external_quantity_blocked | Unknown |  |
| is_in_relationship | Unknown |  |
| is_parent | Unknown |  |
| isbn | Unknown |  |
| manufacturer | Unknown |  |
| margin | Unknown |  |
| mpn | Unknown |  |
| open_allocated_quantity | Unknown |  |
| open_allocated_quantity_pooled | Unknown |  |
| parent_product_id | Unknown |  |
| pending_checkout_quantity | Unknown |  |
| pending_checkout_quantity_pooled | Unknown |  |
| pending_payment_quantity | Unknown |  |
| pending_payment_quantity_pooled | Unknown |  |
| pending_shipment_quantity | Unknown |  |
| pending_shipment_quantity_pooled | Unknown |  |
| received_date | Unknown |  |
| relationship_name | Unknown |  |
| reserve_price | Unknown |  |
| retail_price | Unknown |  |
| second_chance_price | Unknown |  |
| short_description | Unknown |  |
| sku | Unknown |  |
| starting_price | Unknown |  |
| store_description | Unknown |  |
| store_price | Unknown |  |
| store_title | Unknown |  |
| subtitle | Unknown |  |
| supplier_code | Unknown |  |
| supplier_name | Unknown |  |
| supplier_po | Unknown |  |
| tax_product_code | Unknown |  |
| title | Unknown |  |
| total_available_quantity | Unknown |  |
| total_quantity | Unknown |  |
| total_quantity_pooled | Unknown |  |
| upc | Unknown |  |
| warehouse_location | Unknown |  |
| warranty | Unknown |  |

### fulfillment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| distribution_center_id | Unknown | FK |
| order_id | Unknown | FK |
| profile_id | Unknown | FK |
| channel_return_label_format | Unknown |  |
| created_date | Unknown |  |
| delivery_status | Unknown |  |
| estimated_ship_date | Unknown |  |
| external_fulfillment_center_code | Unknown |  |
| external_fulfillment_number | Unknown |  |
| external_fulfillment_reference_number | Unknown |  |
| external_fulfillment_status | Unknown |  |
| has_channel_packing_slip | Unknown |  |
| has_channel_return_label | Unknown |  |
| has_return_label | Unknown |  |
| has_shipping_label | Unknown |  |
| insurance_cost | Unknown |  |
| label_format | Unknown |  |
| return_label_format | Unknown |  |
| seller_fulfillment_id | Unknown |  |
| shipped_date | Unknown |  |
| shipping_carrier | Unknown |  |
| shipping_class | Unknown |  |
| shipping_cost | Unknown |  |
| shipping_label_request_id | Unknown |  |
| staging_location | Unknown |  |
| tax_cost | Unknown |  |
| tracking_number | Unknown |  |
| type | Unknown |  |
| updated_date | Unknown |  |

### orders

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| profile_id | Unknown | FK |
| site_id | Unknown | FK |
| additional_cost_or_discount | Unknown |  |
| billing_address_line_1 | Unknown |  |
| billing_address_line_2 | Unknown |  |
| billing_city | Unknown |  |
| billing_company_job_title | Unknown |  |
| billing_company_name | Unknown |  |
| billing_country | Unknown |  |
| billing_daytime_phone | Unknown |  |
| billing_evening_phone | Unknown |  |
| billing_first_name | Unknown |  |
| billing_last_name | Unknown |  |
| billing_postal_code | Unknown |  |
| billing_state_or_province | Unknown |  |
| billing_suffix | Unknown |  |
| billing_title | Unknown |  |
| buyer_email_address | Unknown |  |
| buyer_email_opt_in | Unknown |  |
| buyer_user_id | Unknown |  |
| checkout_date | Unknown |  |
| checkout_source_id | Unknown |  |
| checkout_status | Unknown |  |
| created_date | Unknown |  |
| deliver_by_date | Unknown |  |
| distribution_center_type_rollup | Unknown |  |
| estimated_ship_date | Unknown |  |
| flag_description | Unknown |  |
| flag_id | Unknown |  |
| gift_options_tax_type | Unknown |  |
| import_date | Unknown |  |
| order_tag | Unknown |  |
| order_tax_type | Unknown |  |
| payment_credit_card_last_4 | Unknown |  |
| payment_date | Unknown |  |
| payment_merchant_reference_number | Unknown |  |
| payment_method | Unknown |  |
| payment_paypal_account_id | Unknown |  |
| payment_status | Unknown |  |
| payment_transaction_id | Unknown |  |
| private_note | Unknown |  |
| promotion_amount | Unknown |  |
| promotion_code | Unknown |  |
| public_note | Unknown |  |
| reseller_id | Unknown |  |
| secondary_site_order_id | Unknown |  |
| seller_order_id | Unknown |  |
| shipping_address_line_1 | Unknown |  |
| shipping_address_line_2 | Unknown |  |
| shipping_city | Unknown |  |
| shipping_company_job_title | Unknown |  |
| shipping_company_name | Unknown |  |
| shipping_country | Unknown |  |
| shipping_date | Unknown |  |
| shipping_daytime_phone | Unknown |  |
| shipping_evening_phone | Unknown |  |
| shipping_first_name | Unknown |  |
| shipping_last_name | Unknown |  |
| shipping_postal_code | Unknown |  |
| shipping_state_or_province | Unknown |  |
| shipping_status | Unknown |  |
| shipping_suffix | Unknown |  |
| shipping_tax_type | Unknown |  |
| shipping_title | Unknown |  |
| site_order_id | Unknown |  |
| special_instruction | Unknown |  |
| total_gift_option_price | Unknown |  |
| total_gift_option_tax_price | Unknown |  |
| total_insurance_price | Unknown |  |
| total_price | Unknown |  |
| total_shipping_price | Unknown |  |
| total_shipping_tax_price | Unknown |  |
| total_tax_price | Unknown |  |
| updated_date | Unknown |  |

### channel_document

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| order_id | Unknown | FK |
| profile_id | Unknown | FK |
| adjustment_id | Unknown |  |
| contents | Unknown |  |
| create_date | Unknown |  |
| document_key | Unknown |  |
| document_type | Unknown |  |
| invoice_number | Unknown |  |
| status | Unknown |  |
| total_amount | Unknown |  |
| update_date | Unknown |  |

### product_attribute

| Column | Type | Keys |
| --- | --- | --- |
| product_id | Unknown | PK, FK |
| value | Unknown |  |

## Relationships

- order_item(product_id) → product(id)
- order_item(order_id) → orders(id)
- order_item(profile_id) → profile(id)
- product_bundle_component(product_id) → product(id)
- product_bundle_component(profile_id) → profile(id)
- distributed_center_operating_hour(distribution_center_id) → distribution_center(id)
- shipping_label_partner_account(profile_id) → profile(id)
- site_account(profile_id) → profile(id)
- package(profile_id) → profile(id)
- buyer_initiated_return_adjustment(order_id) → orders(id)
- buyer_initiated_return_adjustment(profile_id) → profile(id)
- buyer_initiated_return_adjustment(order_item_id) → order_item(id)
- buyer_initiated_return(product_id) → product(id)
- buyer_initiated_return(order_id) → orders(id)
- buyer_initiated_return(profile_id) → profile(id)
- product(profile_id) → profile(id)
- fulfillment(distribution_center_id) → distribution_center(id)
- fulfillment(order_id) → orders(id)
- fulfillment(profile_id) → profile(id)
- orders(profile_id) → profile(id)
- orders(site_id) → site_account(site_id)
- channel_document(order_id) → orders(id)
- channel_document(profile_id) → profile(id)
- product_attribute(product_id) → product(id)