Claimlane schema

27 tables

About the connector Start free

27 tables

Joins between these tables aren't mapped yet.

Loading diagram…

b2b_ticket

b2c_ticket

supplier

b2b_ticket

23

id

string

brand_id

string

brand_name

string

claim_type

string

rma_number

string

retailer_reference

string

external_reference

string

supplier_integration_complete

boolean

is_archived_supplier

boolean

b2b_ticket_product

8

ticket_id

string

index

int

quantity

double

status

string

ean

string

serial_number

string

invoice_number

string

_weld_synced

date

b2b_ticket_product_id

5

ticket_id

string

product_index

int

index

int

product_id

string

_weld_synced

date

b2b_ticket_product_tag

5

ticket_id

string

product_index

int

index

int

tag

string

_weld_synced

date

b2b_ticket_product_identification

6

ticket_id

string

product_index

int

index

int

property

string

value

string

_weld_synced

date

b2b_ticket_product_brand_tag

6

ticket_id

string

product_index

int

index

int

category

string

value

string

_weld_synced

date

b2b_ticket_product_internal_supplier_status

6

ticket_id

string

product_index

int

index

int

status_name

string

status_option

string

_weld_synced

date

b2b_ticket_product_data_source_tag

10

ticket_id

string

product_index

int

index

int

tag_id

string

tag_name

string

tag_technical_label

string

option_id

string

option_name

string

option_technical_label

string

_weld_synced

date

b2c_ticket

51

ticket_id

string

organization_id

string

is_archived

boolean

rma_number

string

ticket_type

string

channel_type

string

consumer_ticket_submit_id

string

created_at

date

b2c_ticket_product

21

id

string

ticket_id

string

index

int

product_id

string

variant_id

string

line_item_id

string

product_name

string

product_sku

string

ean

string

b2c_ticket_product_property

7

ticket_id

string

product_index

int

index

int

property

string

property_name

string

value

string

_weld_synced

date

b2c_ticket_product_refund

7

ticket_id

string

product_index

int

index

int

refunded_quantity

double

refunded_amount

double

shipping_cost

double

_weld_synced

date

b2c_ticket_product_part

9

ticket_id

string

product_index

int

index

int

item_number

string

sku

string

ean

string

parent_ean

string

quantity

double

_weld_synced

date

b2c_ticket_product_data_source_tag

10

ticket_id

string

product_index

int

index

int

tag_id

string

tag_name

string

tag_technical_label

string

option_id

string

option_name

string

option_technical_label

string

_weld_synced

date

b2c_ticket_shipping_line

7

ticket_id

string

index

int

price

double

currency

string

tracking_number

string

carrier_name

string

_weld_synced

date

b2c_ticket_package_number

4

ticket_id

string

index

int

package_number

string

_weld_synced

date

b2c_ticket_data_source_tag

9

ticket_id

string

index

int

tag_id

string

tag_name

string

tag_technical_label

string

option_id

string

option_name

string

option_technical_label

string

_weld_synced

date

raw_b2b_product_data

4

organization_id

string

organization_type

string

row_hash

string

_weld_synced

date

raw_b2b_workload_data

4

organization_id

string

organization_type

string

row_hash

string

_weld_synced

date

raw_b2c_agent_data

4

organization_id

string

organization_type

string

row_hash

string

_weld_synced

date

raw_b2c_product_data

4

organization_id

string

organization_type

string

row_hash

string

_weld_synced

date

raw_b2c_product_part_data

4

organization_id

string

organization_type

string

row_hash

string

_weld_synced

date

raw_b2c_workload_data

4

organization_id

string

organization_type

string

row_hash

string

_weld_synced

date

retailer

10

id

string

name

string

department

string

vat_number

string

deleted

boolean

legal_address_address

string

legal_address_city

string

legal_address_country

string

legal_address_postal_code

string

_weld_synced

date

supplier

10

id

string

name

string

department

string

vat_number

string

deleted

boolean

legal_address_address

string

legal_address_city

string

legal_address_country

string

legal_address_postal_code

string

_weld_synced

date

supplier_brand

7

id

string

supplier_id

string

index

int

name

string

category

string

data_source_id

string

_weld_synced

date

supplier_brand_product_identification

5

supplier_id

string

brand_id

string

index

int

property

string

_weld_synced

date