memorable2

memorable2 — Clustered. Stores metadata for entries users mark as "Memories".

memorable2

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