CalendarID | varchar(64) | | false | | Calendar number |
UserID | varchar(64) | | true | | Member number (deprecated) |
RecurTime | datetime | | false | | Repeat time |
Email | varchar(128) | | true | | External member's email |
MobilePhone | varchar(32) | | true | | Mobile phone. Save the phone number of the external member, and the default value is null |
GroupID | varchar(64) | | true | | Participating group number (deprecated) |
CatID | varchar(64) | | true | | Category number |
Types | tinyint | | true | | Type. LOV: 0 for user; 1 for external user-email; 2 for group; 3 for external user-mobile |
Status | tinyint | | true | | Status. LOV: 0 for not confirmed; 1 for confirmed participation; 2 for declined; |
ReMark | varchar(1024) | | true | | Notes. Notes for declining to participate |
CreateTime | datetime | | true | | Date created |
RemindTime | int | | true | | Reminder time, minute |
RemindType | tinyint | | true | | Reminder type. 0:None , 1:By minute, 2:By hour, 3:By day |
UpdateTime | datetime | | true | | Date updated |
AutoID | int | PK | false | | |
AccountID | varchar(64) | | true | | |
ProjectID | varchar(64) | | true | | (deprecated) |
VoiceRemind | bit | | true | 0 | Voice message |