Name |
Datatype |
Comment |
Is PK |
Is FK |
imp_defn_rule_id |
bigint |
The automatically generated primary key of the imp_defn_rule table. |
Yes |
No |
imp_defn_rule_col_index |
varchar(255) |
stores the index of the column (i.e in a csv file) or the name of the column
(i.e database table)
|
No |
No |
imp_defn_rule_text_to_contain |
varchar(255) |
The text that will cause the rule to trigger a branch. |
No |
No |
imp_defn_rule_defn_id |
bigint |
The reference for the item definition (currently for the CI type but want to be
more general).
|
No |
Yes |
imp_id |
bigint |
FK to the import operation record in the existing import operation table. |
No |
Yes |
imp_defn_rule_status |
bigint |
Status can be different based on the CI type, but will be a fk to the allowed
values inside the defn table.
|
No |
Yes |