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
regeneration.plot_id fk_saplings2m_plot C
structure_lt4m.plot_id fk_structurelt4m_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_stratum int4 10 null
state "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_status "private_ci2027_001"."enum_forest_status" 2147483647 √ null
lookup_forest_status.abbreviation fk_plot_lookupforeststatus R
accessibility int2 5 √ null
forest_office int2 5 √ null
elevation_level "private_ci2027_001"."enum_elevation_level" 2147483647 √ null
lookup_elevation_level.abbreviation fk_plot_lookupelevationlevel 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_community text 2147483647 √ null
forest_community_field "private_ci2027_001"."enum_forest_community_field" 2147483647 √ null
ffh_forest_type text 2147483647 √ null
ffh_forest_type_field "private_ci2027_001"."enum_ffh_forest_type_field" 2147483647 √ null
land_use_before "private_ci2027_001"."enum_land_use" 2147483647 √ null
land_use_after "private_ci2027_001"."enum_land_use" 2147483647 √ null
lookup_land_use.abbreviation fk_plot_lookuplanduse R
coast bool 1 false
sandy bool 1 false
protected_landscape bool 1 false
histwald bool 1 false
harvest_restriction int4 10 null
harvest_restriction_source _int4 10 '{}'::integer[]
landmark_azimuth "private_ci2027_001"."ck_gon" 5 √ null
landmark_distance int2 5 √ null
landmark_note varchar 12 √ null
marker_status "private_ci2027_001"."enum_marker_status" 2147483647 null
lookup_marker_status.abbreviation fk_plot_lookupmarkerstatus R
marker_azimuth "private_ci2027_001"."ck_gon" 5 √ null
marker_distance int2 5 √ null
marker_profile "private_ci2027_001"."enum_marker_profile" 2147483647 √ null
lookup_marker_profile.abbreviation fk_plot_lookupmarkerprofile 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
stand_structure "private_ci2027_001"."enum_stand_structure" 2147483647 √ null
lookup_stand_structure.abbreviation fk_plot_lookupstandstructure R
stand_age "private_ci2027_001"."ck_stand_age" 5 √ null
stand_dev_phase "private_ci2027_001"."enum_stand_dev_phase" 2147483647 √ null
lookup_stand_dev_phase.abbreviation fk_plot_lookupstanddevphase R
stand_layer_reg "private_ci2027_001"."enum_stand_layer" 2147483647 √ null
lookup_stand_layer.abbreviation fk_plot_lookupstandlayer R
fence_reg 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_basal_area_factor "private_ci2027_001"."enum_trees_less_4meter_count_factor" 2147483647 √ null
trees_less_4meter_coverage int2 5 √ null
trees_less_4meter_layer "private_ci2027_001"."enum_trees_less_4meter_layer" 2147483647 √ null

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