Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| OccupHistorySeq | int identity | 4 | √ | null |
|
|
||||
| ID | int | 4 | ((0)) |
|
|
|||||
| OccupCode | varchar | 15 | √ | ('') |
|
|
||||
| OccupDesc | varchar | 50 | ('') |
|
|
|||||
| OccupCompany | varchar | 50 | ('') |
|
|
|||||
| OccupIndustryCode | varchar | 8 | ('') |
|
|
|||||
| OccupPositionCode | varchar | 8 | ('') |
|
|
|||||
| OccupPhone | varchar | 15 | ('') |
|
|
|||||
| OccupFax | varchar | 15 | ('') |
|
|
|||||
| OccupEmail | varchar | 100 | ('') |
|
|
|||||
| OccupAddress1 | varchar | 40 | ('') |
|
|
|||||
| OccupAddress2 | varchar | 40 | ('') |
|
|
|||||
| OccupAddress3 | varchar | 40 | ('') |
|
|
|||||
| OccupSuburb | varchar | 40 | ('') |
|
|
|||||
| OccupState | varchar | 40 | ('') |
|
|
|||||
| OccupCountryCode | varchar | 5 | ('') |
|
|
|||||
| OccupPostCode | varchar | 5 | ('') |
|
|
|||||
| OccupMobilePhone | varchar | 15 | ('') |
|
|
|||||
| OccupCompanyAttn | varchar | 40 | ('') |
|
|
|||||
| FromDate | datetime | 16,3 | √ | null |
|
|
||||
| ToDate | datetime | 16,3 | √ | null |
|
|
||||
| ExternalValidationFlag | bit | 1 | ((0)) |
|
|
Table contained -1 rows
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_CommunityOccupHistory | Primary key | Asc | OccupHistorySeq |
| AK_CommunityOccupHistory_ID | Performance | Asc | ID |
Relationships
Close relationships within degrees of separation
