This article outlines the database structure for the MMv4 note database table.
- id
Primary Key of the table.
int(10) | unsigned | auto increment | primary key | indexed
- admin_id
Reference to the admin.id that this item is associated with.
int(10) | unsigned | indexed
- object_id
Reference to the primary key of the database table specified in the object_type
int(10) | unsigned | indexed
- object_type
The database table in which the note is associated with.
varchar(255) | indexed
- create_date
The date in which this note was created.
int(10) | unsigned | indexed
- content
The contents of the note.
text
|
