Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
wood_number | int4 | 10 | null |
|
|
|||
bay | varchar | 50 | √ | null |
|
|
||
context | 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 |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
tbl_woodindex_old_pkey | Primary key | Asc | wood_number |
Diagram producer might be missing
No diagrams were produced please see application output for any errors