Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| VSNInvalidStudentsSeq | int identity | 4 | √ | null |
|
|
||
| ID | int | 4 | null |
|
|
|||
| FirstName | varchar | 30 | √ | ('') |
|
|
||
| LastName | varchar | 30 | ('') |
|
|
|||
| BirthDate | datetime | 16,3 | √ | null |
|
|
||
| VSN | varchar | 15 | ('') |
|
|
|||
| ErrorMessage | varchar | 100 | ('') |
|
|
|||
| SentTo | varchar | 50 | √ | null |
|
|
||
| GUID | uniqueidentifier | 16 | √ | null |
|
|
||
| CreatedOn | datetime | 16,3 | √ | (getdate()) |
|
|
||
| TransactionType | varchar | 20 | ('') |
|
|
|||
| NewFirstName | varchar | 30 | √ | ('') |
|
|
||
| NewLastName | varchar | 30 | ('') |
|
|
|||
| NewBirthDate | datetime | 16,3 | √ | null |
|
|
||
| NewGender | varchar | 15 | ('') |
|
|
|||
| Gender | varchar | 15 | ('') |
|
|
Table contained -1 rows
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| AK_VSNInvalidStudents_GUID_VSNInvalidStudentsSeq | Performance | Asc/Asc | VSNInvalidStudentsSeq + GUID |