Back to Discover
System Message
You are working in an Event Organizer Company
Prompt
You will be given these table names: festival, food_court, provider, owner.
The schema for each table will be provided below, and will be separated by <<table_delimiter>>:
festival
{
"festival_franchise": {
"type": "Text",
"sample": ["Music Fest", "UDN", "Music Fest 2"]
},
"festival_year": {
"type": "Text",
"sample": ["2022", "2020", "2021"]
},
"location_city": {
"type": "Text",
"sample": ["Los Angeles", "New York", "Chicago"]
},
"location_state": {
"type": "Text",
"sample": ["CA", "NY", "IL"]
},
"location_country": {
"type": "Text",
"sample": ["USA", "USA", "USA"]
},
"location_text": {
"type": "Text",
"sample": ["LA Festival Grounds", "NY Central Park", "Chicago Stadium"]
},
"location_details": {
"type": "Text",
"sample": ["Main stage at LA", "Central area of NYC", "Indoor stadium"]
},
"location_lat": {
"type": "Number",
"sample": [34.0522, 40.7128, 41.8781]
},
"location_long": {
"type": "Number",
"sample": [-118.2437, -74.006, -87.6298]
},
"date_presale_start": {
"type": "Date",
"sample": ["2024-07-15", "2022-01-18", "2023-07-29"]
},
"date_presale_end": {
"type": "Date",
"sample": ["2020-01-17", "2024-07-07", "2024-10-17"]
},
"date_general_sale_start": {
"type": "Date",
"sample": ["2022-06-11", "2022-04-18", "2024-02-13"]
},
"date_general_sale_end": {
"type": "Date",
"sample": ["2020-03-15", "2020-10-29", "2025-11-06"]
},
"date_start": {
"type": "Date",
"sample": ["2022-12-24", "2021-11-06", "2021-01-23"]
},
"date_end": {
"type": "Date",
"sample": ["2024-09-01", "2020-02-24", "2023-09-05"]
},
"date_text": {
"type": "Text",
"sample": ["Presale starts soon", "Tickets on sale now", "Early bird tickets available"]
},
"faqs_question": {
"type": "Text",
"sample": [
"What is the festival schedule?",
"Are kids allowed?",
"What to bring?"
]
},
"faqs_answer": {
"type": "Text",
"sample": [
"Check our official website for details",
"Yes, but must be accompanied by an adult",
"Bring comfortable shoes and water"
]
},
"festival_line_up": {
"type": "Media",
"sample": ["Artist 1, Artist 2", "Artist 3, Artist 4", "Artist 5, Artist 6"]
},
"festival_description": {
"type": "Text",
"sample": [
"An amazing music event",
"Join us for the best music festival",
"A festival filled with energy"
]
},
"festival_thumbnail": {
"type": "Media",
"sample": ["thumbnail1.jpg", "thumbnail2.jpg", "thumbnail3.jpg"]
},
"festival_logo_light_mode": {
"type": "Media",
"sample": ["logo_light1.jpg", "logo_light2.jpg", "logo_light3.jpg"]
},
"festival_logo_dark_mode": {
"type": "Media",
"sample": ["logo_dark1.jpg", "logo_dark2.jpg", "logo_dark3.jpg"]
},
"festival_splash": {
"type": "Media",
"sample": ["splash1.jpg", "splash2.jpg", "splash3.jpg"]
},
"festival_explore_img": {
"type": "Media",
"sample": ["explore1.jpg", "explore2.jpg", "explore3.jpg"]
},
"map_mbtiles": {
"type": "Media",
"sample": ["map1.mbtiles", "map2.mbtiles", "map3.mbtiles"]
},
"annotations": {
"type": "Media",
"sample": ["Annotation 1", "Annotation 2", "Annotation 3"]
},
"stages_name": {
"type": "Text",
"sample": ["Stage 1", "Stage 2", "Stage 3"]
},
"stages_slug": {
"type": "Text",
"sample": ["stage-1", "stage-2", "stage-3"]
},
"stages_description": {
"type": "Text",
"sample": [
"Main stage with top artists",
"Electronic stage",
"Hip-hop stage"
]
},
"beyond_the_music_slug": {
"type": "Text",
"sample": ["activity-1", "activity-2", "activity-3"]
},
"premium_name": {
"type": "Text",
"sample": ["VIP Package 1", "VIP Package 2", "VIP Package 3"]
},
"premium_slug": {
"type": "Text",
"sample": ["vip-1", "vip-2", "vip-3"]
},
"foods_slug": {
"type": "Text",
"sample": ["food-1", "food-2", "food-3"]
},
"foods_description": {
"type": "Text",
"sample": [
"Gourmet food trucks",
"Vegan options",
"Traditional street food"
]
},
"faq_external_url": {
"type": "Text",
"sample": ["https://faq1.com", "https://faq2.com", "https://faq3.com"]
},
"temp_activity_description": {
"type": "Text",
"sample": [
"VIP backstage experience",
"Meet & greet with artists",
"Special viewing areas"
]
},
"temp_activity_description_expires_at": {
"type": "Date",
"sample": ["2025-06-26", "2025-05-08", "2024-03-09"]
},
"show_on_home_screen": {
"type": "Boolean",
"sample": [false, false, false]
},
"wristband_activation": {
"type": "Boolean",
"sample": [false, false, true]
},
"artist_list": {
"type": "Boolean",
"sample": [true, true, true]
},
"food_vendors": {
"type": "Boolean",
"sample": [true, true, false]
},
"collect_set": {
"type": "Boolean",
"sample": [true, true, false]
},
"missions": {
"type": "Boolean",
"sample": [false, false, true]
},
"discord": {
"type": "Boolean",
"sample": [true, false, true]
},
"tips": {
"type": "Boolean",
"sample": [false, true, true]
},
"beyond_the_music": {
"type": "Boolean",
"sample": [true, false, true]
},
"calendar": {
"type": "Boolean",
"sample": [true, false, true]
},
"location": {
"type": "Boolean",
"sample": [false, true, true]
},
"merch": {
"type": "Boolean",
"sample": [true, true, false]
},
"community_meetup": {
"type": "Boolean",
"sample": [false, true, true]
},
"section_food_vendors_img": {
"type": "Media",
"sample": ["food_image1.jpg", "food_image2.jpg", "food_image3.jpg"]
},
"section_merch_image": {
"type": "Media",
"sample": ["merch_image1.jpg", "merch_image2.jpg", "merch_image3.jpg"]
},
"section_merch_link": {
"type": "Text",
"sample": ["https://merch1.com", "https://merch2.com", "https://merch3.com"]
},
"section_merch_description": {
"type": "Text",
"sample": [
"Festival T-shirts",
"Limited Edition Caps",
"Official festival hoodie"
]
},
"tradable_bits_venue_name": {
"type": "Text",
"sample": ["Venue 1", "Venue 2", "Venue 3"]
},
"tradable_bits_performance_uid": {
"type": "Text",
"sample": ["uid-1", "uid-2", "uid-3"]
},
"tradable_bits_section_location_url": {
"type": "Text",
"sample": ["https://venue1.com", "https://venue2.com", "https://venue3.com"]
},
"section_tips_wristband_url": {
"type": "Text",
"sample": [
"https://wristband1.com",
"https://wristband2.com",
"https://wristband3.com"
]
},
"section_tips_ada_url": {
"type": "Text",
"sample": ["https://ada1.com", "https://ada2.com", "https://ada3.com"]
},
"festival_secondary_text": {
"type": "Text",
"sample": [
"Extra info for festival",
"Important updates",
"Festival tips"
]
},
"food_courts": {
"type": "Relation",
"children": "food_court"
},
"static_map": {
"type": "Media",
"sample": ["static_map1.jpg", "static_map2.jpg", "static_map3.jpg"]
},
"festival_genres_tags": {
"type": "Relation with Festival Genres Tag"
}
}
<<table_delimiter>>
food_court
{
"community_meetup": {
"type": "Boolean",
"sample": [false, true, true]
},
"section_food_vendors_img": {
"type": "Media",
"sample": ["food_image1.jpg", "food_image2.jpg", "food_image3.jpg"]
},
"providers": {
"type": "Relation",
"children": "provider"
}
}
<<table_delimiter>>
provider
{
"name": {
"type": "String"
},
"description": {
"type": "String"
},
"owner": {
"type": "Relation",
"children": "person"
}
}
<<table_delimiter>>
person
{
"name": {
"type": "String"
},
"age": {
"type": "Number"
},
"ownedProvider": {
"type": "Relation",
"children": "provider"
}
}
Help me to identify the relationship between these files with this OUTPUT SCHEMA
All POSSIBLE RELATIONSHIPS :
- "hasMany" (A hasMany relation denotes a one-to-many connection of a model to another model through referential integrity. The referential integrity is enforced by a foreign key constraint on the target model which usually references a primary key on the source model. This relation indicates that each instance of the declaring or source model has zero or more instances of the target model. For example, in an application with customers and orders, a customer can have many orders)
- "belongsTo" (a many-to-one connection of a model to another model through referential integrity. The referential integrity is enforced by a foreign key constraint on the source model which usually references a primary key on the target model. This relation indicates that each instance of the declaring or source model belongs to exactly one instance of the target model. For example, in an application with customers and orders, an order always belongs to exactly one customer)
- "hasOne" (one-to-one connection of a model to another model through referential integrity. The referential integrity is enforced by a foreign key constraint on both the source model and the target model which usually references a primary key on the source model for the target model and primary key on the target model for the source model. This relation indicates that each instance of the declaring or source model belongs to exactly one instance of the target model. For example, in an application with suppliers and accounts, a supplier can have only one account as illustrated)
- "hasManyThrough" (a many-to-many connection with another model. The referential integrity is enforced by foreign key constraints on the through model which usually references primary keys on the source model and the target model. This relation indicates that the declaring model can be matched with zero or more instances of another model by proceeding through a third model. For example, in an application for a medical practice where patients make appointments to see doctors)
- "referencesMany" (relation that embeds an array of foreign keys to reference other objects)
OUTPUT SCHEMA
{
"relationship": POSSIBLE RELATIONSHIPS,
"description": "describe why you select this relationship",
"confidenceScore": "rate from 0-100 how confidence you are about this selection",
"junctionTable": "If relation is hasManyThrough, suggest a name for the junction table, if not just leave empty"
}
Only output JSON, nothing else