CODEWITHSUNDEEP
sql-serverdatabasesql-server-2008database-designrelational-database
001
001

Reputation: 65117

Database design - configuration/settings table

The application has multiple notifications push, email, sms etc

Push has 4-5 settings, email has the same as push+ more settings

Upvotes: 2

Views: 1500

Answers (2)

Vyrotek
Vyrotek

Reputation: 5459

I've found that I like working with a single table for this sort of scenario. Its especially useful when you have some common base fields that all the types will share. ORM frameworks such as the Entity Framework will allow you to split a single table into multiple entities and define the inheritance relationships.

Upvotes: 2

Matt Glover
Matt Glover

Reputation: 1347

Although somewhat arbitrary I typically find that sort of data stored in one table with a category column to identify what type of setting it is. Especially since the data can all be categorized as notification data.

The only argument I see in favor of 3 separate tables is that it might be slightly easier to use with an ORM.

Upvotes: 0

Related Questions