Appearance
dbo.ethGeoLocationStatus
Info Generated by
scripts/Generate-DataDictionary.ps1- do not edit by hand. Edit descriptions inschemas/tables/dbo.ethGeoLocationStatus.jsonand regenerate.
Columns
| # | Column | Type | Nullable | Flags | Description |
|---|---|---|---|---|---|
| 1 | ID | int | no | identity | Surrogate primary key identifying this geolocation status record. |
| 2 | PhoneCallID | int | yes | Foreign key to the phone call record this geolocation lookup relates to. | |
| 3 | primeContactID | uniqueidentifier | yes | Foreign key to the Prime Ecosystem contact this geolocation lookup relates to. | |
| 4 | updatedAt | datetime2(7) | no | The date and time this geolocation status was last updated. | |
| 5 | status | tinyint | no | A numeric code representing the state of the geolocation/geocoding process for this contact or phone call (e.g. pending, resolved, failed). |
Indexes
| Name | Type | Unique | PK | Key columns | Included | Filter |
|---|---|---|---|---|---|---|
| PK_ethGeoLocationStatus | CLUSTERED | yes | yes | ID |
Relationships (inferred)
| From | To | Confidence |
|---|---|---|
| dbo.ethGeoLocationStatus.primeContactID | dbo.primeContacts.id | low |