hellodb.io
MODELS · 14
/
20 refs · 101 fields
user
8
PK
id
uuid
email
varchar
full_name
varchar
phone
varchar?
profile_photo_url
text?
is_identity_verified
boolean
created_at
timestamp
deleted_at
timestamp?
host_profile
8
PK
id
uuid
FK
user_id
uuid
about
text?
is_superhost
boolean
response_rate
decimal
payout_currency
varchar
verified_at
timestamp?
created_at
timestamp
guest
6
PK
id
uuid
FK
booking_id
uuid
FK
user_id
uuid?
full_name
varchar
age_group
enum
is_primary
boolean
listing
10
PK
id
uuid
FK
host_id
uuid
title
varchar
property_type
enum
city
varchar
country_code
varchar
max_guests
int
base_nightly_price
decimal
status
enum
created_at
timestamp
listing_photo
6
PK
id
uuid
FK
listing_id
uuid
url
text
caption
varchar?
sort_order
int
created_at
timestamp
amenity
5
PK
id
uuid
name
varchar
category
enum
icon
varchar?
is_filterable
boolean
listing_amenity
5
PK
id
uuid
FK
listing_id
uuid
FK
amenity_id
uuid
note
varchar?
created_at
timestamp
availability_calendar
7
PK
id
uuid
FK
listing_id
uuid
stay_date
date
is_available
boolean
price_override
decimal?
min_nights
int
blocked_reason
enum?
pricing_rule
8
PK
id
uuid
FK
listing_id
uuid
rule_type
enum
amount
decimal
is_percentage
boolean
starts_on
date?
ends_on
date?
created_at
timestamp
booking
10
PK
id
uuid
FK
listing_id
uuid
FK
guest_user_id
uuid
check_in
date
check_out
date
guest_count
int
total_amount
decimal
status
enum
cancelled_at
timestamp?
created_at
timestamp
payout
8
PK
id
uuid
FK
booking_id
uuid
FK
host_id
uuid
amount
decimal
currency
varchar
status
enum
scheduled_for
date
paid_at
timestamp?
review
10
PK
id
uuid
FK
booking_id
uuid
FK
author_user_id
uuid
FK
listing_id
uuid?
FK
subject_user_id
uuid?
review_type
enum
rating
int
body
text
is_published
boolean
created_at
timestamp
wishlist
5
PK
id
uuid
FK
user_id
uuid
name
varchar
is_private
boolean
created_at
timestamp
wishlist_item
5
PK
id
uuid
FK
wishlist_id
uuid
FK
listing_id
uuid
note
varchar?
added_at
timestamp
110%
Opening Airbnb