hellodb.io
MODELS · 18
/
32 refs · 150 fields
venue
9
PK
id
uuid
name
varchar
slug
varchar
address_line
varchar
city
varchar
country_code
varchar
timezone
varchar
is_active
boolean
created_at
timestamp
hall
7
PK
id
uuid
FK
venue_id
uuid
name
varchar
capacity
int
hall_type
enum
is_active
boolean
created_at
timestamp
seat_map
8
PK
id
uuid
FK
hall_id
uuid
version
int
name
varchar
row_count
int
column_count
int
is_current
boolean
created_at
timestamp
seat_section
6
PK
id
uuid
FK
seat_map_id
uuid
name
varchar
code
varchar
display_order
int
seat_count
int
seat
9
PK
id
uuid
FK
seat_map_id
uuid
FK
seat_section_id
uuid
row_label
varchar
seat_number
varchar
seat_kind
enum
grid_x
int
grid_y
int
is_active
boolean
event
9
PK
id
uuid
FK
venue_id
uuid
title
varchar
slug
varchar
category
enum
status
enum
duration_minutes
int
age_rating
varchar
created_at
timestamp
event_showtime
9
PK
id
uuid
FK
event_id
uuid
FK
hall_id
uuid
FK
seat_map_id
uuid
starts_at
timestamp
ends_at
timestamp
sales_open_at
timestamp
status
enum
created_at
timestamp
pricing_tier
9
PK
id
uuid
FK
event_showtime_id
uuid
FK
seat_section_id
uuid
name
varchar
base_price
decimal
booking_fee
decimal
tax_rate
decimal
currency_code
varchar
is_active
boolean
seat_inventory
8
PK
id
uuid
FK
event_showtime_id
uuid
FK
seat_id
uuid
FK
pricing_tier_id
uuid
status
enum
lock_version
int
held_until
timestamp?
updated_at
timestamp
seat_hold
7
PK
id
uuid
FK
event_showtime_id
uuid
FK
customer_id
uuid?
session_token
varchar
status
enum
expires_at
timestamp
created_at
timestamp
seat_hold_item
5
PK
id
uuid
FK
seat_hold_id
uuid
FK
seat_inventory_id
uuid
quoted_price
decimal
created_at
timestamp
customer
9
PK
id
uuid
email
varchar
phone
varchar
full_name
varchar
FK
referred_by_id
uuid?
loyalty_points
int
status
enum
created_at
timestamp
deleted_at
timestamp?
discount
10
PK
id
uuid
FK
event_id
uuid?
code
varchar
discount_type
enum
amount
decimal
max_redemptions
int
redemption_count
int
valid_from
timestamp
valid_until
timestamp
is_active
boolean
booking
10
PK
id
uuid
FK
customer_id
uuid
FK
event_showtime_id
uuid
FK
seat_hold_id
uuid?
FK
discount_id
uuid?
reference
varchar
status
enum
total_amount
decimal
currency_code
varchar
created_at
timestamp
booking_seat
8
PK
id
uuid
FK
booking_id
uuid
FK
seat_inventory_id
uuid
FK
pricing_tier_id
uuid
unit_price
decimal
fee_amount
decimal
tax_amount
decimal
created_at
timestamp
ticket
8
PK
id
uuid
FK
booking_seat_id
uuid
serial
varchar
barcode
varchar
qr_payload
text
status
enum
checked_in_at
timestamp?
issued_at
timestamp
payment
10
PK
id
uuid
FK
booking_id
uuid
FK
customer_id
uuid
provider
enum
provider_reference
varchar
status
enum
amount
decimal
currency_code
varchar
captured_at
timestamp?
created_at
timestamp
refund
9
PK
id
uuid
FK
payment_id
uuid
FK
booking_id
uuid
reason
enum
status
enum
amount
decimal
currency_code
varchar
processed_at
timestamp?
created_at
timestamp
71%
Opening Ticket Booking