Sharetribe
Explore the interactive ERD
Table & Field Reference
transaction_line_item_include
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
transaction_id | Unknown | PKFK |
transaction_line_item_index | Unknown | PKFK |
value | Unknown |
transaction_line_item
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
transaction_id | Unknown | PKFK |
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 | PKFK |
by | Unknown | |
created_at | Unknown | |
transition | Unknown |
transaction_message
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
transaction_id | Unknown | PKFK |
transaction_review
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
transaction_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
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 |