Supabase Segmented Contact ArchitectureLocal / Reference Schema Mode

iHunt Master Contact Sheet

Every contact across iHunt is automatically routed into its dedicated Supabase table based on where it came from—and organized below into 9 spreadsheet tabs that you can browse, filter, or export to Excel / Google Sheets.

All Contacts (Master Rollup)Table: public.contactsSQL View: public.ihunt_sheet_all_contacts

Unified master rollup of every contact across all 8 origin locations, tagged with its Sheet Tab and dedicated Supabase source table.

#Sheet TabSupabase TableContact NameEmail AddressPhone NumberContact CategoryBusiness / Order / SubjectStateSpecies / FocusStatusDate Recorded
12. Outfitterspublic.outfitter_submissionsColt Vancecolt@bitterrootbackcountry.com(406) 555-0184Outfitter Featured ListingBitterroot Backcountry OutfittersMontanaElk, Mule Deer, Black Bear, Mountain GoatfeaturedOct 17, 2026
22. Outfitterspublic.outfitter_submissionsGarrett Thornegarrett@sanjuanhighcountry.com(970) 555-0149Outfitter Featured ListingSan Juan High Country GuidesColoradoRocky Mountain Elk, Mule Deer, Bighorn SheepapprovedOct 16, 2026
32. Outfitterspublic.outfitter_submissionsBoone McAllisterboone@cacherivertimber.com(870) 555-0192Outfitter Featured ListingCache River Timber Duck Club & GuidesArkansasMallard, Pintail, Specklebelly Geese, Wood DuckfeaturedOct 15, 2026
43. Taxidermistspublic.taxidermy_submissionsWyatt Callahanwyatt@timberlinetaxidermy.com(217) 555-0133Taxidermy Studio ListingTimberline Master Taxidermy StudioIllinoisWhitetail Deer, Life-Size Predators, Custom Barnwood PedestalsfeaturedOct 17, 2026
53. Taxidermistspublic.taxidermy_submissionsCaleb Lindstromcaleb@highcountrywildlifeart.com(970) 555-0177Taxidermy Studio ListingHigh-Country Wildlife ArtistryColoradoRocky Mountain Elk, Mule Deer, Bighorn Sheep, Mountain GoatapprovedOct 16, 2026
64. Hunt Clubspublic.hunt_club_submissionslogan.hendricks@sangamonclub.orglogan.hendricks@sangamonclub.org(217) 555-0161Private Hunt Club ListingSangamon Valley Trophy QDMA SyndicateIllinoisTrophy Whitetail Deer, Eastern Wild Turkey, MallardfeaturedOct 17, 2026
74. Hunt Clubspublic.hunt_club_submissionsDavis Montgomerydavis@blackbeltlease.com(334) 555-0128Private Hunt Club ListingBlack Belt Plantation & River LeaseAlabamaWhitetail Deer, Bobwhite Quail, Eastern Wild Turkey, Wild HogapprovedOct 15, 2026
85. Hunter Purchasespublic.hunter_purchasesMarcus Sterlingm.sterling@fieldmail.com(303) 555-0198Purchase: Guided Hunt DepositIH-849201 — 2027 1st Rifle Bull Elk 5-Day Expedition (50% Booking Deposit) ($3,750)ColoradoRocky Mountain Elkdeposit_heldOct 17, 2026
95. Hunter Purchasespublic.hunter_purchasesTanner Brookstbrooks88@outdoors.org(615) 555-0142Purchase: Gear & EquipmentIH-849144 — Swarovski NL Pure 10x42 Binocular + Alaskan Guide Bino Harness Bundle ($3,299)WyomingMule Deer, PronghornfulfilledOct 16, 2026
105. Hunter Purchasespublic.hunter_purchasesDustin & Reid Millerdmiller@heartlandag.com(515) 555-0115Purchase: Club MembershipIH-849089 — 2026/2027 Annual Equity Slot Deposit — Sangamon Valley QDMA Syndicate ($4,850)IllinoisWhitetail DeerpaidOct 16, 2026
115. Hunter Purchasespublic.hunter_purchasesEvan Kowalskiekowalski@gmail.com(406) 555-0166Purchase: Digital State AtlasIH-849012 — Western Big Game Draw Odds & GMU Public Land Waypoint Bundle (CO, WY, MT, ID) ($79)MontanaElk, Mule DeerpaidOct 15, 2026
126. Hunter Inquiriespublic.hunter_inquiriesHarrison Fordehforde@lonestarcapital.com(214) 555-0181Outfitter Expedition InquiryBitterroot Backcountry OutfittersMontanaRocky Mountain Elkrouted_to_partnerOct 17, 2026
136. Hunter Inquiriespublic.hunter_inquiriesCody Reynoldscreynolds@midwestfarms.net(309) 555-0154Taxidermy Quote RequestTimberline Master Taxidermy StudioIllinoisWhitetail DeerquotedOct 16, 2026
146. Hunter Inquiriespublic.hunter_inquiriesBlake Thorntonbthornton@atlantabuilders.com(404) 555-0122Hunt Club WaitlistBlack Belt Plantation & River LeaseAlabamaWhitetail Deer, Eastern Wild TurkeynewOct 15, 2026
157. Advertiserspublic.media_kit_requestsclaire.bennett@vortexrange.comclaire.bennett@vortexrange.com(608) 555-0190Sponsor / Media KitVortex Range & Optics ($5,000 - $10,000 / mo)NationwideState Regulation Atlas Sponsorship + Gear Lab Buyer GuidescontactedOct 17, 2026
167. Advertiserspublic.media_kit_requestsRyan Halversonr.halverson@mountainapparel.com(707) 555-0139Sponsor / Media KitKUIU Ultralight Mountain Gear ($10,000+ / mo)Nationwide50-State Big Game Hub Native Placement + Weekly Dispatch BannerreviewedOct 14, 2026
178. Subscriberspublic.newsletter_subscribersLuke Hendersonluke.henderson@outdoorlife.net—State Regulation AlertState Alerts: coloradocoloradoAll GameactiveOct 17, 2026
188. Subscriberspublic.newsletter_subscribersNate Bridgernbridger@wyominghunters.org—State Regulation AlertState Alerts: wyomingwyomingAll GameactiveOct 16, 2026
198. Subscriberspublic.newsletter_subscribersSamuel Carterscarter@whitetailwoods.com—Weekly DispatchNewsletterall-statesAll GameactiveOct 15, 2026
209. General Supportpublic.general_contactsDr. Alan Whitakerawhitaker@wildlifeconservation.org(406) 555-0112Editorial & Conservation PartnershipRocky Mountain Elk Foundation Habitat Grant FeatureMontana—reviewedOct 17, 2026
219. General Supportpublic.general_contactsTravis Boonetboone@gmail.com(614) 555-0174Regulation UpdateOhio Straight-Wall Cartridge Season Dates QuestionOhio—newOct 15, 2026
iHunt Sheet Tabs:
Database Routing Blueprint

