# Lightspeed Retail X-Series schema ERD

Table and field reference for the Fivetran Lightspeed Retail X-Series connector.

## Table & Field Reference

### inventory

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| outlet_id | Unknown | FK |
| product_id | Unknown | FK |
| average_cost | Unknown |  |
| current_amount | Unknown |  |
| deleted_at | Instant |  |
| inventory_level | Unknown |  |
| reorder_amount | Unknown |  |
| reorder_point | Unknown |  |
| version | Unknown |  |

### supplier

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_company_name | Unknown |  |
| contact_email | Unknown |  |
| contact_fax | Unknown |  |
| contact_first_name | Unknown |  |
| contact_last_name | Unknown |  |
| contact_mobile | Unknown |  |
| contact_phone | Unknown |  |
| contact_physical_address_1 | Unknown |  |
| contact_physical_address_2 | Unknown |  |
| contact_physical_city | Unknown |  |
| contact_physical_country_id | Unknown |  |
| contact_physical_postcode | Unknown |  |
| contact_physical_state | Unknown |  |
| contact_physical_suburb | Unknown |  |
| contact_postal_address_1 | Unknown |  |
| contact_postal_address_2 | Unknown |  |
| contact_postal_city | Unknown |  |
| contact_postal_country_id | Unknown |  |
| contact_postal_postcode | Unknown |  |
| contact_postal_state | Unknown |  |
| contact_postal_suburb | Unknown |  |
| contact_twitter | Unknown |  |
| contact_website | Unknown |  |
| default_markup | Unknown |  |
| deleted_at | Instant |  |
| description | Unknown |  |
| name | Unknown |  |
| source | Unknown |  |
| version | Unknown |  |

### outlet

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| attributes | Json |  |
| currency | Unknown |  |
| currency_symbol | Unknown |  |
| deleted_at | Instant |  |
| display_price | Unknown |  |
| email | Unknown |  |
| latitude | Unknown |  |
| longitude | Unknown |  |
| name | Unknown |  |
| phone | Unknown |  |
| physical_address_1 | Unknown |  |
| physical_address_2 | Unknown |  |
| physical_city | Unknown |  |
| physical_country_id | Unknown |  |
| physical_postcode | Unknown |  |
| physical_state | Unknown |  |
| physical_suburb | Unknown |  |
| time_zone | Unknown |  |
| version | Unknown |  |

### brand

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| deleted_at | Instant |  |
| description | Unknown |  |
| name | Unknown |  |
| version | Unknown |  |

### product_tag

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

### product_category_tag

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| product_id | Unknown | PK, FK |
| deleted_at | Unknown |  |
| name | Unknown |  |
| version | Unknown |  |

### product_variant_option

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| product_id | Unknown | PK, FK |
| name | Unknown |  |
| values | Json |  |

### product_supplier

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| product_id | Unknown | PK, FK |
| supplier_id | Unknown | FK |
| code | Unknown |  |
| price | Unknown |  |

### product_code

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| product_id | Unknown | PK, FK |
| code | Unknown |  |
| id | Unknown |  |
| type | Unknown |  |

### product

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| brand_id | Unknown | FK |
| product_category_id | Unknown | FK |
| supplier_id | Unknown | FK |
| account_code | Unknown |  |
| account_code_purchase | Unknown |  |
| active | Unknown |  |
| attributes | Json |  |
| button_order | Unknown |  |
| created_at | Instant |  |
| deleted_at | Instant |  |
| description | Unknown |  |
| dimensions_unit | Unknown |  |
| ecwid_enabled_webstore | Unknown |  |
| family_id | Unknown |  |
| handle | Unknown |  |
| has_inventory | Unknown |  |
| height | Unknown |  |
| image_thumbnail_url | Unknown |  |
| image_url | Unknown |  |
| images | Json |  |
| is_active | Unknown |  |
| is_composite | Unknown |  |
| is_variant | Unknown |  |
| length | Unknown |  |
| loyalty_amount | Unknown |  |
| name | Unknown |  |
| packaging_breaks_into | Json |  |
| packaging_made_from | Json |  |
| price_excluding_tax | Unknown |  |
| price_including_tax | Unknown |  |
| sku | Unknown |  |
| sku_images | Json |  |
| source | Unknown |  |
| source_id | Unknown |  |
| source_variant_id | Unknown |  |
| supplier_code | Unknown |  |
| supply_price | Unknown |  |
| type_deleted_at | Unknown |  |
| type_version | Unknown |  |
| updated_at | Instant |  |
| variant_count | Unknown |  |
| variant_name | Unknown |  |
| variant_parent_id | Unknown |  |
| version | Unknown |  |
| weight | Unknown |  |
| weight_unit | Unknown |  |
| width | Unknown |  |

