Database design » History » Version 4
Shuo Chen, 03/28/2014 10:22 PM
1 | 1 | Shuo Chen | Database Design |
---|---|---|---|
2 | =============== |
||
3 | |||
4 | ## Lists of Tables |
||
5 | |||
6 | * NDN_REPO |
||
7 | |||
8 | ## Specifics of Tables |
||
9 | |||
10 | ### NDN_REPO |
||
11 | |||
12 | 2 | Shuo Chen | #### Columns |
13 | 1 | Shuo Chen | |
14 | 3 | Shuo Chen | * name: tlv block name of the data packets. BLOB PRIMARY KEY |
15 | 2 | Shuo Chen | |
16 | 3 | Shuo Chen | * data: the whole TLV format data packets. BLOB |
17 | 2 | Shuo Chen | |
18 | 3 | Shuo Chen | * 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 |
19 | 2 | Shuo Chen | |
20 | 4 | Shuo Chen | * nChildren: 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 |
21 | 1 | Shuo Chen | |
22 | 2 | Shuo Chen | #### Note |
23 | 1 | Shuo Chen | With name and pname, this table creates a prefix tree. |