In a project that I have started working on, the database has a lot of FooDefinition tables which act like an enum. It’s a C# project using Entity Framework although that is not central to the que..
Tag : database
Let’s say I have a database of persons who have some properties. For the sake of this problem let’s say all of these properties relate a..
I recently came up with a problem which I would like to share some thoughts about with someone on this forum. This relates to finding a subset. In reality it is more complicated, but I tried to present it here using some simpler con..
I recently came up with a problem which I would like to share some thoughts about with someone on this forum. This relates to finding a subset. In reality it is more complicated, but I tried to present it here using some simpler con..
Say I am building a website that uses two different types of ..
Say I am building a website that uses two different types of ..
Closed 9 years ago
Closed 9 years ago
I have a user and a notifications table. I want to make sure that every users sees a new notification once and only once. Not more, not less. The intuitive idea is to have a n:m relation table with userId:notificationId. But isn´t it a little too much overhead to create a new table just for..
I have a user and a notifications table. I want to make sure that every users sees a new notification once and only once. Not more, not less. The intuitive idea is to have a n:m relation table with userId:notificationId. But isn´t it a little too much overhead to create a new table just for..