This article outlines the database structure for the MMv4 zone_fee database table.

• id
  Primary Key of the table.
  int(10) | unsigned | auto increment | primary key | indexed
  
• name
  The name of the zone fee. This name is displayed only within the store's administration area.
  varchar(255) | indexed
  
• active
  If this field contains a value greater than zero, then the zone fee is active. Only active zone fee rules are applied to customer orders.
  int(10) | unsigned | Values: 0/timestamp | Default: 1 | indexed
• and_or
  Determines whether all or any of zone fee's zones must match the customer's geographic location.
  For example, if a zone fee uses the zones California and United States, setting it to "and" would only apply it to customers with California selected as their state and United States selected as their country. If set to "or", then it would be applied to customers with either California selected as their state or United States selected as their country.
  char(1) | values: O,A | default: O
• value
  The value of the zone fee. The value may represent either a dollar value or percentage, depending of the value of the "type" field. The value field may have up to three decimal places. Example: 1.234.
  double(15,3)
  
• type
  If set to "P", then the zone fee is calculated as a percentage. If set to "D", then it is calculated as a dollar value.
  char(1) | values: P,D | default: P
  
• notes
  Internal notes about the zone fee. These notes are displayed only within the store's administration area.
  text