Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| CommunityAddressLinksSeq | int | 4 | null |
|
|
|||
| CreatedDate | datetime | 16,3 | √ | null |
|
|
||
| CreatedByID | int | 4 | √ | null |
|
|
||
| ModifiedDate | datetime | 16,3 | √ | null |
|
|
||
| ModifiedByID | int | 4 | √ | null |
|
|
||
| ID | int | 4 | √ | null |
|
|
||
| AddressType | varchar | 15 | √ | null |
|
|
||
| CommunityAddressesSeq | int | 4 | √ | null |
|
|
||
| ExtraPrefix1AutoCode | varchar | 15 | null |
|
|
|||
| ExtraPrefix1Description | varchar | 100 | null |
|
|
|||
| ExtraPrefix2AutoCode | varchar | 15 | null |
|
|
|||
| ExtraPrefix2Description | varchar | 100 | null |
|
|
|||
| AddressFull | varchar | 602 | √ | null |
|
|
||
| AddressComma | varchar | 8000 | √ | null |
|
|
||
| AddressFullNoPrefix | varchar | 300 | null |
|
|
|||
| AddressCommaNoPrefix | varchar | 8000 | √ | null |
|
|
||
| AddressCreatedDate | datetime | 16,3 | √ | null |
|
|
||
| AddressCreatedByID | int | 4 | √ | null |
|
|
||
| AddressModifiedDate | datetime | 16,3 | √ | null |
|
|
||
| AddressModifiedByID | int | 4 | √ | null |
|
|
||
| Address1 | varchar | 50 | null |
|
|
|||
| Address2 | varchar | 50 | null |
|
|
|||
| Address3 | varchar | 50 | null |
|
|
|||
| Suburb | varchar | 50 | null |
|
|
|||
| State | varchar | 15 | null |
|
|
|||
| CountryCode | varchar | 5 | null |
|
|
|||
| Postcode | varchar | 15 | null |
|
|
|||
| AddressRegion | varchar | 10 | null |
|
|
|||
| AddressRegionOverrideFlag | bit | 1 | null |
|
|
|||
| AddressComment | varchar | 250 | null |
|
|
|||
| AddressDPID | varchar | 8 | null |
|
|
|||
| AddressSortPlanNumber | varchar | 10 | null |
|
|
|||
| AddressPAFVersion | varchar | 10 | null |
|
|
|||
| AddressDPIDBarcode | varchar | 60 | null |
|
|
|||
| ValidAddressFlag | bit | 1 | null |
|
|
|||
| SilentAddressFlag | bit | 1 | null |
|
|
Table contained 0 rows