Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| PTISessionSlotSeq | int | 4 | null |
|
|
|||||
| StaffID | int | 4 | ((0)) |
|
|
|||||
| ContactID | int | 4 | ((0)) |
|
|
|||||
| Contact2ID | int | 4 | ((0)) |
|
|
|||||
| ID | int | 4 | ((0)) |
|
|
|||||
| PTInterviewsSeq | int identity | 4 | √ | null |
|
|
Table contained -1 rows
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_PTInterviews | Primary key | Asc/Asc | PTISessionSlotSeq + StaffID |
| AK_PTInterviews_Contact2ID | Performance | Asc | Contact2ID |
| AK_PTInterviews_ContactID | Performance | Asc | ContactID |
| AK_PTInterviews_ID_ContactID_includes | Performance | Asc/Asc | ID + ContactID |
| AK_PTInterviews_PTInterviewsSeq | Must be unique | Asc | PTInterviewsSeq |
| AK_PTInterviews_StaffID_ContactID_includes | Performance | Asc/Asc | StaffID + ContactID |
| AK_PTInterviews_StaffID_ID_includes | Performance | Asc/Asc | StaffID + ID |
Relationships
Close relationships within degrees of separation
