Columns

Columns

Table Type Column Type Size Nulls Auto Default Comments
lut_landform_element Table description text 2147483647 null
site_location Table outcrop_lithology varchar 2147483647 'NC'::character varying
lut_soil_tex_grade Table bolus_description text 2147483647 null
lut_lithology Table rock_type varchar 2147483647 null
lut_erosion_state Table id text 2147483647 null
SiteVisit_Vouchers_and_Determinations View visit_start_date timestamp 29 null
soil_subsite_observations Table metagenomics_are_available bool 1 null
soils_file_uploads Table site_location_id int4 10 null
SiteVisit_Vouchers_and_Determinations View herbarium_determination text 2147483647 null
lut_ibra Table bioregion_description text 2147483647 null
soil_characterisation Table ec float8 17 null
All_Broken_PI_Points View in_canopy_sky bool 1 null
herbarium_determination Table herbarium_determination text 2147483647 null
site_location Table plot_is_aligned_to_grid bool 1 true
lut_seg_abundance Table id text 2147483647 null
lut_substrate Table description text 2147483647 null
lut_landform_pattern Table landform_pattern text 2147483647 null
All Point Intercept Points for a Plot View in_canopy_sky bool 1 null
lut_pedality_fabric Table id text 2147483647 null
site_location_visit Table site_visit_photo_name varchar 2147483647 null
site_location Table app_long varchar 2147483647 null
lut_coarse_frag_shape Table type text 2147483647 null
lut_basal_point Table point_id text 2147483647 nextval('lut_basal_point_point_id_seq'::regclass)
lut_substrate Table substrate text 2147483647 null
lut_mottle_size Table id text 2147483647 null
All Point Intercept Points for a Plot View substrate varchar 2147483647 null
soil_characterisation Table next_size_2 text 2147483647 null
SiteVisit_Vouchers_and_Determinations View veg_barcode text 2147483647 null
lut_pedality_type Table pedality_type text 2147483647 null
site_location_visit Table basal_wedge_has_been_collected bool 1 false
photopoints Table photopoint_long_2 text 2147483647 null
basal_area Table basal_area float8 17 null
lut_surface_soil_cond Table id text 2147483647 null
soil_characterisation Table segregations_abundance text 2147483647 null
site_location_visit Table soil_observation_type text 2147483647 'P'::text
site_location Table app_lat varchar 2147483647 null
enter_determinations View determination_date timestamp 29 null
lut_surface_soil_cond Table condition text 2147483647 null
site_location_visit Table sample_location_comment varchar 2147483647 null
lut_growth_form Table definition text 2147483647 null
lut_erosion_type Table id text 2147483647 null
visit_surface_coarse_frags_abundance Table site_location_visit_id int4 10 null
herbarium_determination Table veg_barcode text 2147483647 null
dgps_file_uploads Table processed bool 1 null
lut_basal_point Table distance_from_sw_corner text 2147483647 null
lai Table site_location_visit_id int4 10 null
site_location Table landform_element varchar 2147483647 'NC'::character varying
site_location Table comments text 2147483647 null
site_location_visit Table observer_veg int4 10 13
soil_characterisation Table next_size_type_2 text 2147483647 null
lut_state Table state text 2147483647 null
lut_datum Table description_geoscience_australia text 2147483647 null
herbarium_sheet Table return_date timestamp 29 null
visit_surface_coarse_frags_type Table id serial 10 nextval('visit_surface_coarse_frags_type_id_seq'::regclass)
lut_observer Table affiliation varchar 2147483647 null
lut_seg_size Table id text 2147483647 null
soil_characterisation Table layer_barcode text 2147483647 null
soil_subsite_observations Table id serial 10 nextval('soil_subsite_observations_id_seq'::regclass)
site_location_point Table zone int4 10 null
visit_surface_coarse_frags_size Table site_location_visit_id int4 10 null
soil_bulk_density Table ring_volume float8 17 null
basal_area Table basal_area_factor float8 17 null
lut_soil_obs_type Table type text 2147483647 null
genetic_vouchers Table veg_barcode text 2147483647 null
soil_bulk_density Table gravel_bulk_density float8 17 null
characterisation_coarse_frags_abundance Table soil_characterisation_id int4 10 null
enter_determinations View determiner text 2147483647 null
lut_seg_form Table id text 2147483647 null
lut_microrelief Table description text 2147483647 null
soil_characterisation Table comments text 2147483647 null
site_location_visit Table visit_start_date timestamp 29 null
dgps_file_uploads Table site_location_id int4 10 null
site_location_visit Table vegetation_condition text 2147483647 null
soils_file_uploads Table file_path varchar 2147483647 null
lut_soil_tex_grade Table clay_content text 2147483647 null
herbarium_sheet Table follow_up_date timestamp 29 null
lut_datum Table datum text 2147483647 null
site_location_visit Table erosion_abundance text 2147483647 'NC'::text
lut_pedality_type Table description text 2147483647 null
basal_area Table hits int4 10 null
soil_bulk_density Table fine_earth_bulk_density float8 17 null
lut_soil_tex_grade Table code text 2147483647 null
soil_characterisation Table next_size_1 text 2147483647 null
soil_characterisation Table smallest_size_type_1 text 2147483647 null
lut_landform_element Table code text 2147483647 null
lut_landform_element Table landform_element text 2147483647 null
herbarium_determination Table specimen_stored_at varchar 2147483647 null
characterisation_coarse_frags_shape Table coarse_frag_shape_id text 2147483647 null
photopoints Table photopoint_long_3 text 2147483647 null
herbarium_sheet Table lodgement_date timestamp 29 null
soil_characterisation Table next_size_type_1 text 2147483647 null
genetic_vouchers Table primary_gen_barcode text 2147483647 null
site_location_visit Table distance_to_nearest_infrastructure int4 10 null
All Point Intercept Points for a Plot View growth_form varchar 2147483647 null
site_location_visit Table location_description text 2147483647 null
lut_drainage Table id int4 10 null
lut_datum Table equatorial_radius_in_m text 2147483647 null
structural_summary Table mass_flowering_event bool 1 null
lut_effervescence Table effervescence text 2147483647 null
genetic_vouchers Table genetic_barcode_analysis_url varchar 2147483647 null
lut_pedality_grade Table id text 2147483647 null
visit_surface_soil_conditions Table surface_soil_condition_id text 2147483647 null
site_location_visit Table described_by int4 10 13
point_intercept Table method varchar 2147483647 null
species_growth_forms Table species_name varchar 2147483647 null
site_location_visit Table distance_to_nearest_community int4 10 null
site_location_visit Table erosion_type text 2147483647 'NC'::text
lai Table completion_date_time timestamp 29 null
soils_file_uploads Table id serial 10 nextval('soils_file_uploads_id_seq'::regclass)
lut_erosion_abund Table abundance text 2147483647 null
characterisation_coarse_frags_lithology Table lithology_code varchar 2147483647 null
visit_surface_coarse_frags_lithology Table site_location_visit_id int4 10 null
soil_subsite_observations Table comments text 2147483647 null
lut_soil_tex_qual Table qualification text 2147483647 null
soil_characterisation Table horizon text 2147483647 null
visit_surface_coarse_frags_lithology Table id serial 10 nextval('visit_surface_coarse_frags_lithology_id_seq'::regclass)
lut_landform_pattern Table occasional_elements text 2147483647 null
structural_summary Table ground_1_dominant text 2147483647 null
All_Broken_PI_Points View substrate varchar 2147483647 null
herbarium_determination Table determiner_comment varchar 2147483647 null
soil_bulk_density Table fine_earth_volume float8 17 null
soil_characterisation Table mottles_abundance text 2147483647 null
soil_subsite_observations Table photo_url text 2147483647 null
site_location_visit Table disturbance text 2147483647 'NC'::text
soil_characterisation Table texture_qualifier text 2147483647 null
lut_structure_size Table id text 2147483647 null
structural_summary Table mid_2_dominant text 2147483647 null
lut_microrelief Table id text 2147483647 null
dets_file_uploads Table processed bool 1 null
site_location Table plot_dimensions varchar 2147483647 null
characterisation_coarse_frags_size Table soil_characterisation_id int4 10 null
lut_soil_tex_mod Table id text 2147483647 null
soil_characterisation Table texture_grade text 2147483647 null
characterisation_coarse_frags_lithology Table id serial 10 nextval('characterisation_coarse_frags_lithology_id_seq'::regclass)
site_location_point Table site_location_id int4 10 null
soil_characterisation Table smallest_size_type_2 text 2147483647 null
site_location_visit Table pit_marker_easting float8 17 null
site_location Table other_outcrop_lithology varchar 2147483647 null
site_location_visit Table pit_marker_mga_zones int4 10 null
veg_vouchers Table site_location_visit_id int4 10 null
lut_seg_nature Table id text 2147483647 null
lut_mottle_size Table size text 2147483647 null
site_location_visit Table comment_on_distance_to_community varchar 2147483647 null
herbarium_determination Table determiner text 2147483647 null
All_Broken_PI_Points View site_location_name varchar 2147483647 null
site_location_visit Table drainage_type int4 10 7
visit_surface_coarse_frags_abundance Table coarse_frag_abund_id text 2147483647 null
site_location Table paddock varchar 2147483647 null
lut_pedality_grade Table pedality text 2147483647 null
SiteVisit_Vouchers_and_Determinations View site_location_visit_id int4 10 null
lut_datum Table reference_spheroid text 2147483647 null
structural_summary Table id serial 10 nextval('structural_summary_id_seq'::regclass)
soil_characterisation Table segregations_size text 2147483647 null
soil_bulk_density Table site_location_visit_id int4 10 null
visit_surface_coarse_frags_abundance Table id serial 10 nextval('visit_surface_coarse_frags_abundance_id_seq'::regclass)
soils_file_uploads Table processed bool 1 null
lut_soil_tex_mod Table modifier text 2147483647 null
site_location_point Table northing float8 17 null
site_location_point Table id serial 10 nextval('site_location_point_id_seq'::regclass)
All_Broken_PI_Points View growth_form varchar 2147483647 null
soil_characterisation Table ph float8 17 null
site_location Table established_date timestamp 29 null
lut_pedality_grade Table grade text 2147483647 null
lut_seg_nature Table nature text 2147483647 null
characterisation_coarse_frags_shape Table soil_characterisation_id int4 10 null
lut_coarse_frag_size Table size text 2147483647 null
lut_erosion_state Table state text 2147483647 null
lut_pedality_fabric Table pedality_fabric text 2147483647 null
lut_ibra Table bioregion_name text 2147483647 null
lut_pedality_type Table id text 2147483647 null
enter_determinations View veg_barcode text 2147483647 null
SiteVisit_Vouchers_and_Determinations View site_location_name varchar 2147483647 null
lut_erosion_type Table erosion_type text 2147483647 null
herbarium_sheet Table state text 2147483647 null
genetic_vouchers Table site_location_visit_id int4 10 null
soil_subsite_observations Table twenty_to_thirty_barcode text 2147483647 null
All_Broken_PI_Points View transect varchar 2147483647 null
soil_characterisation Table pedality_fabric text 2147483647 null
lut_landform_pattern Table typical_elements text 2147483647 null
lut_soil_obs_type Table description text 2147483647 null
site_location_visit Table erosion_state text 2147483647 'NC'::text
lut_pedality_grade Table description text 2147483647 null
lut_seg_size Table size text 2147483647 null
soil_characterisation Table collected_by int4 10 null
site_location_point Table longitude float8 17 null
lut_observer Table full_name text 2147483647 null
soil_subsite_observations Table zero_to_ten_barcode text 2147483647 null
soil_subsite_observations Table observer int4 10 null
soil_subsite_observations Table zone int4 10 null
SiteVisit_Vouchers_and_Determinations View field_name text 2147483647 null
dets_file_uploads Table id serial 10 nextval('dets_file_uploads_id_seq'::regclass)
characterisation_coarse_frags_abundance Table coarse_frag_abund_id text 2147483647 null
characterisation_coarse_frags_size Table id varchar 2147483647 nextval('characterisation_coarse_frags_size_id_seq'::regclass)
lai Table id serial 10 nextval('lai_id_seq'::regclass)
lut_erosion_abund Table id text 2147483647 null
photopoints Table photopoint_long_1 text 2147483647 null
soil_characterisation Table segregations_form text 2147483647 null
site_location_point Table threedcq float8 17 null
photopoints Table photopoint_centre_peg_long text 2147483647 null
All Point Intercept Points for a Plot View method varchar 2147483647 null
photopoints Table photo_storage_location text 2147483647 null
photopoints Table completion_date_time timestamp 29 null
visit_surface_soil_conditions Table site_location_visit_id int4 10 null
lut_microrelief Table type text 2147483647 null
herbarium_sheet Table comments text 2147483647 null
veg_vouchers Table default_growth_form text 2147483647 null
lut_datum Table description text 2147483647 null
site_location_visit Table photopoints_exists bool 1 false
lut_landform_pattern Table compare_with text 2147483647 null
soil_bulk_density Table gravel_weight float8 17 null
lut_mottle_colour Table colour text 2147483647 null
point_intercept Table dead bool 1 null
site_location_point Table latitude float8 17 null
soil_characterisation Table pedality_grade text 2147483647 null
species_growth_forms Table growth_form varchar 2147483647 null
soil_characterisation Table colour_when_moist text 2147483647 null
lut_location_method Table location_tech_type varchar 2147483647 null
veg_vouchers Table field_name text 2147483647 null
site_location Table bioregion_name varchar 2147483647 null
All Point Intercept Points for a Plot View site_location_name varchar 2147483647 null
structural_summary Table ground_2_dominant text 2147483647 null
site_location_visit Table a_s_c text 2147483647 null
lut_bioregions Table abbreviation varchar 2147483647 null
lut_disturbance Table disturbance text 2147483647 null
soil_characterisation Table smallest_size_2 text 2147483647 null
veg_vouchers Table herbarium_sheet_id int4 10 null
point_intercept Table height float8 17 null
soil_subsite_observations Table metagenomic_barcode text 2147483647 null
visit_surface_coarse_frags_size Table id serial 10 nextval('visit_surface_coarse_frags_size_id_seq'::regclass)
site_location_visit Table visit_end_date timestamp 29 null
soil_bulk_density Table gravel_volume float8 17 null
lut_surface_strew_size Table size text 2147483647 null
soil_characterisation Table mottles_size text 2147483647 null
point_intercept Table in_canopy_sky bool 1 null
All Point Intercept Points for a Plot View height float8 17 null
soil_subsite_observations Table photo_no text 2147483647 null
herbarium_sheet Table herbarium_sheet_id serial 10 nextval('herbarium_sheet_herbarium_sheet_id_seq'::regclass)
site_location Table site_aspect varchar 2147483647 null
structural_summary Table mid_1_dominant text 2147483647 null
genetic_vouchers Table secondary_gen_barcode_4 text 2147483647 null
site_location Table site_location_name varchar 2147483647 null
lut_datum Table year_of_acceptance text 2147483647 null
enter_determinations View is_uncertain_determination bool 1 null
lut_basal_point Table point_name text 2147483647 null
lut_mottle_colour Table id text 2147483647 null
characterisation_coarse_frags_lithology Table soil_characterisation_id int4 10 null
soil_subsite_observations Table site_location_visit_id int4 10 null
lut_soil_tex_qual Table id text 2147483647 null
soil_subsite_observations Table subsite_id text 2147483647 null
dets_file_uploads Table file_path varchar 2147483647 null
lut_mga_zone Table eastern_boundary text 2147483647 null
photopoints Table id serial 10 nextval('photopoints_id_seq'::regclass)
site_location_visit Table pit_marker_datum text 2147483647 null
All_Broken_PI_Points View point_number int4 10 null
lut_drainage Table drainage text 2147483647 null
visit_surface_coarse_frags_size Table coarse_frag_size_id text 2147483647 null
photopoints Table photopoint_lat_1 text 2147483647 null
genetic_vouchers Table secondary_gen_barcode_1 text 2147483647 null
lut_lithology Table code varchar 2147483647 null
basal_area Table id serial 10 nextval('basal_area_id_seq'::regclass)
lut_mga_zone Table datum text 2147483647 null
site_location_visit Table pit_marker_northing float8 17 null
site_location Table plot_is_permanently_marked bool 1 true
site_location_visit Table visit_notes text 2147483647 null
point_intercept Table point_number int4 10 null
lut_soil_tex_grade Table name text 2147483647 null
site_location_visit Table pit_marker_location_method text 2147483647 null
site_location_visit Table site_location_id int4 10 null
structural_summary Table phenology_comment text 2147483647 null
structural_summary Table mid_3_dominant text 2147483647 null
lut_seg_abundance Table abundance text 2147483647 null
lut_mottle_abund Table id text 2147483647 null
lut_coarse_frag_abund Table id text 2147483647 null
basal_area Table veg_barcode text 2147483647 null
lut_landform_pattern Table id text 2147483647 null
lut_datum Table inverse_flattening text 2147483647 null
site_location Table landform_pattern varchar 2147483647 'NC'::character varying
soil_characterisation Table upper_depth float8 17 null
herbarium_determination Table is_uncertain_determination bool 1 null
point_intercept Table site_location_visit_id int4 10 null
site_location_visit Table climatic_condition text 2147483647 null
All_Broken_PI_Points View height float8 17 null
site_location_visit Table observer_soil int4 10 13
site_location_point Table point text 2147483647 null
characterisation_coarse_frags_abundance Table id varchar 2147483647 nextval('characterisation_coarse_frags_abundance_id_seq'::regclass)
soil_bulk_density Table fine_earth_weight float8 17 null
lut_soil_obs_type Table id text 2147483647 null
structural_summary Table ground_3_dominant text 2147483647 null
genetic_vouchers Table secondary_gen_barcode_3 text 2147483647 null
soil_characterisation Table id serial 10 nextval('soil_characterisation_id_seq'::regclass)
lut_structure_size Table size text 2147483647 null
soil_bulk_density Table ring_weight float8 17 null
lut_drainage Table description text 2147483647 null
site_location_visit Table leaf_area_index_exists bool 1 false
visit_surface_coarse_frags_type Table site_location_visit_id int4 10 null
site_location_visit Table ok_to_publish bool 1 false
enter_determinations View field_name text 2147483647 null
site_location_visit Table comment_on_distance_to_infrastructure varchar 2147483647 null
lut_basal_point Table notes text 2147483647 null
soil_characterisation Table effervescence text 2147483647 null
All Point Intercept Points for a Plot View transect varchar 2147483647 null
soil_characterisation Table texture_modifier text 2147483647 null
dgps_file_uploads Table file_path varchar 2147483647 null
herbarium_sheet Table family varchar 2147483647 null
photopoints Table site_location_visit_id int4 10 null
SiteVisit_Vouchers_and_Determinations View is_uncertain_determination bool 1 null
lut_state Table description text 2147483647 null
lut_bioregions Table name varchar 2147483647 null
lut_disturbance Table id text 2147483647 null
visit_surface_coarse_frags_lithology Table lithology_code varchar 2147483647 null
All Point Intercept Points for a Plot View veg_barcode varchar 2147483647 null
structural_summary Table upper_3_dominant text 2147483647 null
visit_surface_soil_conditions Table id serial 10 nextval('visit_surface_soil_conditions_id_seq'::regclass)
lut_landform_pattern Table common_elements text 2147483647 null
basal_area Table site_location_visit_id int4 10 null
soil_subsite_observations Table metagenomic_url varchar 2147483647 null
genetic_vouchers Table secondary_gen_barcode_2 text 2147483647 null
soil_subsite_observations Table easting int4 10 null
point_intercept Table transect varchar 2147483647 null
site_location_visit Table microrelief text 2147483647 'NC'::text
site_location Table property varchar 2147483647 null
lut_mga_zone Table mga_zone int4 10 null
photopoints Table photopoint_lat_2 text 2147483647 null
genetic_vouchers Table tea_bag_is_synthetic text 2147483647 null
site_location Table plot_is_100m_by_100m bool 1 true
lut_effervescence Table id text 2147483647 null
soil_characterisation Table segregations_nature text 2147483647 null
structural_summary Table upper_2_dominant text 2147483647 null
characterisation_coarse_frags_size Table coarse_frag_size_id text 2147483647 null
soil_characterisation Table colour_when_dry text 2147483647 null
lut_mottle_abund Table abundance text 2147483647 null
site_location_visit Table site_location_visit_id serial 10 nextval('site_location_visit_site_location_visit_id_seq'::regclass)
herbarium_determination Table determination_date timestamp 29 null
lut_landform_pattern Table description text 2147483647 null
photopoints Table photopoint_lat_3 text 2147483647 null
site_location Table surface_strew_lithology varchar 2147483647 null
enter_determinations View site_location_visit_id int4 10 null
point_intercept Table veg_barcode varchar 2147483647 null
veg_vouchers Table veg_barcode text 2147483647 null
soil_bulk_density Table sample_id text 2147483647 null
soil_subsite_observations Table northing int4 10 null
soil_bulk_density Table oven_dried_weight_in_bag float8 17 null
dgps_file_uploads Table id serial 10 nextval('dgps_file_uploads_id_seq'::regclass)
lut_coarse_frag_size Table id text 2147483647 null
structural_summary Table description text 2147483647 null
point_intercept Table id serial 10 nextval('point_intercept_id_seq'::regclass)
herbarium_sheet Table herbarium_sheet_name text 2147483647 null
soil_bulk_density Table id serial 10 nextval('soil_bulk_density_id_seq'::regclass)
lai Table location_of_lai_data text 2147483647 null
site_location Table site_location_id serial 10 nextval('site_location_site_location_id_seq'::regclass)
genetic_vouchers Table sample_for_dna text 2147483647 null
All Point Intercept Points for a Plot View point_number int4 10 null
characterisation_coarse_frags_shape Table id serial 10 nextval('characterisation_coarse_frags_shape_id_seq'::regclass)
All Point Intercept Points for a Plot View dead bool 1 null
lut_location_method Table description varchar 2147483647 null
lut_mga_zone Table western_boundary text 2147483647 null
soil_bulk_density Table paper_bag_weight float8 17 null
soil_bulk_density Table fine_earth_weight_in_bag float8 17 null
enter_determinations View herbarium_determination text 2147483647 null
lut_pedality_fabric Table description text 2147483647 null
soil_characterisation Table site_location_visit_id int4 10 null
lut_lithology Table outcrop_lithology varchar 2147483647 null
All_Broken_PI_Points View veg_barcode varchar 2147483647 null
lut_coarse_frag_abund Table type text 2147483647 null
lut_seg_form Table form text 2147483647 null
site_location Table site_slope varchar 2147483647 null
point_intercept Table substrate varchar 2147483647 null
site_location Table description text 2147483647 null
photopoints Table photopoint_centre_peg_lat text 2147483647 null
All_Broken_PI_Points View dead bool 1 null
structural_summary Table upper_1_dominant text 2147483647 null
herbarium_sheet Table follow_up_text text 2147483647 null
site_location Table surface_strew_size int4 10 null
lut_coarse_frag_shape Table id text 2147483647 null
soil_characterisation Table smallest_size_1 text 2147483647 null
lut_observer Table id serial 10 nextval('observer_id_seq'::regclass)
structural_summary Table site_location_visit_id int4 10 null
visit_surface_coarse_frags_type Table coarse_frag_type_id text 2147483647 null
dets_file_uploads Table site_location_id int4 10 null
basal_area Table point_id text 2147483647 null
lut_surface_strew_size Table id int4 10 null
point_intercept Table growth_form varchar 2147483647 null
herbarium_determination Table state_accession_number text 2147483647 null
soil_characterisation Table mottles_colour text 2147483647 null
soil_subsite_observations Table ten_to_twenty_barcode text 2147483647 null
lut_mga_zone Table projection text 2147483647 null
lut_growth_form Table growth_form text 2147483647 null
soil_characterisation Table lower_depth float8 17 null
genetic_vouchers Table sample_for_isotope text 2147483647 null
enter_determinations View state_accession_number text 2147483647 null
site_location_point Table easting float8 17 null