sql - Table Design For SystemSettings, Best Model -


Someone has suggested to fill a table of settings, where each column has a setting name (or type) and the rows The customer is & amp; Their respective settings for each setting.

ID | ISDmin | ImagePath
------------------------------ 12 | 1 & nbsp; & Nbsp; & Nbsp; & Nbsp; & Nbsp; & Nbsp; & Nbsp; & Nbsp; & Nbsp; & Nbsp; | \ Path \ to \ images
34 0 & nbsp; & Nbsp; & Nbsp; & Nbsp; & Nbsp; & Nbsp; & Nbsp; & Nbsp; & Nbsp; & Nbsp; | \ Path \ to \ images

Every time we want a new setting name (or type), we change the table (via SQL) and add new (column) settings name Are / type Then update rows (so that each customer now has a value for that setting).

The new table design proposal proposal has to set the column to set the name and other columns. ID | | Setting name | Settings Valley ---------------------------- 12 | Islam & nbsp; & Nbsp; & Nbsp; & Nbsp; & Nbsp; & Nbsp; & Nbsp; | 1
12 | ImagePath & nbsp; & Nbsp; & Nbsp; | \ Path \ to \ images
34 Islam & nbsp; & Nbsp; & Nbsp; & Nbsp; & Nbsp; & Nbsp; & Nbsp; | 0
34 | ImagePath & nbsp; & Nbsp; & Nbsp; | \ Path \ to \ images

The issue they made was that adding a new setting was as easy as adding an insert statement to the row, not the added column.

But some of the other designs do not seem right, it looks bad, but I can not come up with any argument against it. this is wrong?

This schema (and)

There are some professionals and more opposition in this, and It guarantees to end in tears.


Comments

Post a Comment

Popular posts from this blog

bytearray - Removing trailing nulls from byte array in C# -

OK, I'm reading in a file byte array. For some reasons, people who generate these files, at the end of the file, tell about the value of one half manga worthless nail bytes. Does anyone know what's a quick way to trim them at the end? At first thought that starting from the end of the array and starting again the last time until I found nothing other than a null, but I am surprised that there is no better way. To answer some questions: Are you sure of 0 bytes in the file, instead there is a bug in the file reading code? Yes, I'm sure of this. Can you definitely trim all indexed 0s? Yes Can anybody have any file in the rest of the file? Yes, there may be other places of 0, therefore, no, I can not start at the beginning and can not stop at the first 0. Now answering additional questions, it seems that you are doing the right thing in the right way Specifically, to touch every byte of the file from the previous 0, to check that it has only 0s. Now, whether ...
Read more

linux - Authenticating GTK app to run with root permissions -

For Linux, a UI app (uses GTK) must be run as a root (it reads and / dev / writes) SD *). While the user needs to open the root app or use "sudo" manually manually, I wonder if the app can access some OS-provided APIs for root permissions. (Note: GTK app's "Setuid" mode can not be used, so this is not an option.) Here the benefits will be an easy workflow: the user can double-click the user's default user account Instead of opening a root terminal and launching it from there, my app from desktop I ask this because OS X offers exactly this type: An app can ask OS to execute executable with root permissions - OS (and no app) then the user will have to Asks to input credentials, verifies them and then launches the desired target. I am surprised that something similar is for Linux (like Ubuntu) Explanation: So, after the signal on the monitored I wonder if I use r / w to use "/ Dev / sd ..." block device I think it is very difficult...
Read more

WPF TextBlock Overflow Text to the Left -

As a backdrop, I have a very long identity which is too long to be displayed in the given area of ​​the text block. The interesting part of the ID is the end, this is the right part. What I would like to do, instead of moving the text upwards, the text box, and cutting the right part, left the overflow and This is by default as compared to the code 1234 . I can manually trim my ID for display, but a variable space font that is not ideal. So, there is no way to change the WPF overflow direction? Is this effect you are trying to take? It looks like: & lt; Page xmlns = "http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns: x = "http: // schemos microsoft.com/winfx/2006/xaml"> & Lt; Stackpackel width = "200" & gt; & Lt; Textbox background = "honey" horizontal alignment = "right" & gt; Quick brown fox jumped on the back of the lazy dog ​​& lt; / TextBlock & gt; & Lt; / StackP...
Read more