Footprints Data Model

Table
Name pim_record_info
Comment
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.

Column
Name Datatype Comment Is PK Is FK
pim_record_info_id bigint The automatically generated primary key of the pim_record_info table. Yes No
extl_id varchar(255) The value of a PIM Record Information stored as Long. No No
chg_key varchar(255) The value of a PIM Record Information, stored as a string. No No
item_defn_id bigint A Foreign Key to the Definition table. No Yes
item_id bigint The value of a PIM Record Information stored as Long. No No
app_user_id bigint A Foreign Key to the Application User table. No Yes