Big Tree Viewer Schema
Draft
Tables
tree
Name |
Type |
Description |
---|---|---|
tree_id |
integer |
Unique id for tree |
root_id |
integer |
Id of root node |
name |
varchar |
Name of tree |
node
Name |
Type |
Description |
---|---|---|
node_id |
integer |
Unique id for node |
label |
varchar |
Label for node |
topology
Name |
Type |
Description |
---|---|---|
node_id |
integer |
Id of this node |
parent_id |
integer |
Id of the parent node |
tree_id |
integer |
Id of the tree that the node belongs to |
LeftNode |
integer |
Index of the first visit to the node in a two-visit depth-first traversal of the tree. This visit happens before any children are visited. Nodes in the same tree with a (left or right) index greater than this and less than the RightNode are descendants of this node. |
RightNode |
integer |
Index of last visit to the node in a two-visit depth-first traversal of the tree. This visit happens after any children are visited. Nodes in the same tree with a (left or right) index less than this and greater than the LeftNode are descendants of this node. |
depth |
integer |
Depth from the root |
height |
integer |
Height from the node's deepest leaf descendant |
NumChildren |
integer |
Number of children |
NumLeaves |
integer |
Number of descendants that are leaves |
NumNodes |
integer |
Number of all descendant nodes |
node_layout
This table contains the x,y position and bounding box information for each node.
Name |
Type |
Description |
---|---|---|
node_id |
integer |
Id of the node |
tree_id |
integer |
Id of the tree |
layout_id |
varchar |
Layout id (ie, Cladogram or Circular) |
point |
geometry |
PostGIS geometry of the point (x,y) position |
bounding_box |
geometry |
PostGIS geometry containing the bounding box of the node |
overview_images
This table contains path to images to use for the overview image.
Name |
Type |
Description |
---|---|---|
tree_id |
integer |
Tree id |
layout_id |
varchar |
Layout id |
image_width |
integer |
Width of image |
image_height |
integer |
Height of image |
image_path |
varchar |
Path to image on disk |
node_label_lookup
This table contains a lookup for alternative labels for nodes. This is used to display a label next to triangles if the internal node does not have a label. This table is populated during loading of the tree with the first child label.
Name |
Type |
Description |
---|---|---|
node_id |
integer |
Id of the node |
alt_label |
varchar |
Alternative label for this node |