SevenRooms schema

10 tables · 11 joins

About the connector Start free

10 tables

Loading diagram…

client

charge

29

id

string

venue_id

string

venue_group_client_id

string

entity_id

string

entity_date

date

charged

date

transaction_id

string

last_4

string

brand

string

status

string

client

76

id

string

reference_code

string

venue_group_id

string

external_user_id

string

first_name

string

last_name

string

external_client_notes

string

title

string

company

string

client_venue_stats

26

client_id

string

venue_id

string

booked_by_names

string

total_visits

int

total_noshows

int

total_cancellations

int

total_spend

double

gross_total

double

total_spend_local

double

total_covers

int

event

36

id

string

venue_id

string

name

string

description

string

booking_policy_id

string

booking_policy

string

cancellation_policy_id

string

cancellation_policy

string

custom_booking_policy

string

custom_cancellation_policy

string

payout_profile

5

venue_id

string

account_id

string

payment_system

string

sevenrooms_public_key

string

_weld_synced

date

program

15

id

string

venue_id

string

date

date

note

string

title

string

description

string

shift_categories_display

string

price_point

string

spend_policy

string

child_policy

string

reservation

98

id

string

venue_id

string

client_id

string

venue_group_id

string

venue_group_client_id

string

source_client_id

string

external_user_id

string

external_id

string

external_reference_code

string

external_client_id

string

first_name

string

reservation_feedback

15

reservation_id

string

venue_id

string

created_date

date

food

string

drinks

string

overall

string

feedback_type

string

service

string

notes

string

order_id

string

reservation_request

32

id

string

venue_id

string

reservation_id

string

arrival_time

string

booked_by

string

cost_option

int

created

date

date

date

deleted

date

email

string

end_time

string

venue

64

id

string

phone_number

string

neighborhood

string

venue_class

string

municipality

string

venue_group_name

string

postal_code

string

external_venue_id

string

unique_confirmation_prefix

string