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 :
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
Last activity: Jan 5, 2024, 07:02 AM