Calendar_Member
Members of Calendar
| Field | Type | Primary Key | Nullable | Default | Description |
|---|---|---|---|---|---|
| AutoID | int | PK | false | ||
| CalendarID | varchar(64) | false | Calendar number | ||
| UserID | varchar(64) | true | Member number | ||
| 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 |