Footprints Data Model

Table
Name imp_defn_rule
Comment
This table contains the information necessary for the application
to do a conditional flow in the processing based on a text string (defn 
value).

Column
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