Footprints Data Model

Table
Table Name PIM Record Information
Table Definition Information about calendar appointment data (such as the workspace and ticket number) synchronization with external calendars in a Personal Information Manager (PIM) such as a computer or phone calendar system.

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
PIM Record Information Id The automatically generated primary key of the pim_record_info table. LONG Yes
External Id The value of a PIM Record Information stored as Long. VARCHAR(255) Yes
Change Key The value of a PIM Record Information, stored as a string. VARCHAR(255) Yes
Item Definition Id A Foreign Key to the Definition table. LONG No
Item Id The value of a PIM Record Information stored as Long. LONG Yes
Application User Id A Foreign Key to the Application User table. LONG Yes