Sample Header Ad - 728x90

How to name tables which are responsible for storing dictionaries and configuration?

0 votes
1 answer
469 views
Below I attached diagram which corresponds to part of my database : enter image description here My questions: 1. In your opininon Do I have to divide ServiceInsance and ConfServiceInstance ? I did it like that because I would like to have separated IDs and Configuration columns. 2. What do you think about name of these tables ? I mean Is it worth to have Dict and Conf in table names ? 3. Is it a problem that PK does not corespond to table name by convention: TableName + ID in Conf and Dict tables ? 4. Is it a better idea to create schemas conf and dict maybe ?
Asked by axdna (119 rep)
Apr 8, 2020, 06:30 AM
Last activity: Jan 5, 2024, 07:02 AM