Subject Area Name
|
Definition
|
142 - Calendar Sync
|
Tables used to sync the calendar appointments with a device that supports a calendar.
|
|
ER Diagram Name
|
Physical Display Level
|
|
Logical
|
Column
|
|
Physical
|
Column
|
|
Physical Name
|
Entity/Table Name
|
Logical Only
|
Do Not Generate
|
Definition
|
|
|
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.
|
|
|
Physical Name
|
Attribute/Column Name
|
Definition
|
Physical Data Type
|
|
|
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
|
|
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.
|
|
|
Physical Name
|
Attribute/Column Name
|
Definition
|
Physical Data Type
|
|
|
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
|
|
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.
|
|
|
Physical Name
|
Attribute/Column Name
|
Definition
|
Physical Data Type
|
|
|
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)
|
|
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.
|
|
|
Physical Name
|
Attribute/Column Name
|
Definition
|
Physical Data Type
|
|
|
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)
|
|
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.
|
|
|
Physical Name
|
Attribute/Column Name
|
Definition
|
Physical Data Type
|
|
|
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
|
|
syncing_job_dtl
|
Syncing Job Detail
|
|
false
|
A table used to control syncing of Calendar Items with a computer or phone calendar system.
|
|
|
Physical Name
|
Attribute/Column Name
|
Definition
|
Physical Data Type
|
|
|
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
|