Skip to content

mail_items Table

Items attached to mails (moved out of mail for performance).


Schema Summary

Field Type Key Null Default Extra
mail_id int(11) unsigned PRI NO 0
item_guid int(11) unsigned PRI NO 0
item_id int(11) unsigned NO 0
receiver_guid int(11) unsigned MUL NO 0

Field Breakdown

  • mail_id - Primary Key. Parent mail.
  • item_guid - Primary Key. Attached item (item_instance.guid).
  • item_id - Item template entry of the attached item (item_template.entry).
  • receiver_guid - Recipient snapshot for integrity checks.