Marťafiixek
DTDrizzle Team
•Created by thejessewinton on 2/2/2024 in #help
Not enough information to infer relation
11 replies
DTDrizzle Team
•Created by thejessewinton on 2/2/2024 in #help
Not enough information to infer relation
Watch this YT video
11 replies
DTDrizzle Team
•Created by thejessewinton on 2/2/2024 in #help
Not enough information to infer relation
I have another idea though
11 replies
DTDrizzle Team
•Created by thejessewinton on 2/2/2024 in #help
Not enough information to infer relation
Sure I do
11 replies
DTDrizzle Team
•Created by thejessewinton on 2/2/2024 in #help
Not enough information to infer relation
Which will eventually form many to many relationship
11 replies
DTDrizzle Team
•Created by thejessewinton on 2/2/2024 in #help
Not enough information to infer relation
There will be one to many relationship between the join table and candidates, and one to many between the join table and jobs
11 replies
DTDrizzle Team
•Created by thejessewinton on 2/2/2024 in #help
Not enough information to infer relation
You should create a table called
candidates_jobs, where you will have columns candidate_id and job_id11 replies
DTDrizzle Team
•Created by thejessewinton on 2/2/2024 in #help
Not enough information to infer relation
That's basic SQL design you are missing on
11 replies
DTDrizzle Team
•Created by thejessewinton on 2/2/2024 in #help
Not enough information to infer relation
You want to have many to many relation yet you have no join table
11 replies
DTDrizzle Team
•Created by Marťafiixek on 12/11/2023 in #help
How do you structure your schemas?
Or should I have a separate file for JOIN tables?
18 replies
DTDrizzle Team
•Created by Marťafiixek on 12/11/2023 in #help
How do you structure your schemas?
Also, suppose I have a many to many relation between
users and projects. I need to create a JOIN table, in which file should I create the JOIN table and relations. Under users.ts or projects.ts?18 replies
DTDrizzle Team
•Created by Marťafiixek on 12/11/2023 in #help
How do you structure your schemas?
I can now choose approach in peace as I have at least a opinion from someone else 😄
18 replies
DTDrizzle Team
•Created by Marťafiixek on 12/11/2023 in #help
How do you structure your schemas?
Thanks for the input
18 replies
DTDrizzle Team
•Created by Marťafiixek on 12/11/2023 in #help
How do you structure your schemas?
Makes sense
18 replies
DTDrizzle Team
•Created by Marťafiixek on 12/11/2023 in #help
How do you structure your schemas?
Oh get it
18 replies
DTDrizzle Team
•Created by Marťafiixek on 12/11/2023 in #help
How do you structure your schemas?
Sorry, relational databases are not my strong point
18 replies
DTDrizzle Team
•Created by Marťafiixek on 12/11/2023 in #help
How do you structure your schemas?
What do you mean grouped by domain?
18 replies
DTDrizzle Team
•Created by Marťafiixek on 12/11/2023 in #help
How do you structure your schemas?
I've thought about grouping similar tables such as companies and halls or hall separators to one file that exports these three tables
18 replies