qwat-data-model
qwat-data-model copied to clipboard
Should custom values in the qwat_vl schema tables start from id 10000 on?
Hi, the title is explicit enough. While migrating the sample data I've encountered new values all over the place. As in some of the tables the id's start from 10000 on, I think that it would be good to enforce this:
- every new custom value that's not in the base model should start from 10000 on.
- we could enforce this by a check constraint for each value table, documenting in the data model and in the wiki/documentation. This way, it's much easier to differentiate between base values and custom values (>= 10000).
Thoughts?
+1
If agreed, this should be written in the data manager documentation. @sylvainbeo ?
@haubourg This is a point of how custom qwat_vl values should be stored.