USERCALENDAR Table

Added in Version 6.0

The USERCALENDAR table contains user profile settings from the Calendar tab in the Administrator. These settings indicate the calendars the user can access as well as the other users that can access the user’s calendar. These access rights include adding, editing, deleting and synchronizing activities. USERID represents a user who can access a calendar. CALUSERID represents the user who owns the calendar.

  • If you applied the SLX Indexes for MS SQL.sql script to your database, your index information may be different than described in this topic.  For more information, see the Index Changes.pdf document.

  • While this table does not have a field defined as a primary key, the USERID field should be unique and considered a primary key.

Legend
 

Field Datatype (Length) Allow Nulls Indexes Relationship Related Table and Field

USERID (FK)

char(12)

NULLS

USERCALENDAR_USERID (IE)

(Many) to (One)

USERSECURITY.USERID

CALUSERID (FK)

char(12)

NULLS

USERCALENDAR_CALUSERID (IE)

(Many) to (One)

USERSECURITY.USERID

 

ALLOWADD

char(1)

NULLS

 

 

 

ALLOWEDIT

char(1)

NULLS

 

 

 

ALLOWDELETE

char(1)

NULLS

 

 

 

ALLOWSYNC

char(1)

NULLS

 

 

 

MODIFYDATE

datetime(8)

NULLS

 

 

 

MODIFYUSER (FK)

char(12)

NULLS

 

(Many) to (One)

USERINFO.USERID

CREATEDATE

datetime(8)

NULLS

 

 

 

CREATEUSER (FK)

char(12)

NULLS

 

(Many) to (One)

USERINFO.USERID