Project

General

Profile

Database design » History » Revision 4

Revision 3 (Shuo Chen, 03/26/2014 06:07 PM) → Revision 4/5 (Shuo Chen, 03/28/2014 10:22 PM)

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

 ## Lists of Tables 

 * NDN_REPO 

 ## Specifics of Tables 

 ### NDN_REPO 

 

 #### 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 

 * nChildren: 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 
 With name and pname, this table creates a prefix tree.