plot

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('private_ci2027_001.plot_id_seq'::regclass)
deadwood.plot_id fk_deadwood_plot C
edges.plot_id fk_edges_plot C
plot_location.plot_id fk_plot_location_plot_id C
position.plot_id fk_position_plot C
sapling_1m.plot_id fk_saplings1m_plot C
sapling_2m.plot_id fk_saplings2m_plot C
wzp_tree.plot_id fk_wzptree_plot C
cluster_id int4 10 null
cluster.id fk_plot_cluster C
created_at timestamp 29,6 CURRENT_TIMESTAMP
modified_at timestamp 29,6 √ null
modified_by regrole 2147483647 √ (CURRENT_USER)::regrole
interval_name "private_ci2027_001"."enum_interval_name" 2147483647 'ci2027'::private_ci2027_001.enum_interval_name
plot_name "private_ci2027_001"."ck_plot_name" 5 null
sampling_strata "private_ci2027_001"."enum_sampling_strata" 2147483647 null
lookup_sampling_strata.abbreviation fk_plot_samplingstrata R
state_administration "private_ci2027_001"."enum_state" 2147483647 null
state_collect "private_ci2027_001"."enum_state" 2147483647 null
geometry geometry 2147483647 √ null
growth_district int4 10 √ null
lookup_growth_district.abbreviation fk_plot_lookupgrowthdistrict R
forest_decision "private_ci2027_001"."enum_forest_decision" 2147483647 √ null
lookup_forest_decision.abbreviation fk_plot_lookupforestdecision R
accessibility int2 5 √ null
forestry_department int2 5 √ null
lookup_forestry_department.abbreviation fk_plot_lookupforestrydepartment R
height_layer_class "private_ci2027_001"."enum_height_layer_class" 2147483647 √ null
lookup_height_layer_class.abbreviation fk_plot_lookupheightlayerclass R
property_type "private_ci2027_001"."enum_property_type" 2147483647 √ null
lookup_property_type.abbreviation fk_plot_lookuppropertytype R
property_size_class "private_ci2027_001"."enum_property_size_class" 2147483647 √ null
lookup_property_size_class.abbreviation fk_plot_lookuppropertysizeclass R
forest_type "private_ci2027_001"."enum_forest_type" 2147483647 √ null
lookup_forest_type.abbreviation fk_plot_lookupforesttype R
habitat_type "private_ci2027_001"."enum_habitat_type" 2147483647 √ null
lookup_habitat_type.abbreviation fk_plot_lookuphabitattype R
habitat_type_source "private_ci2027_001"."enum_habitat_type_source" 2147483647 √ null
lookup_habitat_type_source.abbreviation fk_plot_lookuphabitattypesource R
use_restriction "private_ci2027_001"."enum_use_restriction" 2147483647 √ null
lookup_use_restriction.abbreviation fk_plot_lookupuserestriction R
land_use "private_ci2027_001"."enum_land_use" 2147483647 √ null
lookup_land_use.abbreviation fk_plot_lookuplanduse R
coast bool 1 false
sandy bool 1 false
conservation_area bool 1 false
histwald bool 1 false
use_restriction_reasons "private_ci2027_001"."_enum_use_restriction_reason" 2147483647 '{}'::private_ci2027_001.enum_use_restriction_reason[]
landmark_azimuth "private_ci2027_001"."ck_gon" 5 √ null
landmark_distance int2 5 √ null
landmark_note varchar 12 √ null
marking_state "private_ci2027_001"."enum_marking_state" 2147483647 null
lookup_marking_state.abbreviation fk_plot_lookupmarkingstate R
marking_azimuth "private_ci2027_001"."ck_gon" 5 √ null
marking_distance int2 5 √ null
marking_profile "private_ci2027_001"."enum_marking_profile" 2147483647 √ null
lookup_marking_profile.abbreviation fk_plot_lookupmarkingprofile R
terrain_form "private_ci2027_001"."enum_terrain_form" 2147483647 √ null
lookup_terrain_form.abbreviation fk_plot_lookupterrainform R
terrain_slope "private_ci2027_001"."ck_slope_degree" 5 √ null
terrain_exposure "private_ci2027_001"."ck_gon" 5 √ null
management_type "private_ci2027_001"."enum_management_type" 2147483647 √ null
lookup_management_type.abbreviation fk_plot_lookupmanagementtype R
harvesting_method "private_ci2027_001"."enum_harvesting_method" 2147483647 null
lookup_harvesting_method.abbreviation fk_plot_lookupharvestingmethod R
biotope "private_ci2027_001"."ck_biotope" 5 √ null
layer_type "private_ci2027_001"."enum_layer_type" 2147483647 √ null
lookup_layer_type.abbreviation fk_plot_lookuplayertype R
stand_age "private_ci2027_001"."ck_stand_age" 5 √ null
stand_phase "private_ci2027_001"."enum_stand_phase" 2147483647 √ null
lookup_stand_phase.abbreviation fk_plot_lookupstandphase R
sablings_layer "private_ci2027_001"."enum_stand_layer" 2147483647 √ null
lookup_stand_layer.abbreviation fk_plot_lookupstandlayer R
sablings_fence bool 1 √ false
trees_less_4meter_mirrored "private_ci2027_001"."enum_trees_less_4meter_mirrored" 2147483647 √ null
lookup_trees_less_4meter_mirrored.abbreviation fk_plot_lookuptreesless4metermirrored R
trees_less_4meter_count_factor "private_ci2027_001"."enum_trees_less_4meter_count_factor" 2147483647 √ null
lookup_trees_less_4meter_count_factor.abbreviation fk_plot_lookuptreesless4metercountfactor R
trees_less_4meter_coverage int2 5 √ null
trees_less_4meter_layer "private_ci2027_001"."enum_trees_less_4meter_layer" 2147483647 √ null
lookup_trees_less_4meter_layer.abbreviation fk_plot_lookuptreesless4meterlayer R

Indexes

Constraint Name Type Sort Column(s)
plot_pkey Primary key Asc id
fk_plot_cluster_unique Must be unique Asc/Asc cluster_id + plot_name

Relationships

Close relationships within degrees of separation