Project

General

Profile

Database design » History » Revision 2

Revision 1 (Shuo Chen, 03/26/2014 06:06 PM) → Revision 2/5 (Shuo Chen, 03/26/2014 06:07 PM)

Database Design 
 =============== 

 ## Lists of Tables 

 * NDN_REPO 

 ## Specifics of Tables 

 ### NDN_REPO 

 #### Columns Columns: 

 *name: tlv block name of the data packets. BLOB PRIMARY KEY 

 
 *data: the whole TLV format data packets. BLOB 

 
 *pname: TLV format prefix of name with length of name - 1. For example, if name is /a/b/c, pname is /a/b. For root name /, its pname is NULL. BLOB 

 
 *childnum: the number of direct children of name. For example, there are row names: /a/b, /a/b/c, /a/b/d, /a/b/c/d. The childnum of /a/b is 2, childnum of /a/b/c is 1, childnum of /a/b/d and /a/b/c/d is 0. INTEGER 

 #### Note Note: 
 With name and pname, this table creates a prefix tree.