Rithum

Explore the interactive ERD

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	PKFK
`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	PKFK
`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	PKFK
`value`	Unknown