AutoID | int | PK | false | | |
CalendarID | varchar(64) | | false | | Calendar number |
UserID | varchar(64) | | true | | Member number |
Email | varchar(128) | | true | | External member's email |
MobilePhone | varchar(32) | | true | NULL | Mobile phone. Save the phone number of the external member, and the default value is null |
CatID | varchar(128) | | true | | Category ID |
GroupID | varchar(64) | | true | | Participating group 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 participation confirmed; 2 for participation denied; |
ReMark | varchar(1024) | | true | | Notes. Description of the refusal 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 |
AccountID | varchar(64) | | true | | Account ID |
ProjectID | varchar(64) | | true | | Network ID (deprecated) |
VoiceRemind | bit | | true | 0 | Voice reminder or not |