| AutoID | int | | false | | |
| CalendarID | varchar(64) | PK | false | | Calendar number |
| CalendarName | varchar(512) | | true | | Calendar name |
| StartTime | datetime | | true | | Start time, to the minute |
| EndTime | datetime | | true | | End time, to the minute |
| IsAllDay | bit | | true | | All day |
| Address | varchar(512) | | true | | Address |
| Description | varchar(1024) | | true | | Description |
| Types | tinyint | | true | | Type. LOV: 0 for private; 1 for public ( you can invite other members to join); 2 for invisible calendar (push reminder) ( deprecated) |
| GroupID | varchar(512) | | true | | Private group, separated by an English comma (deprecated) |
| ProjectID | varchar(64) | | true | | Network ID (deprecated) |
| Sequence | int | | true | 0 | Sequence. Increment by 1 when editing start,end,recurRule, or member status. Default:1 |
| IsRecur | bit | | true | 0 | Repeated calendar or not. 1:Yes, 0:No. Default:0 |
| Frequency | tinyint | | true | 0 | Frequency. LOV: 0: No repeat, 1: Daily, 2: Weekly. 3: Monthly, 4: Yearly |
| Interval | int | | true | 1 | Repeat interval. Default: 1 |
| RecurCount | int | | true | 0 | Repeat times. Default: 0 |
| UntilDate | datetime | | true | | End date. If RecurCount is 0 and UntilDate is null, it is a permanent repeat |
| WeekDay | int | | true | | Repeat on which day. LOV: 0: non-weekly repeat, 1:Monday, 2:Tuesday, 4:Wednesday, 8:Thursday, 16:Friday, 32 Saturday, 64:Sunday |
| EventStart | datetime | | true | | Repeat start date |
| EventEnd | datetime | | true | | Repeat end date |
| CreateUser | varchar(64) | | true | | Creator (deprecated) |
| AppID | varchar(64) | | true | | Source of creating calendar |
| IsDelete | bit | | true | 0 | Deleted or not |
| CreateTime | datetime | | true | | Date created |
| UpdateTime | datetime | | true | | Date updated |
| Locked | bit | | true | | Locked or not (deprecated) |
| CreateAccountID | varchar(64) | | true | | Creator Account ID |
| IsPrivate | bit | | false | 0 | Private calendar or not |