“mail” table

The mail table holds TODO

Table structure

Field Type Null Key Default Extra
id int(11) unsigned NO PRI 0  
messageType tinyint(3) unsigned NO   0  
stationery tinyint(3) NO   41  
mailTemplateId mediumint(8) unsigned NO   0  
sender int(11) unsigned NO   0  
receiver int(11) unsigned NO MUL 0  
subject longtext YES   NULL  
itemTextId int(11) unsigned NO   0  
has_items tinyint(3) unsigned NO   0  
expire_time bigint(40) unsigned NO   0  
deliver_time bigint(40) unsigned NO   0  
money int(11) unsigned NO   0  
cod int(11) unsigned NO   0  
checked tinyint(3) unsigned NO   0  

Fields

id

messageType

stationery

mailTemplateId

sender

receiver

subject

itemTextId

has_items

expire_time

deliver_time

money

cod

checked