This article outlines the database structure for the MMv4 event_info database table.
- id
Primary Key of the table.
int(10) | unsigned | auto increment | primary key | indexed
- active
Whether this event is active or not.
int(10) | unsigned | indexed
- is_public
Whether this event will be visible in the storefront or not.
int(10) | unsigned | indexed
- display_order
The number of the order this event will be displayed in the storefront.
int(10) | unsigned | indexed
- name
The descriptive name of the event.
varchar(255) | indexed
- start_date
The date in which this event will start.
int(10) | unsigned | indexed
- end_date
The date in which this event will end.
int(10) | unsigned | indexed
- coupon_code
A comma separated list of all the coupon codes this event is associated with.
varchar(255) | indexed
- match_type
The match type for this event's rules. Any or All.
varchar(3) | indexed| default: all
- redeem_limit
The number of times this event can be used or redeemed.
int(10) | unsigned | indexed
- reusable
Whether this event is reusable or not, used for coupon codes.
int(10) | unsigned | indexed
- retain_balance
Whether this event will retain the balance remaining, or not.
int(10) | unsigned | indexed
- description
The description for this event.
text
|