### retailer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| discount_product_id | Unknown | FK |
| account_status | Unknown |  |
| account_type | Unknown |  |
| activated_at | Instant |  |
| country | Unknown |  |
| create_customer_by_email_receipt | Unknown |  |
| created_at | Instant |  |
| culture | Unknown |  |
| currency_code | Unknown |  |
| currency_symbol | Unknown |  |
| default_dimensions_unit | Unknown |  |
| default_tax_id | Unknown |  |
| default_weight_unit | Unknown |  |
| disable_onboarding_tour | Unknown |  |
| domain_prefix | Unknown |  |
| ecwid_onboarding_survey_state | Unknown |  |
| embedded_barcode_option | Unknown |  |
| enabled_integrations | Json |  |
| enabled_platform_apps | Json |  |
| gift_cards_enabled | Unknown |  |
| gift_cards_never_enabled | Unknown |  |
| has_web_register | Unknown |  |
| label_printer_format | Unknown |  |
| lightspeed_unique_id | Unknown |  |
| loyalty_claim_url | Unknown |  |
| loyalty_enabled | Unknown |  |
| loyalty_offer_signup_bonus | Unknown |  |
| loyalty_ratio | Unknown |  |
| loyalty_send_welcome_email | Unknown |  |
| loyalty_signup_bonus | Unknown |  |
| name | Unknown |  |
| no_tax_group_id | Unknown |  |
| on_account_default_limit | Unknown |  |
| register_migration_date | Unknown |  |
| require_password_on_user_switch | Unknown |  |
| restriction_state | Unknown |  |
| restriction_state_reason | Unknown |  |
| sku_sequence_enabled | Unknown |  |
| sku_sequence_value | Unknown |  |
| sso_enabled | Unknown |  |
| store_credit | Unknown |  |
| store_url | Unknown |  |
| subscription_plan_version | Unknown |  |
| subscription_state | Unknown |  |
| subscription_trial_expires_at | Unknown |  |
| tax_exclusive | Unknown |  |
| terms_and_conditions_accepted | Unknown |  |
| terms_and_conditions_effective_date | Unknown |  |
| terms_and_conditions_terms_version | Unknown |  |
| timezone | Json |  |
| version | Unknown |  |

### cosignment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| outlet_id | Unknown | FK |
| source_outlet_id | Unknown | FK |
| supplier_id | Unknown | FK |
| consignment_date | Instant |  |
| created_at | Instant |  |
| deleted_at | Instant |  |
| due_at | Instant |  |
| name | Unknown |  |
| received_at | Instant |  |
| reference | Unknown |  |
| status | Unknown |  |
| supplier_invoice | Unknown |  |
| total_cost_gain | Unknown |  |
| total_cost_loss | Unknown |  |
| total_count_gain | Unknown |  |
| total_count_loss | Unknown |  |
| updated_at | Instant |  |
| version | Unknown |  |

