Database design » History » Version 1
Shuo Chen, 03/26/2014 06:06 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 | Columns: |
||
| 13 | |||
| 14 | *name: tlv block name of the data packets. BLOB PRIMARY KEY |
||
| 15 | *data: the whole TLV format data packets. BLOB |
||
| 16 | *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 |
||
| 17 | *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 |
||
| 18 | |||
| 19 | Note: |
||
| 20 | With name and pname, this table creates a prefix tree. |