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 |
|
|
||||
worked_wood_assess_notes | text | 2147483647 | √ | null |
|
|
||||
number_of_rings | text | 2147483647 | √ | null |
|
|
||||
the_geom | geometry | 2147483647 | √ | null |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
tbl_woodindex_pkey | Primary key | Asc | wood_number |
tbl_woodindex_wood_number_key | Must be unique | Asc | wood_number |