Footprints Data Model

Table
Table Name Import
Table Definition  

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Import Id The automatically generated primary key of the imp table. LONG Yes
Import Status Import Status INTEGER No
Import Type Import Type VARCHAR(255) No
Import User System Level Role A Foreign Key to the Application Role table. LONG No
Import Item Definition ID A Foreign Key to the Definition table. LONG No
Import Definition ID A Foreign Key to the Definition table. LONG No
Import Date Import Date DATE No
Import Last Exec Date Import Last Exec Date DATE No
Import Create Date Import Create Date DATE No
Import Record Address Book Id A Foreign Key to the Definition table. LONG No
Import CI Address Book Id Import CI Address Book Id LONG No
Import Total Created Total Rows Created INTEGER No
Import Total Updated Total Rows updated INTEGER No
Import Total Failures Failure count. INTEGER No
Import Error Code Import Error Code VARCHAR(255) No
Import Create User Import Create User LONG No
Import Ext DB Definition Id A Foreign Key to the Definition table. LONG No
Import CI Rel from Definition Id A Foreign Key to the Definition table. LONG No
Import CI Rel to Definition Id A Foreign Key to the Definition table. LONG No
Import Time Zone Time zone of the import. VARCHAR(255) No