Footprints Data Model

Table
Name imp
Comment  

Column
Name Datatype Comment Is PK Is FK
imp_id bigint The automatically generated primary key of the imp table. Yes No
imp_status int Import Status No No
imp_type varchar(255) Import Type No No
imp_user_sys_level_role bigint A Foreign Key to the Application Role table. No Yes
imp_item_defn_id bigint A Foreign Key to the Definition table. No Yes
imp_defn_id bigint A Foreign Key to the Definition table. No Yes
imp_ci_rel_from_defn_id bigint A Foreign Key to the Definition table. No Yes
imp_ci_rel_to_defn_id bigint A Foreign Key to the Definition table. No Yes
imp_ext_db_defn_id bigint A Foreign Key to the Definition table. No Yes
imp_date datetime Import Date No No
imp_last_exec_date datetime Import Last Exec Date No No
imp_create_date datetime Import Create Date No No
imp_record_addr_book_id bigint A Foreign Key to the Definition table. No Yes
imp_ci_addr_book_id bigint Import CI Address Book Id No No
imp_total_created int Total Rows Created No No
imp_total_updated int Total Rows updated No No
imp_total_failures int Failure count. No No
imp_error_cd varchar(255) Import Error Code No No
imp_create_user bigint Import Create User No No
imp_time_zone varchar(255) Time zone of the import. No No