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