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

• id
  Primary Key of the table.
  int(10) | unsigned | auto increment | primary key | indexed
• tracking_number
  The tracking number for the order/shipment.
  varchar(255) | indexed
  
• create_date
  Date in which the tracking id was created.
  int(10) | unsigned | indexed
• active
  If set to a value greater than zero, then the tracking id is active. Inactive tracking id's are not displayed in the storefront.
  int(10) | unsigned | Values: 0/timestamp | Default: 0 | indexed