Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
PatientId | int | 4 | null |
|
|
|||||||||
PreferDayPhone | bit | 1 | √ | null |
|
|
||||||||
PreferEveningPhone | bit | 1 | √ | null |
|
|
||||||||
PreferEmail | bit | 1 | √ | null |
|
|
||||||||
PreferMobile | bit | 1 | √ | null |
|
|
||||||||
PreferPost | bit | 1 | √ | null |
|
|
||||||||
PreferUseOtherDetails | bit | 1 | √ | null |
|
|
||||||||
AlertMobile | nvarchar | 20 | √ | null |
|
|
||||||||
AlertEmail | nvarchar | 1073741823 | √ | null |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PK_dbo._Deprecated_20_03_PatientPreferredContact | Primary key | Asc | PatientId |
IX_PatientId | Performance | Asc | PatientId |