© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
C#C
C#•3y ago•
2 replies
Core

Database Design

Generic question. I cannot figure out how to design the database in the following scenario:

| Users |
 -------
| Id PK |

and

| OtherTable |
 ------------
|    Id PK   |
| UserId FK  |
| Value INT  |
| Users |
 -------
| Id PK |

and

| OtherTable |
 ------------
|    Id PK   |
| UserId FK  |
| Value INT  |


OtherTable
OtherTable
is in relation with
Users
Users
, but there is a default
Value
Value
that should belong to all users.
This can be solved by creating a resource with the same value for each user, but I feel like this is a bad practice.

What other options do I have? I am using EF with Postgres, but I do not think that matters.
C# banner
C#Join
We are a programming server aimed at coders discussing everything related to C# (CSharp) and .NET.
61,871Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

Database Design
C#CC# / help
7mo ago
✅ Zoo database design
C#CC# / help
3y ago
✅ Database Design and C# cass
C#CC# / help
6mo ago
Snowflake Database Service Design Pattern
C#CC# / help
13mo ago