Database design » History » Version 3
Shuo Chen, 03/26/2014 06:07 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 | 3 | Shuo Chen | * 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 |
| 21 | 1 | Shuo Chen | |
| 22 | 2 | Shuo Chen | #### Note |
| 23 | 1 | Shuo Chen | With name and pname, this table creates a prefix tree. |