# Sharetribe schema ERD

Table and field reference for the Fivetran Sharetribe connector.

## Table & Field Reference

### transaction_line_item_include

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| transaction_id | Unknown | PK, FK |
| transaction_line_item_index | Unknown | PK, FK |
| value | Unknown |  |

### transaction_line_item

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| transaction_id | Unknown | PK, FK |
| code | Unknown |  |
| line_total_amount | Unknown |  |
| line_total_currency | Unknown |  |
| quantity | Unknown |  |
| reversal | Unknown |  |
| seat | Unknown |  |
| unit | Unknown |  |
| unit_price_amount | Unknown |  |
| unit_price_currency | Unknown |  |

### transaction_transition

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| transaction_id | Unknown | PK, FK |
| by | Unknown |  |
| created_at | Unknown |  |
| transition | Unknown |  |

### transaction_message

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

### transaction_review

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

### transaction

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| relationships_booking_id | Unknown | FK |
| relationships_customer_id | Unknown | FK |
| relationships_listing_id | Unknown | FK |
| relationships_marketplace_id | Unknown | FK |
| relationships_provider_id | Unknown | FK |
| relationships_stock_reservation_id | Unknown | FK |
| attributes_created_at | Unknown |  |
| attributes_last_transition | Unknown |  |
| attributes_last_transitioned_at | Unknown |  |
| attributes_meta_data | Json |  |
| attributes_payin_total_amount | Unknown |  |
| attributes_payin_total_currency | Unknown |  |
| attributes_payout_total_amount | Unknown |  |
| attributes_payout_total_currency | Unknown |  |
| attributes_process_name | Unknown |  |
| attributes_process_version | Unknown |  |
| attributes_protected_data | Json |  |

### booking

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| attributes_display_end | Unknown |  |
| attributes_display_start | Unknown |  |
| attributes_end | Unknown |  |
| attributes_seat | Unknown |  |
| attributes_start | Unknown |  |
| attributes_state | Unknown |  |

### message

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| attributes_content | Unknown |  |
| attributes_created_at | Unknown |  |

### review

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| attributes_content | Unknown |  |
| attributes_created_at | Unknown |  |
| attributes_deleted | Unknown |  |
| attributes_rating | Unknown |  |
| attributes_state | Unknown |  |
| attributes_type | Unknown |  |

### stock_reservation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| quantity | Unknown |  |
| state | Unknown |  |

### marketplace

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| description | Unknown |  |
| name | Unknown |  |

### user_identity_provider

| Column | Type | Keys |
| --- | --- | --- |
| idp_id | Unknown | PK |
| users_id | Unknown | PK, FK |
| user_identity | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| marketplace_id | Unknown | FK |
| attributes_banned | Unknown |  |
| attributes_created_at | Unknown |  |
| attributes_deleted | Unknown |  |
| attributes_email | Unknown |  |
| attributes_email_verified | Unknown |  |
| attributes_pending_email | Unknown |  |
| attributes_stripe_connected | Unknown |  |
| profile_abbreviated_name | Unknown |  |
| profile_bio | Unknown |  |
| profile_display_name | Unknown |  |
| profile_first_name | Unknown |  |
| profile_last_name | Unknown |  |
| profile_private_data | Json |  |
| profile_profile_commission_rate | Unknown |  |
| profile_protected_data | Json |  |
| profile_public_data | Json |  |
| relationships_marketplace_id | Unknown |  |
| relationships_stripe_account_id | Unknown |  |
| relationships_stripe_id | Unknown |  |

### event

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| marketplace_id | Unknown | FK |
| attributes_created_at | Unknown |  |
| attributes_event_type | Unknown |  |
| attributes_marketplace_id | Unknown |  |
| attributes_previous_value | Json |  |
| attributes_resource | Json |  |
| attributes_resource_id | Unknown |  |
| attributes_resource_type | Unknown |  |
| attributes_sequence_id | Unknown |  |
| attributes_source | Unknown |  |
| audit_data_admin_id | Unknown |  |
| audit_data_client_id | Unknown |  |
| audit_data_request_id | Unknown |  |
| audit_data_user_id | Unknown |  |

### listing_availability_plan

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| listing_id | Unknown | PK, FK |
| day_of_week | Unknown |  |
| end_time | Unknown |  |
| seat | Unknown |  |
| start_time | Unknown |  |

### listing

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| marketplace_id | Unknown | FK |
| availability_plan_type | Unknown |  |
| created_at | Unknown |  |
| deleted | Unknown |  |
| description | Unknown |  |
| geolocation_lat | Unknown |  |
| geolocation_lng | Unknown |  |
| meta_data | Json |  |
| pivate_data | Json |  |
| price_amount | Unknown |  |
| price_currency | Unknown |  |
| public_data | Json |  |
| relationships_author_id | Unknown |  |
| relationships_marketplace_id | Unknown |  |
| relationships_stock_id | Unknown |  |
| relationships_stock_quantity | Unknown |  |
| state | Unknown |  |
| title | Unknown |  |

### availability_exception

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| listing_id | Unknown | FK |
| ends | Unknown |  |
| seat | Unknown |  |
| start | Unknown |  |

## Relationships

- transaction_line_item_include(transaction_line_item_index) → transaction_line_item(index)
- transaction_line_item_include(transaction_id) → transaction_line_item(transaction_id)
- transaction_line_item(transaction_id) → transaction(id)
- transaction_transition(transaction_id) → transaction(id)
- transaction_message(id) → message(id)
- transaction_message(transaction_id) → transaction(id)
- transaction_review(id) → review(id)
- transaction_review(transaction_id) → transaction(id)
- transaction(relationships_provider_id) → users(id)
- transaction(relationships_customer_id) → users(id)
- transaction(relationships_listing_id) → listing(id)
- transaction(relationships_marketplace_id) → marketplace(id)
- transaction(relationships_booking_id) → booking(id)
- transaction(relationships_stock_reservation_id) → stock_reservation(id)
- user_identity_provider(users_id) → users(id)
- users(marketplace_id) → marketplace(id)
- event(marketplace_id) → marketplace(id)
- listing_availability_plan(listing_id) → listing(id)
- listing(marketplace_id) → marketplace(id)
- availability_exception(listing_id) → listing(id)