memorable

memorable — Stores metadata for entries users mark as "Memories". Please see also the clustered memorable2 table.

memorable

Column name Type Null Default Description
memid int unsigned auto_increment    
userid int unsigned   0  
journalid int unsigned   0  
jitemid int unsigned   0  
des varchar(150)    
security enum('public','friends','private')   public  
Key name Type Column(s)
PRIMARY PRIMARY
item INDEX
uniq UNIQUE