Global Address Data:Database Layouts
Jump to navigation
Jump to search
Template:MelissaAddressTableNav
Master US Addresses
| Field Name | Data Type | Data Len | % |
|---|---|---|---|
| MAK | bigint | 99.92% | |
| Active | bit | 99.18% | |
| Address | varchar | 50 | 99.92% |
| Suite | varchar | 20 | 26.29% |
| Urbanization | varchar | 28 | 0.30% |
| City | varchar | 35 | 99.92% |
| State | char | 2 | 99.92% |
| AddressKey | char | 11 | 99.92% |
| ParsedRange | varchar | 10 | 99.90% |
| ParsedPreDir | varchar | 5 | 20.32% |
| ParsedName | varchar | 40 | 99.92% |
| ParsedSuffix | varchar | 10 | 80.81% |
| ParsedPostDir | varchar | 5 | 5.46% |
| ParsedSuiteName | varchar | 10 | 26.18% |
| ParsedSuiteRange | varchar | 10 | 26.29% |
| ParsedGarbage | varchar | 30 | 0.00% |
| BaseMAK | bigint | 37.53% | |
| MergeMAK | bigint | 0.12% | |
| POBoxMAK | bigint | 0.00% | |
| AddressType | char | 1 | 98.79% |
| RBDI | char | 1 | 99.92% |
| FIPSAPN | varchar | 45 | 0.00% |
| CensusKey | varchar | 16 | 90.41% |
| Results | varchar | 50 | 99.87% |
| DateAdded | datetime | 99.92% | |
| GeoLevel | varchar | 1 | 90.41% |
| GeoUpdateDate | datetime | 90.43% | |
| BaseRecord | bit | 2.45% |