Data Model
Entity Relationship Diagram — click any entity to highlight its relationships
PK Primary KeyFK Foreign KeyTouring CoreSales & SnapshotsVenue ManagementAvailability & RoutingTicketing IngestionMoshtix IntegrationOztix IntegrationTicketek IntegrationFlicket AU IntegrationFlicket NZ IntegrationAXS IntegrationMedia CoverageConfig & Reporting
Touring Core
Tour
PKid
tour_name
artist_name
status
breakeven_tickets
total_expenditure
artist_guarantee
promoter_split_pct
default_average_sale_price
share_token
share_slug
deal_type
per_ticket_fee
co_promoter_name
co_promoter_split_pct
report_time_cutoff
last_report_generated_at
notes
Show
PKid
FKtour_id→ Tour
city
venue_name
show_date
venue_capacity
holds
ticketing_outlet
outlet_show_identifier
status
forecast_sales_total
pre_registrations
average_sale_price
Sales & Snapshots
ShowSalesSource
PKid
FKshow_id→ Show
source_type
source_record_id
is_active
linked_at
linked_by
excluded_tiers
notes
SalesSnapshot
PKid
FKshow_id→ Show
snapshot_at
total_sold
total_revenue_ex_gst_fees
ticket_tiers (JSON)
FKraw_source_file_id→ IngestedFile
notes
Venue Management
Venue
PKid
venue_name
city
state
country
capacity
holds
ticketing_outlet
has_multiple_modes
booker_email
drive_link
maps_url
notes
VenueMode
PKid
FKvenue_id→ Venue
mode_name
mode_type
total_capacity
sellable_capacity
default_holds
is_default
notes
VenueModeTier
PKid
FKvenue_mode_id→ VenueMode
tier_name
ticket_type
quantity_available
notes
Availability & Routing
AvailBatch
PKid
FKvenue_id→ Venue
venue_name (denorm)
room
city
state
country
capacity
booker_email
batch_name
date_range_start
date_range_end
date_received
source_type
status
notes
file_link
AvailDate
PKid
FKbatch_id→ AvailBatch
FKvenue_id (denorm)→ Venue
date
day_of_week
clean_status
pencil_count
original_wording
notes
RoutingShortlist
PKid
name
artist_name
rows (JSON of AvailDate refs)
share_token
created_by_name
notes
Ticketing Ingestion
IngestedFile
PKid
FKtour_id→ Tour
received_at
source
ticketing_outlet
filename
checksum_hash
parsed_ok
parse_errors
stored_file_url
rows_processed
rows_matched
UnmatchedRow
PKid
FKingested_file_id→ IngestedFile
FKtour_id→ Tour
raw_data (JSON)
parsed_event_name
parsed_venue
parsed_date
parsed_quantity
parsed_revenue
suggested_show_id
resolved
FKresolved_show_id→ Show
Moshtix Integration
MoshtixSummary
PKid
sync_key
FKevent_id → outlet_show_identifier→ Show
event_name
venue
start_date
event_status
initial_allocation
tickets_pending
tickets_issued
remain_allocation
net_sales
net_sales_clean
net_sales_ex_gst
extract_time
source_s3_key
MoshtixDetailedSummary
PKid
sync_key
FKevent_id → outlet_show_identifier→ Show
event_name
venue
start_date
ticket_type
allocation_group
ticket_price
initial_allocation
tickets_sold_today
tickets_pending
tickets_issued
remain_allocation
net_sales
net_sales_clean
net_sales_ex_gst
value_tickets
comp_tickets
refunded
returned
resold_priv
change_name_dob
package
claimed
collector
extract_time
source_s3_key
MoshtixEventHistory
PKid
sync_key
FKevent_id → outlet_show_identifier→ Show
event_name
venue
start_date
Oztix Integration
OztixEventSummary
PKid
sync_key
source_file
extract_datetime
FKevent_key → outlet_show_identifier→ Show
event_name
event_date
start_time
venue
event (full desc)
allocation_capacity
sold_24hr
sold
remaining
total_sales
total_sales_ex_gst
event_parse_success
OztixAllocationBreakdown
PKid
sync_key
source_file
extract_datetime
FKevent_key → outlet_show_identifier→ Show
event (full desc)
event_name
event_date
start_time
venue
event_parse_success
allocation_group
allocation_name
ticket_price
ticket_price_ex_gst
sold_24hr
sold
total_sales
total_sales_ex_gst
OztixEventLink
PKid
FKshow_id→ Show
event_key
linked_at
linked_by
notes
Ticketek Integration
TicketekEventSummary
PKid
sync_key
sales_date
FKproductId → outlet_show_identifier→ Show
productShow
productWho
productWhere
productWhen
daily_tickets_sold
daily_total_sales
daily_total_sales_ex_gst
tickets_sold
total_sales
total_sales_ex_gst
transactions
last_transaction_nsw
TicketekDetailedSummary
PKid
sync_key
sales_date
FKproductId → outlet_show_identifier→ Show
productShow
productWho
productWhere
productWhen
priceCategoryName
priceTypeName
daily_tickets_sold
daily_total_sales
daily_total_sales_ex_gst
tickets_sold
total_sales
total_sales_ex_gst
transactions
last_transaction_nsw
Flicket AU Integration
FlicketAusEventSummary
PKid
sync_key
sales_date
FKevent_id → outlet_show_identifier→ Show
event_name
event_start_time
daily_tickets_sold
daily_total_sales
daily_total_sales_ex_gst
transactions
tickets_sold
total_sales
total_sales_ex_gst
last_transaction_nsw
FlicketAusDetailedSummary
PKid
sync_key
sales_date
FKevent_id → outlet_show_identifier→ Show
event_name
event_start_time
line_item_name
daily_tickets_sold
daily_total_sales
daily_total_sales_ex_gst
tickets_sold
total_sales
total_sales_ex_gst
last_transaction_nsw
Flicket NZ Integration
FlicketNzEventSummary
PKid
sync_key
sales_date
FKevent_id → outlet_show_identifier→ Show
event_name
event_start_time
event_venue
daily_tickets_sold
daily_total_sales
daily_total_sales_ex_gst
transactions
tickets_sold
total_sales
total_sales_ex_gst
last_transaction_nsw
FlicketNzDetailedSummary
PKid
sync_key
sales_date
FKevent_id → outlet_show_identifier→ Show
event_name
event_start_time
line_item_name
daily_tickets_sold
daily_total_sales
daily_total_sales_ex_gst
tickets_sold
total_sales
total_sales_ex_gst
last_transaction_nsw
AXS Integration
AxsEventSummary
PKid
sync_key
source_file
extract_datetime
FKevent_id → outlet_show_identifier→ Show
event_name
venue
event_start_date
tickets_sold
sold_24hr
total_sales
total_sales_ex_gst
AxsAllocationBreakdown
PKid
sync_key
source_file
extract_datetime
FKevent_id → outlet_show_identifier→ Show
event_name
venue
event_start_date
pricing_mode
price_code
ticket_price
zone
zone_tickets
sold_24hr
tickets_sold
total_sales
total_sales_ex_gst
Media Coverage
MediaWin
PKid
FKtour_id→ Tour
title
outlet
url
type
date_published
favicon_url
image_url
notes
Config & Reporting
TourManagerEntry
PKid
section
task_name
owner
status
date
announce_date
pre_sale_date
on_sale_date
tour_period_start
tour_period_end
files_url
offer_link
subtasks (JSON)
notes_log (JSON)
sort_order
notes
EmailContact
PKid
name
emails (array)
is_group
EmailReport
PKid
FKtour_id→ Tour
report_name
report_type
recipients (array)
subject
schedule
enabled
ReportSettings
PKid
recipients (array)
FieldMapping
PKid
ticketing_outlet
mapping_name
quantity_sold_column
event_name_column
event_date_column
venue_column
city_column
revenue_column
ticket_type_column
event_id_column
date_format
active
notes