Footprints Data Model

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

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Import Definition Rule Id The automatically generated primary key of the imp_defn_rule table. LONG Yes
Import Definition Rule Column Index stores the index of the column (i.e in a csv file) or the name of the column (i.e database table) VARCHAR(255) Yes
Import Definition Rule Text To Contain The text that will cause the rule to trigger a branch. VARCHAR(255) Yes
Import Definition Rule Definition Id The reference for the item definition (currently for the CI type but want to be more general). LONG Yes
Import Id FK to the import operation record in the existing import operation table. LONG No
Import Definition Rule Status Status can be different based on the CI type, but will be a fk to the allowed values inside the defn table. LONG No