this article last updated: July 27, 2009 Due to inevitable changes that will be made to the shopping cart software over time, the cart's variable and database structure may change from time to time without advanced notice. We will attempt to keep the information in this article up-to-date, but Modular Merchant makes no guarantee as to the accuracy of the information provided in this article. Use this information at your own risk.
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
|