＊ ChainedInequality

＊SDV Enterprise Feature. This feature is only available for licensed, enterprise users. For more information, visit our page to Explore SDV.

Compatibility: 2 or more columns that are all numerical or all datetime

The ChainedInequality constraint enforces a chain of inequality relationships between any number of columns. For every row, the value in these columns must follow a strict ordering system.

Parameters

(required) column_names: A list of strings that represent the column names. They should appear in ascending order (lowest to highest).

strict_boundaries: Whether a column must be strictly greater than previous one

(default) True	The value in the higher column must be strictly greater than the lower column
False	The value in the higher column must be greater than or equal to the value in the lower column.

Example

Define your constraint using the parameters and then add it to a synthesizer.

my_constraint = {
    'constraint_class': 'ChainedInequality',
    'table_name': 'purchase_log', # for multi table synthesizers
    'constraint_parameters': {
        'column_names': ['purchase_date', 'start_date', 'end_date',
                         'expiration_date', 'termination_date'],
        'strict_boundaries': True
    }
}

my_synthesizer.add_constraints(constraints=[
    my_constraint
])