<field>
<name>id</name>
<type>int unsigned</type>
+ <title>Address ID</title>
<required>true</required>
<comment>Unique Address ID</comment>
<add>1.1</add>
</primaryKey>
<field>
<name>contact_id</name>
+ <title>Contact ID</title>
<type>int unsigned</type>
<comment>FK to Contact ID</comment>
<add>2.0</add>
<keyColumn>id</keyColumn>
<labelColumn>display_name</labelColumn>
</pseudoconstant>
+ <html>
+ <type>Select</type>
+ </html>
</field>
<index>
<name>index_location_type</name>
</index>
<field>
<name>is_billing</name>
+ <title>Is Billing Address</title>
<type>boolean</type>
<default>0</default>
<comment>Is this the billing address.</comment>
</field>
<field>
<name>street_number</name>
+ <title>Street Number</title>
<type>int</type>
<export>true</export>
<comment>Numeric portion of address number on the street, e.g. For 112A Main St, the street_number = 112.</comment>
</field>
<field>
<name>street_number_suffix</name>
+ <title>Street Number Suffix</title>
<type>varchar</type>
<length>8</length>
<export>true</export>
</field>
<field>
<name>street_number_predirectional</name>
+ <title>Street Direction Prefix</title>
<type>varchar</type>
<length>8</length>
<comment>Directional prefix, e.g. SE Main St, SE is the prefix.</comment>
<field>
<name>street_name</name>
<type>varchar</type>
+ <title>Street Name</title>
<length>64</length>
<export>true</export>
<comment>Actual street name, excluding St, Dr, Rd, Ave, e.g. For 112 Main St, the street_name = Main.</comment>
</index>
<field>
<name>street_type</name>
+ <title>Street Type</title>
<type>varchar</type>
<length>8</length>
<comment>St, Rd, Dr, etc.</comment>
</field>
<field>
<name>street_number_postdirectional</name>
+ <title>Street Direction Suffix</title>
<type>varchar</type>
<length>8</length>
<comment>Directional prefix, e.g. Main St S, S is the suffix.</comment>
</field>
<field>
<name>street_unit</name>
+ <title>Street Unit</title>
<type>varchar</type>
<length>16</length>
<export>true</export>
</field>
<field>
<name>supplemental_address_3</name>
+ <title>Supplemental Address 3</title>
<type>varchar</type>
<length>96</length>
<comment>Supplemental Address Information, Line 3</comment>
<field>
<name>county_id</name>
<type>int unsigned</type>
+ <title>County</title>
<comment>Which County does this address belong to.</comment>
<pseudoconstant>
<table>civicrm_county</table>
<keyColumn>id</keyColumn>
<labelColumn>name</labelColumn>
</pseudoconstant>
+ <html>
+ <type>Select</type>
+ </html>
<add>1.1</add>
</field>
<foreignKey>
<keyColumn>id</keyColumn>
<labelColumn>name</labelColumn>
</pseudoconstant>
+ <html>
+ <type>Select</type>
+ </html>
<add>1.1</add>
</field>
<foreignKey>
</field>
<field>
<name>usps_adc</name>
+ <title>USPS Code</title>
<type>varchar</type>
<length>32</length>
<comment>USPS Bulk mailing code.</comment>
<labelColumn>name</labelColumn>
<nameColumn>iso_code</nameColumn>
</pseudoconstant>
+ <html>
+ <type>Select</type>
+ </html>
<add>1.1</add>
</field>
<foreignKey>
</foreignKey>
<field>
<name>geo_code_1</name>
+ <title>Latitude</title>
<type>float</type>
<import>true</import>
<headerPattern>/geo/i</headerPattern>
</field>
<field>
<name>geo_code_2</name>
+ <title>Longitude</title>
<type>float</type>
<comment>Longitude</comment>
<import>true</import>
</field>
<field>
<name>manual_geo_code</name>
+ <title>Is manually geocoded</title>
<type>boolean</type>
<default>0</default>
<comment>Is this a manually entered geo code</comment>
</field>
<field>
<name>timezone</name>
+ <title>Timezone</title>
<type>varchar</type>
<length>8</length>
<comment>Timezone expressed as a UTC offset - e.g. United States CST would be written as "UTC-6".</comment>