Table d45civi_b72v5.civicrm_address Generated by
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
Column Type Size Nulls Auto Default Children Parents Comments
id int unsigned 10  √ 
civicrm_address.master_id FK_civicrm_address_master_id N
civicrm_contribution.address_id FK_civicrm_contribution_address_id N
civicrm_loc_block.address_2_id FK_civicrm_loc_block_address_2_id N
civicrm_loc_block.address_id FK_civicrm_loc_block_address_id N
Unique Address ID
contact_id int unsigned 10  √  null FK_civicrm_address_contact_id C
FK to Contact ID
location_type_id int unsigned 10  √  null Which Location does this address belong to.
is_primary tinyint 3  √  0 Is this the primary address.
is_billing tinyint 3  √  0 Is this the billing address.
street_address varchar 96  √  null Concatenation of all routable street address components (prefix, street number, street name, suffix, unit
number OR P.O. Box). Apps should be able to determine physical location with this data (for mapping, mail
delivery, etc.).
street_number int 10  √  null Numeric portion of address number on the street, e.g. For 112A Main St, the street_number = 112.
street_number_suffix varchar 8  √  null Non-numeric portion of address number on the street, e.g. For 112A Main St, the street_number_suffix = A
street_number_predirectional varchar 8  √  null Directional prefix, e.g. SE Main St, SE is the prefix.
street_name varchar 64  √  null Actual street name, excluding St, Dr, Rd, Ave, e.g. For 112 Main St, the street_name = Main.
street_type varchar 8  √  null St, Rd, Dr, etc.
street_number_postdirectional varchar 8  √  null Directional prefix, e.g. Main St S, S is the suffix.
street_unit varchar 16  √  null Secondary unit designator, e.g. Apt 3 or Unit # 14, or Bldg 1200
supplemental_address_1 varchar 96  √  null Supplemental Address Information, Line 1
supplemental_address_2 varchar 96  √  null Supplemental Address Information, Line 2
supplemental_address_3 varchar 96  √  null Supplemental Address Information, Line 3
city varchar 64  √  null City, Town or Village Name.
county_id int unsigned 10  √  null FK_civicrm_address_county_id N
Which County does this address belong to.
state_province_id int unsigned 10  √  null FK_civicrm_address_state_province_id N
Which State_Province does this address belong to.
postal_code_suffix varchar 12  √  null Store the suffix, like the +4 part in the USPS system.
postal_code varchar 12  √  null Store both US (zip5) AND international postal codes. App is responsible for country/region appropriate
usps_adc varchar 32  √  null USPS Bulk mailing code.
country_id int unsigned 10  √  null FK_civicrm_address_country_id N
Which Country does this address belong to.
geo_code_1 double 22  √  null Latitude
geo_code_2 double 22  √  null Longitude
manual_geo_code tinyint 3  √  0 Is this a manually entered geo code
timezone varchar 8  √  null Timezone expressed as a UTC offset - e.g. United States CST would be written as "UTC-6".
name varchar 255  √  null
master_id int unsigned 10  √  null FK_civicrm_address_master_id N
FK to Address ID

Table contained 187 rows at Wed Nov 11 17:12 EST 2015

Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
contact_id Performance Asc FK_civicrm_address_contact_id
country_id Performance Asc FK_civicrm_address_country_id
county_id Performance Asc FK_civicrm_address_county_id
master_id Performance Asc FK_civicrm_address_master_id
state_province_id Performance Asc FK_civicrm_address_state_province_id
city Performance Asc index_city
is_billing Performance Asc index_is_billing
is_primary Performance Asc index_is_primary
location_type_id Performance Asc index_location_type
street_name Performance Asc index_street_name

Close relationships  within of separation: