Skip to main content

Calendar_Member

Members of Calendar

FieldTypePrimary KeyNullableDefaultDescription
AutoIDintPKfalse
CalendarIDvarchar(64)falseCalendar number
UserIDvarchar(64)trueMember number
Emailvarchar(128)trueExternal member's email
MobilePhonevarchar(32)trueNULLMobile phone. Save the phone number of the external member, and the default value is null
CatIDvarchar(128)trueCategory ID
GroupIDvarchar(64)trueParticipating group number
TypestinyinttrueType. LOV: 0 for user; 1 for external user-email; 2 for group; 3 for external user-mobile
StatustinyinttrueStatus. LOV: 0 for not confirmed; 1 for participation confirmed; 2 for participation denied;
ReMarkvarchar(1024)trueNotes. Description of the refusal to participate
CreateTimedatetimetrueDate created
RemindTimeinttrueReminder time, minute
RemindTypetinyinttrueReminder type. 0: None , 1: By minute 2: By hour 3: By day
UpdateTimedatetimetrueDate updated
AccountIDvarchar(64)trueAccount ID
ProjectIDvarchar(64)trueNetwork ID (deprecated)
VoiceRemindbittrue0Voice reminder or not