|
this article last updated: May 17, 2010 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 admin_activity database table.
- id
Primary Key of the table.
int(10) | unsigned | auto increment | primary key | indexed
- user_type
Specifies what type of user, the account activity entry was made by.
varchar(1) | indexed | values: A (admin) / C (customer)
- user_id
Reference to the admin.id field.
int(10) | unsigned | indexed
- object_type
Is the specific page in which the change took place.
varchar(255) | indexed
- object_id
Reference to the database table in which was modified.
int(10) | unsigned | indexed
- action
The specific action that took place for this account activity entry.
varchar(255) | indexed
- date
Unix timestamp of the date the database entry was recorded.
int(10) | unsigned | indexed
- source_file
The filename in which the action recorded originated from.
varchar(255) | indexed
- description
Description of the recorded activity. Should be as descriptive as possible, but is limited to 255 characters.
varchar(255) | indexed
|