### users_role

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| users_id | Unknown | PK, FK |
| name | Unknown |  |
| system_role_id | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_type | Unknown |  |
| created_at | Instant |  |
| deleted_at | Instant |  |
| display_name | Unknown |  |
| email | Unknown |  |
| email_verified_at | Unknown |  |
| enabled | Unknown |  |
| enabled_mfa | Unknown |  |
| image_original | Unknown |  |
| image_sl | Unknown |  |
| image_sm | Unknown |  |
| image_source | Unknown |  |
| image_ss | Unknown |  |
| image_st | Unknown |  |
| image_standard | Unknown |  |
| image_thumb | Unknown |  |
| is_primary_user | Unknown |  |
| permission | Json |  |
| require_password_change | Unknown |  |
| restricted_outlet_ids | Json |  |
| rules | Json |  |
| seen_at | Instant |  |
| switch_id | Unknown |  |
| target_daily | Unknown |  |
| target_monthly | Unknown |  |
| target_weekly | Unknown |  |
| time_until_deletion | Unknown |  |
| updated_at | Instant |  |
| username | Unknown |  |
| version | Unknown |  |

### tags

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| deleted_at | Instant |  |
| name | Unknown |  |
| version | Unknown |  |

### sale_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| sale_id | Unknown | PK, FK |
| product_id | Unknown | FK |
| cost | Unknown |  |
| discount | Unknown |  |
| discount_total | Unknown |  |
| gift_card_number | Unknown |  |
| is_return | Unknown |  |
| loyalty_value | Unknown |  |
| note | Unknown |  |
| price | Unknown |  |
| price_set | Unknown |  |
| price_total | Unknown |  |
| promotions | Json |  |
| quantity | Unknown |  |
| return_reason | Unknown |  |
| sales_person_id | Unknown |  |
| sequence | Unknown |  |
| status | Unknown |  |
| surcharges | Json |  |
| tax | Unknown |  |
| tax_components | Json |  |
| tax_id | Unknown |  |
| unit_cost | Unknown |  |
| unit_discount | Unknown |  |
| unit_loyalty_value | Unknown |  |
| unit_price | Unknown |  |
| unit_tax | Unknown |  |

### sale_payment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| sale_id | Unknown | PK, FK |
| outlet_id | Unknown | FK |
| amount | Unknown |  |
| deleted_at | Instant |  |
| external_applications | Json |  |
| external_attributes | Json |  |
| name | Unknown |  |
| payment_date | Instant |  |
| register_id | Unknown |  |
| register_open_sequence_id | Unknown |  |
| retailer_payment_type_id | Unknown |  |
| source_id | Unknown |  |
| surcharge | Json |  |

### sale_adjustment

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| sale_id | Unknown | PK, FK |
| adjustment_type | Unknown |  |
| name | Unknown |  |
| tax_components | Json |  |
| value | Unknown |  |

### sale_ecom_custom_charge

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| sale_id | Unknown | PK, FK |
| name | Unknown |  |
| source_id | Unknown |  |
| tax_components | Json |  |
| total | Unknown |  |
| total_incl | Unknown |  |
| total_tax | Unknown |  |

### sale_tax

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| sale_id | Unknown | PK, FK |
| amount | Unknown |  |
| name | Unknown |  |
| rate | Unknown |  |

### sale

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| outlet_id | Unknown | FK |
| user_id | Unknown | FK |
| accounts_transaction_id | Unknown |  |
| attributes | Json |  |
| complete_open_sequence_id | Unknown |  |
| created_at | Instant |  |
| deleted_at | Instant |  |
| ecom_custom_charges_total | Unknown |  |
| ecom_custom_charges_total_incl | Unknown |  |
| ecom_custom_charges_total_tax | Unknown |  |
| external_applications | Json |  |
| has_unsynced_on_account_payments | Unknown |  |
| invoice_number | Unknown |  |
| invoice_sequence | Unknown |  |
| note | Unknown |  |
| receipt_number | Unknown |  |
| register_id | Unknown |  |
| return_for | Unknown |  |
| return_ids | Json |  |
| sale_date | Instant |  |
| short_code | Unknown |  |
| source | Unknown |  |
| source_id | Unknown |  |
| state | Unknown |  |
| status | Unknown |  |
| total_loyalty | Unknown |  |
| total_surcharge | Unknown |  |
| updated_at | Instant |  |
| version | Unknown |  |

