Guides

Data model

teams name roles label status default_on_gig team_id → teams ensemble_roles name order ensemble_id → ensembles role_id → roles ensembles label status product_ensembles order product_id → products ensemble_id → ensembles products label status category slug names_a_performer entertainment_product_id → products prices label lookup_key billing_scheme unit_amount status product_id → products ensemble_id → ensembles coupons label percent_off amount_off level status product_equipment quantity order product_id → products equipment_type_id → equipment_types moments label default_on_product order product_id → products songs title artist status producer_id → staff_members gig_statuses label category gig_types label venues name city load_in_notes gigs label gig_date start_time guest_count contract_number currency gig_status_id → gig_statuses gig_type_id → gig_types venue_id → venues gig_contracts label kind status number signed_at gig_id → gigs attachment_id → attachments gig_products label status start_time end_time quantity unit_amount display gig_id → gigs ensemble_id → ensembles product_id → products price_id → prices gig_contract_id → gig_contracts gig_role_id → gig_roles parent_gig_product_id → gig_products gig_discounts label percent_off amount_off order gig_id → gigs gig_product_id → gig_products gig_contract_id → gig_contracts coupon_id → coupons gig_payments label percent_of_total amount due_at paid_at gig_id → gigs gig_contract_id → gig_contracts gig_moments label time order gig_product_id → gig_products moment_id → moments gig_songs title list performance set order gig_product_id → gig_products song_id → songs gig_moment_id → gig_moments singer_id → staff_members gig_equipment label quantity loaded_at returned_at gig_id → gigs gig_product_id → gig_products equipment_type_id → equipment_types equipment_id → equipment staff_member_id → staff_members gig_roles label call_time computed_total_amount role_id → roles gig_id → gigs staff_member_id → staff_members gig_product_id → gig_products rate_id → rates latest_invitation_id → gig_role_invitations gig_role_invitations invitation_number invited_at response gig_role_id → gig_roles staff_member_id → staff_members gig_contacts roles gig_id → gigs contact_id → contacts staff_members full_name status email base_pay staff_member_roles status call_order role_id → roles staff_member_id → staff_members staff_member_blockouts start_date end_date reason staff_member_id → staff_members rates label amount status staff_member_id → staff_members product_id → products staff_member_product_rates standalone_amount addon_amount saturday_modifier staff_member_id → staff_members product_id → products contacts full_name email phone equipment_types label category tracking quantity_owned equipment label identifier ownership status equipment_type_id → equipment_types equipment_issues label kind resolved_at equipment_id → equipment gig_id → gigs custom_fields label entity key field_type attachments label entity record_id url many → one (the foot sits on the table holding the foreign key) gigs — the table everything hangs off
Previous
Gigs, products, ensembles
Next
Authentication
A Wedding Operating Systems, LLC product hireorpheus.com