civicrm_address


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 null
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
civicrm_contact.id 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
civicrm_county.id FK_civicrm_address_county_id N

Which County does this address belong to.

state_province_id INT UNSIGNED 10 null
civicrm_state_province.id 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 64 null
usps_adc VARCHAR 32 null

USPS Bulk mailing code.

country_id INT UNSIGNED 10 null
civicrm_country.id 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
civicrm_address.id FK_civicrm_address_master_id N

FK to Address ID

Table contained 13 rows

Indexes

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

Relationships