Project

General

Profile

Database design » History » Version 5

Shuo Chen, 04/03/2014 06:38 AM

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 5 Shuo Chen
* parentName: 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.