Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | serial | 10 | √ | nextval('private_ci2027_001.deadwood_id_seq'::regclass) |
|
|
Primary Key |
||||
| plot_id | int4 | 10 | null |
|
|
Foreign Key to plot |
|||||
| created_at | timestamp | 29,6 | CURRENT_TIMESTAMP |
|
|
||||||
| modified_at | timestamp | 29,6 | √ | null |
|
|
|||||
| modified_by | regrole | 2147483647 | √ | (CURRENT_USER)::regrole |
|
|
|||||
| tree_species_group | "private_ci2027_001"."enum_tree_species_group" | 2147483647 | √ | null |
|
|
Baumartengruppe für Totholz |
||||
| dead_wood_type | "private_ci2027_001"."enum_dead_wood_type" | 2147483647 | √ | null |
|
|
Todholztyp |
||||
| decomposition | "private_ci2027_001"."enum_decomposition" | 2147483647 | √ | null |
|
|
Zersetzungsgrad |
||||
| length_height | int2 | 5 | √ | null |
|
|
Länge / Höhe Totholz [dm] |
||||
| diameter_butt | "private_ci2027_001"."ck_bhd" | 10 | √ | null |
|
|
Durchmesser am dicken Ende [cm](liegende Bruchstücke); Schnittflächen- (Stöcke), Bhd (mit Wurzel, >=130 cm Länge) |
||||
| diameter_top | "private_ci2027_001"."ck_bhd" | 10 | √ | null |
|
|
Durchmesser am dünnen Ende [cm](nur bei liegenden Totholz OHNE Wurzelanlauf) |
||||
| count | int2 | 5 | √ | null |
|
|
Anzahl gleichartiger Totholzstücke |
||||
| bark_pocket | int2 | 5 | √ | null |
|
|
Rindentaschen > 500 cm² mit einer Mindestbreite von 10 cm (nur für stehendes Totholz) |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| deadwood_pkey | Primary key | Asc | id |