### customer_service_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | PK, FK |
| created_at | Instant |  |
| created_by | Unknown |  |
| description | Unknown |  |
| initial_condition | Unknown |  |
| name | Unknown |  |
| serial_number | Unknown |  |
| updated_at | Instant |  |
| updated_by | Unknown |  |

### service_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| service_id | Unknown | PK, FK |
| product_id | Unknown | FK |
| fulfillment_type | Unknown |  |
| gift_card | Unknown |  |
| is_picklist_pickable | Unknown |  |
| note | Unknown |  |
| price_set | Unknown |  |
| promotions | Json |  |
| quantity | Unknown |  |
| register_id | Unknown |  |
| register_sequence_id | Unknown |  |
| sales_person_id | Unknown |  |
| sequence | Unknown |  |
| sku | Unknown |  |
| state | Unknown |  |
| tax_components | Json |  |
| unit_discount | Unknown |  |
| unit_loyalty | Unknown |  |
| unit_price | Unknown |  |

### service

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| retailer_id | Unknown | FK |
| sale_id | Unknown | FK |
| agenda_date | Unknown |  |
| agenda_minutes_scheduled | Unknown |  |
| assigned_user_id | Unknown |  |
| created_at | Instant |  |
| is_sale_level_discount_percentage | Unknown |  |
| notes | Json |  |
| sale_level_discount_value | Unknown |  |
| service_item_created_at | Instant |  |
| service_item_created_by | Unknown |  |
| service_item_detail_description | Unknown |  |
| service_item_detail_serial_number | Unknown |  |
| service_item_id | Unknown |  |
| service_item_initial_condition | Unknown |  |
| service_item_name | Unknown |  |
| service_item_updated_at | Instant |  |
| service_item_updated_by | Unknown |  |
| status | Unknown |  |
| sub_total | Unknown |  |
| total_amount | Unknown |  |
| total_promotion | Unknown |  |
| total_tax | Unknown |  |
| updated_at | Instant |  |
| updated_by | Unknown |  |

### sales_fulfillment_users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| sales_fulfillment_id | Unknown | PK, FK |

### sales_fulfillment_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| sales_fulfillment_id | Unknown | PK, FK |
| product_id | Unknown | FK |
| fulfilled_quantity | Unknown |  |
| packed_quantity | Unknown |  |
| picked_quantity | Unknown |  |
| quantity | Unknown |  |

### sales_fulfillment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| outlet_id | Unknown | FK |
| sale_id | Unknown | FK |
| created_at | Instant |  |
| note | Unknown |  |
| shipping_address_id | Unknown |  |
| state | Unknown |  |
| type | Unknown |  |
| updated_at | Instant |  |
| version | Unknown |  |

### product_category_path

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| product_category_id | Unknown | PK, FK |
| name | Unknown |  |

### product_category

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| leaf_category | Unknown |  |
| name | Unknown |  |
| parent_category_id | Unknown |  |
| payload_id | Unknown |  |
| root_category_id | Unknown |  |

### register

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| outlet_id | Unknown | FK |
| ask_for_note_on_save | Unknown |  |
| ask_for_user_on_sale | Unknown |  |
| button_layout_id | Unknown |  |
| cash_managed_payment_type_id | Unknown |  |
| deleted_at | Instant |  |
| email_receipt | Unknown |  |
| invoice_prefix | Unknown |  |
| invoice_sequence | Unknown |  |
| invoice_suffix | Unknown |  |
| is_ecom | Unknown |  |
| is_open | Unknown |  |
| is_quick_keys_enabled | Unknown |  |
| name | Unknown |  |
| print_note_on_receipt | Unknown |  |
| print_receipt | Unknown |  |
| receipt_template_id | Unknown |  |
| register_close_time | Instant |  |
| register_open_sequence_id | Unknown |  |
| register_open_time | Instant |  |
| show_discounts_on_receipts | Unknown |  |
| version | Unknown |  |