How iHunt Routes Contacts by Origin into Supabase Tables & Sheet Tabs

Every form submission or purchase event writes to its dedicated origin table AND appends a categorized entry in public.contacts so no lead is ever lost.

Migration File: supabase/migrations/20261017_ihunt_contact_sheets_schema.sql
1. All Contacts11 Columns

All Contacts (Master Rollup)

Unified master rollup of every contact across all 8 origin locations, tagged with its Sheet Tab and dedicated Supabase source table.

Table:public.contacts
View:public.ihunt_sheet_all_contacts
2. Outfitters12 Columns

Outfitters & Guides

Outfitter & guide service applications requesting featured directory placement and verified operator badging on iHunt.

Table:public.outfitter_submissions
View:public.ihunt_sheet_outfitters
3. Taxidermists12 Columns

Taxidermists

Master taxidermy studios submitting their studio information, turnaround times, mounts, and certifications to be listed on iHunt.

Table:public.taxidermy_submissions
View:public.ihunt_sheet_taxidermists
4. Hunt Clubs12 Columns

Private Hunt Clubs

Private hunting club presidents and lease managers listing club acreage, membership slot openings, and annual dues.

Table:public.hunt_club_submissions
View:public.ihunt_sheet_hunt_clubs
5. Hunter Purchases13 Columns

Hunter Purchases & Orders

Hunters who purchase field gear, guided hunt booking deposits, digital state hunting atlases, or private club memberships.

Table:public.hunter_purchases
View:public.ihunt_sheet_hunter_purchases
6. Hunter Inquiries11 Columns

Hunter Inquiries, Quotes & Waitlists

Hunters requesting guided expedition bookings, custom taxidermy mount quotes, or private hunt club waitlist slots.

Table:public.hunter_inquiries
View:public.ihunt_sheet_hunter_inquiries
7. Advertisers8 Columns

Sponsors & Advertisers

Outdoor brands, optics/gear manufacturers, and commercial sponsors requesting the iHunt Media Kit and ad inventory.

Table:public.media_kit_requests
View:public.ihunt_sheet_advertisers
8. Subscribers6 Columns

Newsletter & State Alerts

Hunters subscribed to the Weekly Field Dispatch newsletter and state-specific tag draw & regulation alerts.

Table:public.newsletter_subscribers
View:public.ihunt_sheet_subscribers
9. General Support9 Columns

General Support & Editorial

General messages, state regulation updates, editorial tips, and press inquiries submitted through the Contact page.

Table:public.general_contacts
View:public.ihunt_sheet_general_contacts