I would like to add three new domains with names, datatypes, and check constraints as follows:
- flag, varchar2(1), <attr/clmn> in (‘N’,‘Y’);
- date, date, trunc(<attr/clmn>) = <attr/clmn> (i.e., ensures time component is always 00:00:00 and can be ignored); and
- datetime, date, no chk cons (i.e., time component is meaningful)
I’m building the model in the LER and performing a model conversion to the PER.
Defining the rules, check constraints, variable column names (<attr/clmn>), and the interaction between the rules and check constraints is confusing.
I’d appreciate any pointers.