I have a idea of a database structure but am unabl...
# orm-helpd
Debaucus
05/26/2022, 3:02 AMI have a idea of a database structure but am unable to get a grasp on the correct layout.
Copy code
Server_type_1:
- title
- description
- name
- id
- custom thing 1
- custom thing 2
- custom thing x
Server_type_2:
- title
- description
- name
- id
- custom thing 1
- custom thing 2
- custom thing xServer_type_1o
Omar
05/26/2022, 7:32 AMYou could add a query param to the url to distinguish between them.
n
Nurul
05/26/2022, 10:44 AMAre you having an issue in designing your database schema?
Or designing your API structure?
Nurul
05/26/2022, 10:45 AMDo you want to pass these values to NextJS API Routes?
d
Debaucus
05/26/2022, 3:52 PMI'm newish to the whole concept, but the goal is like subreddits on reddit, but each subreddit has customisations
Debaucus
05/26/2022, 3:54 PMSo I can't have 1 massive table which has many, many columns which are useless 95% of the time. So some way of loading the custom column info depending on the initial link.
Debaucus
05/26/2022, 3:54 PMSo all data loads via /r/ for example, but custom content loads depending on the table, e.g. Server_type_1 or Server_type_2
n
Nurul
05/27/2022, 2:05 PMHave you started with some sort of database schema?
d
Debaucus
05/27/2022, 2:16 PMNothing as of yet, since I think that's the focus of how this would work best
Debaucus
05/27/2022, 2:17 PMhttps://www.reddit.com/r/Database/comments/uycng9/database_design_like_reddit_but_each_subreddit/
Here's a post I made to Reddit, had a rough go at what one of the comments said.
3 Views