CalendarEvent
Primary Key
| Primary Key |
Field Type |
| ID |
int |
Fields
| Field |
Field Type |
Null |
Notes |
Description |
| Category |
nvarchar(100) |
yes |
|
|
| BeginDate |
datetime |
yes |
|
|
| EndDate |
datetime |
yes |
|
|
| Title |
nvarchar(255) |
yes |
|
|
| Location |
nvarchar(255) |
yes |
|
|
| Details |
ntext |
yes |
|
|
| Fees |
nvarchar(255) |
yes |
|
|
| MoreInfoURL |
nvarchar(255) |
yes |
|
|
| ContactInfo |
nvarchar(255) |
yes |
|
|
| CreateDate |
datetime |
yes |
|
|
| ApprovedDate |
datetime |
yes |
|
|
| Deleted |
bit |
yes |
|
|
| OccurenceGroupID |
int |
yes |
|
|
| AllDayEvent |
bit |
|
Default = 0 |
|
| UpdateDate |
datetime |
|
Default = getutcdate() |
|
| MapLocation |
int |
yes |
Default = 0 |
|
| SubTitle |
nvarchar(255) |
yes |
|
|
| RecurFrequency |
int |
yes |
Default = 0 |
|
| RecurDay |
int |
yes |
Default = 0 |
|
| RecurMonth |
int |
yes |
Default = 0 |
|
| RecurDayOfWeek |
nvarchar(200) |
yes |
Default = '' |
|
| RecurStartDate |
datetime |
yes |
|
|
| RecurEndDate |
datetime |
yes |
|
|
| RecurPosition |
int |
yes |
Default = 0 |
|
| RecurMonthlyMethod |
int |
yes |
Default = 0 |
|
| RecurException |
bit |
yes |
Default = 0 |
|
| Cancelled |
bit |
|
Default = 0 |
|
Foreign Keys
Indexes
| Index Name |
Fields |
Unique |
Primary |
Clustered |
| PK_CalendarEvent |
ID |
yes |
yes |
|
Referenced by