Subject Area : 142 - Calendar Sync
Subject Area(s) of Model "Renoir Domain Model Detail"
# Name Definition ER Diagram Entity/Table
Total
. 142 - Calendar Sync Tables used to sync the calendar appointments with a device that supports a calendar. Details.. Details..
ER Diagram(s) of Subject Area "142 - Calendar Sync"
# Name Physical Display Level
Total 2
. Logical Column
. Physical Column
Entity/Table(s) of Subject Area "142 - Calendar Sync"
# Physical Name Name Logical Only Do Not Generate Definition Attribute/Column
Total 6
. app_user Application User false A user authorized to use the FootPrints system. The user is either a Customer User or an Agent User. The application user holds the minimum information needed to identify the user and associate the user with a user profile, where user settings are stored. A contact is not necessarily an application user. An application user entry is required in order for the user to access any online functions. Details..
. cal_item Calendar Item false The main calendar item table for the calender service. This table is populated and maintained by the Calendar Service API. It is not very suitable for database query outside of the API. The calendar item can be a personal or workspace calendar, or an appointment within the calendar. The calendar item can be synched using the iCal format. Details..
. defn Definition false A definition holds the structural and behavioral information needed for an application element that is configuarable by the system designer and/or the end user at definition time. Current Footrpints uses a combination of directories, files, tables, and programming code to represent this information. The new FootPrints will provide all of the same information within the definition. The definition can be persisted in a structure that is isolated at the Instance Level. The data for the definition will be stored as Configuration Settings associated with the Definition Version. See the database views v_defn_ver_active, v_cntnr_item_field. Details..
. pim_appt_info PIM Appointment Information false Information about calendar appointment synchronization with external calendars in a Personal Information Manager (PIM) such as a computer or phone calendar system. Details..
. pim_record_info PIM Record Information false 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. Details..
. syncing_job_dtl Syncing Job Detail false A table used to control syncing of Calendar Items with a computer or phone calendar system. Details..
Attribute/Column(s) of Entity/Table "Application User"
# Physical Name Name Definition Physical Data Type
Total 8
. pwd Password This space intentionally left blank. varchar(255)
. user_name User Name The name of the Application User. nvarchar(4000)
. cust_login_type_id Customer Login Type Id A Foreign Key to the Customer Login Type table. int
. app_user_id Application User Id The automatically generated primary key of the app_user table. bigint
. lic_type_id License Type Id A Foreign Key to the License Type table. bigint
. user_login User Login The login name used to access the Application. This may not be filled in if external application security is used. nvarchar(4000)
. email_addr Email Address An email address for the Application User. nvarchar(4000)
. delete_date Delete Date The value of a Application User, stored as a date. datetime
Attribute/Column(s) of Entity/Table "Calendar Item"
# Physical Name Name Definition Physical Data Type
Total 24
. item_type item type item type. varchar(16)
. cal_item_id Calendar Item Id The automatically generated primary key of the cal_item table. bigint
. create_date create date create date, stored as a long integer to avoid using date time classes that do not handle timezone well. int
. etag etag etag. varchar(255)
. mdfy_date modify date modify date, stored as a long integer to avoid using date time classes that do not handle timezone well. int
. client_create_date client create date client create date, stored as a long integer to avoid using date time classes that do not handle timezone well. int
. client_mod_date client modified date client modified date, stored as a long integer to avoid using date time classes that do not handle timezone well. int
. display_name display name display name. nvarchar(4000)
. item_name item name item name. nvarchar(4000)
. intrnl_id Internal Id Internal Id. varchar(255)
. last_modf last modification The value of a Calendar Item, stored as a date. int
. last_mod_by last modified by last modified by. nvarchar(4000)
. needs_reply needs reply Indicates if needs reply. bit
. sent sent Indicates if sent. bit
. ical_uid ical uid ical uid. varchar(255)
. content_encoding content encoding content encoding. varchar(32)
. content_language content language content language. varchar(32)
. content_length content length The value of a Calendar Item stored as Long. bigint
. content_type content type content type. varchar(64)
. has_modfs has modifications Indicates if has modifications. bit
. cal_content_data_id Calendar Content Data Id A Foreign Key to the Calendar Content Data table. bigint
. app_user_id Application User Id A Foreign Key to the Application User table. bigint
. modifies_cal_item_id Modifies Calendar Item Id A Foreign Key to the Calendar Item table. bigint
. delete_date Delete Date The value of a Calendar Item, stored as a date. datetime
Attribute/Column(s) of Entity/Table "Definition"
# Physical Name Name Definition Physical Data Type
Total 7
. defn_id Definition Id The automatically generated primary key of the defn table. bigint
. defn_name Definition Name The name of the Definition. nvarchar(4000)
. dsble_date Disabled Date The date that this instance of Definition is logically deleted and disabled. datetime
. defn_guid Definition GUID A Global Unique IDentifier search key for the Definition, composed of letters and numbers. It is computed by the client and typically used in unstructured data. varchar(50)
. defn_type_name Definition Type Name The unique string identifier for an instance of Definition Type. This identifier must be kept in sync with programming code that uses an enumeration constant to identify particular values. A scan program is generally used to populate this table. varchar(255)
. defn_subtype_id Definition Subtype Id A Foreign Key to the Definition Subtype table. int
. tmpl_export_guid Template Export GUID The value of a Definition, stored as a string. VARCHAR(50)
Attribute/Column(s) of Entity/Table "PIM Appointment Information"
# Physical Name Name Definition Physical Data Type
Total 5
. pim_appt_info_id PIM Appointment Information Id The automatically generated primary key of the pim_appt_info table. bigint
. extl_id External Id The value of a PIM Appointment Information stored as Long. varchar(255)
. chg_key Change Key The value of a PIM Appointment Information, stored as a string. varchar(255)
. app_user_id Application User Id A Foreign Key to the Application User table. bigint
. cal_item_intrnl_id Calendar Item Internal Id Calendar Item Internal Id. varchar(255)
Attribute/Column(s) of Entity/Table "PIM Record Information"
# Physical Name Name Definition Physical Data Type
Total 6
. pim_record_info_id PIM Record Information Id The automatically generated primary key of the pim_record_info table. bigint
. extl_id External Id The value of a PIM Record Information stored as Long. varchar(255)
. chg_key Change Key The value of a PIM Record Information, stored as a string. varchar(255)
. item_defn_id Item Definition Id A Foreign Key to the Definition table. bigint
. item_id Item Id The value of a PIM Record Information stored as Long. bigint
. app_user_id Application User Id A Foreign Key to the Application User table. bigint
Attribute/Column(s) of Entity/Table "Syncing Job Detail"
# Physical Name Name Definition Physical Data Type
Total 4
. syncing_job_dtl_id Syncing Job Detail Id The automatically generated primary key of the syncing_job_dtl table. bigint
. app_user_id Application User Id A Foreign Key to the Application User table. bigint
. last_sync_date Last Sync Date The value of a Syncing Job Detail, stored as a date. datetime
. execn_date Execution Date The value of a Syncing Job Detail, stored as a date. datetime