|
this article last updated: July 1, 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 product_status database table.
- id
Primary Key of the table.
int(10) | unsigned | auto increment | primary key | indexed
- name
The display name of the product status.
varchar(255) | indexed
- purchasable
Products with a status in which the purchasable field contains a value greater than zero will be displayed in the storefront and may be purchased by customers. Store administrators may still place orders for products that are not purchasable. Scheduled Orders may also contain products that are not purchasable.
int(10) | unsigned | Values: 0/timestamp | Default: 1
- editable
Product status entries that are not editable (set to 0) are used by the system, and cannot be edited in the store's administration area.
int(10) | unsigned | Values: 0/timestamp | Default: 1
- memo
A description of the product_status that may be displayed to customers in certain circumstances.
text
- notes
Internal-only notes about this product status that are never displayed to the customer.
text
|
