Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
wood_number | int4 | 10 | √ | null |
|
|
||
bay | varchar | 50 | √ | null |
|
|
||
context | int4 | 10 | √ | null |
|
|
||
context_group | int4 | 10 | √ | null |
|
|
||
structural_group | int4 | 10 | √ | null |
|
|
||
length_in_mm | int4 | 10 | √ | null |
|
|
||
diameter_width_thickness_in_mm | int4 | 10 | √ | null |
|
|
||
altered | bool | 1 | √ | null |
|
|
||
burnt | bool | 1 | √ | null |
|
|
||
coppice_spur | bool | 1 | √ | null |
|
|
||
attitude_from_horizontal | varchar | 50 | √ | null |
|
|
||
dendro | bool | 1 | √ | null |
|
|
||
assessed_for_dendro | bool | 1 | √ | null |
|
|
||
species_sample | bool | 1 | √ | null |
|
|
||
condition_after_lifting | varchar | 50 | √ | null |
|
|
||
photo_number | varchar | 255 | √ | null |
|
|
||
initials_of_lifter | varchar | 50 | √ | null |
|
|
||
notes | text | 2147483647 | √ | null |
|
|
||
species | varchar | 50 | √ | null |
|
|
||
round_wood | bool | 1 | √ | null |
|
|
||
root_wood | bool | 1 | √ | null |
|
|
||
fragment | bool | 1 | √ | null |
|
|
||
species_id_notes | varchar | 50 | √ | null |
|
|
||
id_for_species | bool | 1 | √ | null |
|
|
||
worked_wood_assess_notes | text | 2147483647 | √ | null |
|
|
||
number_of_rings | text | 2147483647 | √ | null |
|
|
||
entity | _varchar | 50 | √ | null |
|
|