Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| wkStudentNZMOEGetNSNSeq | int identity | 4 | √ | null |
|
|
||||
| SystemProcessNumber | int | 4 | √ | null |
|
|
||||
| ID | int | 4 | √ | null |
|
|
||||
| RequestDate | datetime | 16,3 | √ | null |
|
|
||||
| ResponseDate | datetime | 16,3 | √ | null |
|
|
||||
| SynergeticNSN | varchar | 10 | ('') |
|
|
|||||
| ENROLNSN | varchar | 10 | ('') |
|
|
|||||
| SynergeticURL | varchar | 255 | ('') |
|
|
|||||
| ENROLURL | varchar | 255 | ('') |
|
|
|||||
| SynergeticFirstName | varchar | 70 | ('') |
|
|
|||||
| ENROLFirstName | varchar | 70 | ('') |
|
|
|||||
| SynergeticSurname | varchar | 30 | ('') |
|
|
|||||
| ENROLSurname | varchar | 30 | ('') |
|
|
|||||
| SynergeticGender | varchar | 15 | ('') |
|
|
|||||
| ENROLGender | varchar | 15 | ('') |
|
|
|||||
| SynergeticBirthDate | datetime | 16,3 | √ | null |
|
|
||||
| ENROLBirthDate | datetime | 16,3 | √ | null |
|
|
||||
| ENROLConfidentialFlag | bit | 1 | √ | null |
|
|
||||
| EnrolledAt | varchar | 50 | ('') |
|
|
|||||
| ENROLStartDate | datetime | 16,3 | √ | null |
|
|
||||
| ENROLLastAttendance | datetime | 16,3 | √ | null |
|
|
||||
| Comment | varchar | 1000 | ('') |
|
|
|||||
| CompleteMatchFlag | bit | 1 | null |
|
|
|||||
| ResponseType | varchar | 1 | ('') |
|
|
|||||
| UpdatedInSynergetic | bit | 1 | ((0)) |
|
|
Table contained -1 rows
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_wkStudentNZMOEGetNSN | Primary key | Asc | wkStudentNZMOEGetNSNSeq |
| AK_wkStudentNZMOEGetNSN_SystemProcessNumber | Performance | Asc/Asc | SystemProcessNumber + RequestDate |
Relationships
Close relationships within degrees of separation
