Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | int8 | 19 | null |
|
|
|||||
| tree_id | int8 | 19 | null |
|
|
Foreign key ID of the tree the branch belongs to. The tree must have growth form “Tree”. |
||||
| branch_number | int4 | 10 | null |
|
|
A system-assigned incremental number starting at 1 for accounting branches. |
||||
| diameter_at_breast_height_cm | numeric | 131089 | null |
|
|
|||||
| point_of_measurement_m | numeric | 131089 | null |
|
|
|||||
| is_dead | bool | 1 | null |
|
|
|||||
| description | text | 2147483647 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| recorded_branches_pkey | Primary key | Asc | id |
| recorded_branches_tree_id_branch_number_key | Must be unique | Asc/Asc | tree_id + branch_number |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| recorded_branches_diameter_at_breast_height_cm_check | ((diameter_at_breast_height_cm >= (0)::numeric)) |
| recorded_branches_point_of_measurement_m_check | ((point_of_measurement_m >= (0)::numeric)) |
| recorded_branches_branch_number_check | ((branch_number >= 1)) |