This article outlines the database structure for the MMv4 customer_ship_addr database table. This table contains the shipping addresses associated with customer accounts. A customer account may have any number of shipping addresses associated with it, including zero.

• id
  Primary Key of the table.
  int(10) | unsigned | auto increment | primary key | indexed
• cid
  A reference to the customer.id field associated with this shipping address record.
  int(10) | unsigned | indexed
• ship_first_name
  The first name associated with the customer's shipping address.
  varchar(255) | indexed
• ship_last_name
  The last name associated with the customer's shipping address.
  varchar(255) | indexed
• ship_address_1
  The first line of the shipping address associated with the customer's account. Note: The name of this field has been changed from "ship_address1" in MMv3.
  varchar(255) | indexed
• ship_address_2
  The second line of the shipping address associated with the customer's account. Note: The name of this field has been changed from "ship_address2" in MMv3.
  varchar(255) | indexed
• ship_city
  The city associated with the customer's shipping address.
  varchar(255) | indexed
• ship_state
  The two-character ISO code of the state associated with the customer's shipping address, followed by the two-character ISO code of the country. For example, Oregon would be recorded as: OR_US.
  varchar(255) | indexed
• ship_zip
  The zip/postal code associated with the customer's shipping address.
  varchar(255) | indexed
• ship_country
  The two-character ISO code of the country associated with the customer's shipping address.
  varchar(255) | indexed