qwat-data-model icon indicating copy to clipboard operation
qwat-data-model copied to clipboard

Should custom values in the qwat_vl schema tables start from id 10000 on?

Open tudorbarascu opened this issue 8 years ago • 2 comments

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?

tudorbarascu avatar Jun 13 '16 06:06 tudorbarascu

+1

If agreed, this should be written in the data manager documentation. @sylvainbeo ?

3nids avatar Jun 13 '16 07:06 3nids

@haubourg This is a point of how custom qwat_vl values should be stored.

ponceta avatar Mar 08 '17 13:03 ponceta