Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
ID | int identity | 4 | √ | null |
|
|
||||||
Practice | int | 4 | null |
|
|
|||||||
Code | varchar | 10 | null |
|
|
|||||||
AddressLine1 | varchar | 2147483647 | √ | null |
|
|
||||||
AddressLine2 | varchar | 2147483647 | √ | null |
|
|
||||||
AddressLine3 | varchar | 2147483647 | √ | null |
|
|
||||||
AddressLine4 | varchar | 2147483647 | √ | null |
|
|
||||||
PostCode | varchar | 10 | √ | null |
|
|
||||||
IsDeleted | bit | 1 | null |
|
|
|||||||
AddressLine5 | varchar | 2147483647 | √ | null |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PK_Branch | Primary key | Asc | ID |