I am getting turned around as I'm working through my DB design for GET route that only renders flights that are associated with a share code.
Your Real Name
Kristin
What do you want to happen?
I want the home page to render flights for any other user for which I've added their sharecode. I would like both the flight, as well as user data associated with that flight to render. See example below
What is actually happening?
I am currently getting duplicate data in my DB, some data that isn't appearing when I would expect it to, and therefore my unique key is not working.
Screenshots / Code Snippets
What did you try? Who did you ask?
I tried re-working my SQL query multiple different ways and talking it out with Janet. I know I need to reconfigure my DB so that I'm getting a unique key, but am getting confused by how to do so.
Description
I am getting turned around as I'm working through my DB design for GET route that only renders flights that are associated with a share code.
Your Real Name
Kristin
What do you want to happen? I want the home page to render flights for any other user for which I've added their sharecode. I would like both the flight, as well as user data associated with that flight to render. See example below
What is actually happening?
I am currently getting duplicate data in my DB, some data that isn't appearing when I would expect it to, and therefore my unique key is not working.
Screenshots / Code Snippets
What did you try? Who did you ask?
I tried re-working my SQL query multiple different ways and talking it out with Janet. I know I need to reconfigure my DB so that I'm getting a unique key, but am getting confused by how to do so.
What branch is your code on? Did you git push?
Currently, main. It is up to date.
When was the last time you took a break?
5 mins ago