demo_rules: Rules for data generation
In EvgenyPetrovsky/synthezator: Generate synthetic data

A dataset contains rules to generate attributes (columns) of tables (datasets)

1	demo_rules

A dataframe with following variables

Table: Table (Dataset) Name for the result. Result is returned as list of dataframes, list names conform to Table values from rules.
Attribute: Attribute (Column) Name for generated result
Attribute.Length: Maximum length of attribute; mandatory for Number and optional fore Varchar
Attribute.Length: Maximum number of digits in decimal part of number; mandatry for Number
Attribute.Type: Data Type of attribute; can be Number, Date or Varchar. Date attributes must be in specific format "YYYYMMDD"
Evaluation.Sequence: Defines order in which attributes are being generated. Attributes without sequence receive Sequence = 0. In case Evaluation.Condition or Evaluation.Expression refer to other attributes it is important to define correct sequence.
Evaluation.Condition: Expresstion that returns either FALSE or TRUE; empty condition is treated as truth.
Value.Type: Defines the way how value is being generated. Can be of following values: Empty (Empty value); Fixed (Fixed value, the same for all records of dataset); Expression (Calculated value based on formula); Random (Randomly generated value); LOV (Value picked from list of values).
Fixed.Value./.Offset: Defines fixed value for Fixed value type or offset for Random value type, offset is being added to random value.
List.Of.Values: Name of list with values. List of values must be existing one for successful value generation
Random.Distribution: Name of random distribution; must be specified for attributes with Value.Type = Random
Mean: Random distribution mean; must be specified for attributes with Value.Type = Random
Standard.Dev: Random distribution standard deviation; must be specified for attributes with Value.Type = Random
Sign: Sign Type for randomly generated value; must be specified for attributes with Value.Type = Random. Sometimes it is important to have values of only specific sign. Possible values are: Any (keep avlue as it is); Not Negative (replace negative values with 0); Not Positive (replace positive values with 0); Flip Negative (replace negative values with positive counterparts); Flip Positive (replace positive values with negative counterparts);
Evaluation.Expression: Expression that returns value; must be specified for attributes with Value.Type = Expression