Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| DentistID | int identity | 4 | √ | null |
|
|
||||||
| DentistCode | char | 8 | null |
|
|
|||||||
| DentistName | varchar | 50 | null |
|
|
|||||||
| Address1 | varchar | 50 | √ | null |
|
|
||||||
| Address2 | varchar | 50 | √ | null |
|
|
||||||
| Address3 | varchar | 50 | √ | null |
|
|
||||||
| Address4 | varchar | 50 | √ | null |
|
|
||||||
| Address5 | varchar | 50 | √ | null |
|
|
||||||
| PostCode | varchar | 8 | √ | null |
|
|
||||||
| IsDeleted | bit | 1 | ((0)) |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_ltblDENTIST_INFO_1 | Primary key | Asc | DentistID |
| IX_ltblDENTIST_INFO | Performance | Asc | DentistName |