Volteer data model - UC-MSIS-WEBDEV/volteer GitHub Wiki
| Name | Data Type | Notes |
|---|---|---|
| Event Code | string (10) | Unique, system generated used as part of the URL |
| Event Date | datetime | Required |
| Title | string (120) | Required |
| Description | string (500) | Required |
| Incentive | string (500) | Optional |
| Required Participants | int | Required |
| Organizer Email | string (120) | Required |
| Organizer Validated | bool | Required |
| Organizer Code | string (50) | System generated |
| Event Address 1 | string (200) | |
| Event City | string (200) | |
| Event State | string (200) | |
| Event Postal Code | string (200) | |
| Event Latitude | string (200) | |
| Event Longitude | string (200) | |
| Created Date | datetime | Required, system generated |
| Modified Date | datetime | Required, system generated |
| Deleted Date | datetime | system generated |
| Name | Data Type | Notes |
|---|---|---|
| Event Code | string (10) | Foreign Key to Event |
| Name | string (120) | Required |
| string (120) | Required | |
| Private Note | string (500) | |
| Public Note | string (500) | |
| Participant Code | string (50) | Required, System Generated |
| Status | string (10) | Required, one of (Attending, Tentative, NotAttending) |
| Created Date | datetime | Required, system generated |
| Modified Date | datetime | Required, system generated |
| Deleted Date | datetime | system generated |
| Name | Data Type | Notes |
|---|---|---|
| Event Code | string (10) | Foreign Key to Event |
| Recipient | string (50) | Email Address |
| Format | string (10) | Currently will be ‘email’ could be sms in future |
| Message | string (500) | Required |
| Created Date | datetime | Required, System Generated |
| Send Date | datetime | Required, System Generated |