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
|
