Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ActivitySeq | int identity | 4 | √ | null |
|
|
||
| ID | int | 4 | √ | null |
|
|
||
| Activity | varchar | 15 | ('') |
|
|
|||
| ActivityDate | datetime | 16,3 | √ | null |
|
|
||
| ActivityStatus | varchar | 15 | ('') |
|
|
|||
| ActivityID | int | 4 | ((0)) |
|
|
|||
| FollowUpFlag | bit | 1 | ((0)) |
|
|
|||
| FollowUpDate | datetime | 16,3 | √ | null |
|
|
||
| FollowUpID | int | 4 | ((0)) |
|
|
|||
| Comment | varchar | 8000 | √ | ('') |
|
|
||
| MailRequestFlag | bit | 1 | ((0)) |
|
|
|||
| MailedDate | datetime | 16,3 | √ | null |
|
|
||
| MailedBy | varchar | 50 | ('') |
|
|
|||
| SystemProcessNumber | int | 4 | ((0)) |
|
|
|||
| ActivityCreatedBy | varchar | 50 | ('') |
|
|
|||
| EnquiryStudentID | int | 4 | √ | null |
|
|
||
| FutureStudentApplicationsSeq | int | 4 | √ | null |
|
|
||
| OnlineImportApplicationsSeq | int | 4 | √ | null |
|
|
Table contained -1 rows
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_tActivities | Primary key | Asc | ActivitySeq |
| AK_tActivities_FutureStudentApplicationsSeq | Performance | Asc | FutureStudentApplicationsSeq |
| AK_tActivities_SystemProcessNumber | Performance | Asc | SystemProcessNumber |