How do you structure your schemas?

Hi,
how do you structure your schemas? I'm building a larger app, and the schemas are growing, so it doesn't make sense to have all tables in one schema.

However, creating multiple schemas as multiple files (screenshot included) is also something that I'm not in favor of.

Thanks

MarťafiixekOP•12/11/23, 9:16 PM

I've thought about grouping similar tables such as companies and halls or hall separators to one file that exports these three tables

amgau•12/11/23, 10:05 PM

I have a "db" folder, inside that I have things grouped by domain inside of a single file

MarťafiixekOP•12/11/23, 10:06 PM

What do you mean grouped by domain?

MarťafiixekOP•12/11/23, 10:06 PM

Sorry, relational databases are not my strong point

amgau•12/11/23, 10:07 PM

Just logical groupings, and then core business related things are in index.ts

amgau•12/11/23, 10:08 PM

so I have users.ts with auth stuff, preferences, etc.

MarťafiixekOP•12/11/23, 10:08 PM

Oh get it

amgau•12/11/23, 10:08 PM

index.ts with categories, transactions, accounts, invoices, etc.

MarťafiixekOP•12/11/23, 10:08 PM

Makes sense

amgau•12/11/23, 10:08 PM

don't know if it makes sense for most, but for me it kinda does, especially when importing

amgau•12/11/23, 10:08 PM

import user from '~/db/user.ts"

amgau•12/11/23, 10:08 PM

import {account, invoice} from '~/db'

amgau•12/11/23, 10:09 PM

might make more sense to just make index a barrel, but I haven't put too much thought into it

MarťafiixekOP•12/11/23, 10:16 PM

Thanks for the input

MarťafiixekOP•12/11/23, 10:17 PM

I can now choose approach in peace as I have at least a opinion from someone else

MarťafiixekOP•12/11/23, 10:37 PM

Also, suppose I have a many to many relation between

users

users

and projectsprojects. I need to create a JOIN table, in which file should I create the JOIN table and relations. Under users.tsusers.ts or projects.tsprojects.ts?

MarťafiixekOP•12/11/23, 10:38 PM

Or should I have a separate file for JOIN tables?

How do you structure your schemas?

Similar Threads

Similar Threads

Similar Threads