### customer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| balance | Unknown |  |
| company_name | Unknown |  |
| created_at | Instant |  |
| custom_field_1 | Unknown |  |
| custom_field_2 | Unknown |  |
| custom_field_3 | Unknown |  |
| custom_field_4 | Unknown |  |
| customer_code | Unknown |  |
| customer_group_ids | Json |  |
| date_of_birth | Unknown |  |
| deleted_at | Instant |  |
| do_not_email | Unknown |  |
| email | Unknown |  |
| enable_loyalty | Unknown |  |
| fax | Unknown |  |
| first_name | Unknown |  |
| gender | Unknown |  |
| last_name | Unknown |  |
| loyalty_balance | Unknown |  |
| loyalty_email_sent | Unknown |  |
| mobile | Unknown |  |
| note | Unknown |  |
| on_account_limit | Unknown |  |
| phone | Unknown |  |
| physical_address_1 | Unknown |  |
| physical_address_2 | Unknown |  |
| physical_city | Unknown |  |
| physical_country_id | Unknown |  |
| physical_postcode | Unknown |  |
| physical_state | Unknown |  |
| physical_suburb | Unknown |  |
| postal_address_1 | Unknown |  |
| postal_address_2 | Unknown |  |
| postal_city | Unknown |  |
| postal_country_id | Unknown |  |
| postal_postcode | Unknown |  |
| postal_state | Unknown |  |
| postal_suburb | Unknown |  |
| source_unique_id | Unknown |  |
| tax_id | Unknown |  |
| time_until_deletion | Unknown |  |
| twitter | Unknown |  |
| updated_at | Instant |  |
| version | Unknown |  |
| website | Unknown |  |
| year_to_date | Unknown |  |

## Relationships

- inventory(product_id) → product(id)
- inventory(outlet_id) → outlet(id)
- product_tag(id) → tags(id)
- product_tag(product_id) → product(id)
- product_category_tag(id) → tags(id)
- product_category_tag(product_id) → product(id)
- product_variant_option(product_id) → product(id)
- product_supplier(supplier_id) → supplier(id)
- product_supplier(product_id) → product(id)
- product_code(product_id) → product(id)
- product(supplier_id) → supplier(id)
- product(brand_id) → brand(id)
- product(product_category_id) → product_category(id)
- retailer(discount_product_id) → product(id)
- cosignment(source_outlet_id) → outlet(id)
- cosignment(supplier_id) → supplier(id)
- cosignment(outlet_id) → outlet(id)
- users_role(users_id) → users(id)
- sale_line_item(product_id) → product(id)
- sale_line_item(sale_id) → sale(id)
- sale_payment(outlet_id) → outlet(id)
- sale_payment(sale_id) → sale(id)
- sale_adjustment(sale_id) → sale(id)
- sale_ecom_custom_charge(sale_id) → sale(id)
- sale_tax(sale_id) → sale(id)
- sale(user_id) → users(id)
- sale(customer_id) → customer(id)
- sale(outlet_id) → outlet(id)
- customer_service_item(customer_id) → customer(id)
- service_line_item(product_id) → product(id)
- service_line_item(service_id) → service(id)
- service(retailer_id) → retailer(id)
- service(sale_id) → sale(id)
- sales_fulfillment_users(id) → users(id)
- sales_fulfillment_users(sales_fulfillment_id) → sales_fulfillment(id)
- sales_fulfillment_line_item(product_id) → product(id)
- sales_fulfillment_line_item(sales_fulfillment_id) → sales_fulfillment(id)
- sales_fulfillment(sale_id) → sale(id)
- sales_fulfillment(outlet_id) → outlet(id)
- product_category_path(product_category_id) → product_category(id)
- register(outlet_id) → outlet(id)