escay/Facttype — Issue #32: Add uniqueness constraint, range start and range end to no overlapping rule
Author: KarlONeill
Created: 2012-02-10 09:22:35+00:00
State: open

A no overlapping rule describes that ranges, defined by two (combinations of) columns, may not overlap for a unique value contained in one or more columns. For example: a person, identified by his or her social security number, may not have more than one job at any one time.

It would be nice to include, the uniqueness constraint (one or more columns), the start of range (one or more columns) and the end of range in the no overlapping rule. And have these displayed at the bottom of the facttype, like the valuerule and the occurence frequency rule

noOverlappingRule NO1 {
description "this is a no overlapping rule"
uniqueness constraint "social security number"
start of range "first day at job"
end of range "last day at job"
columns [ "social security number" "first day at job" "last day at job" ]
}