search

nss-evening-cohort-12 / nutshell-elk

Renaissance Faire
0 stars 3 forks source link

# ERD #97

Closed MarkyAaronYoung closed 4 years ago

MarkyAaronYoung commented 4 years ago
Screen Shot 2020-07-22 at 6 46 33 PM
luketlancaster commented 4 years ago

So can each event have > 1 of the child entities? If so I think you'll have to do a join table 🤔

also not sure what this finances table does for you here if each event only has one of each thing. couldn't you just get the one of each thing and add together the price? I think what you might want is something like

EventItem
column type
eventId string
thingId string
thingType string

where thingId is the foodId and thingType is foods (so you could use that to fetch ${baseUrl}\${thingType}\${thingId}.json or somesuch. That's just me noodling though...you'll need to think through that and figure out if it's gonna work for your requirements or not

luketlancaster commented 4 years ago

also: thingId and thingType are terrible names. Please, for the love of everything, come up with better ones if you need to go that direction

bnemchak commented 4 years ago
Screen Shot 2020-07-25 at 9 25 11 AM
psihanorak commented 4 years ago

image

luketlancaster commented 4 years ago

do y'all have an updated ERD with join tables?

MarkyAaronYoung commented 4 years ago
Screen Shot 2020-07-27 at 7 33 57 PM
luketlancaster commented 4 years ago

so are you going to have > 1 souvenir, food, show, and staff for each event?