tbl_methods

133 rows


Description

Contains definitions and details of various analysis methods.

Columns

Column Type Size Nulls Auto Children Parents Comments
method_id int4 10 √
tbl_analysis_entity_prep_methods.method_id fk_analysis_entity_prep_methods_method_id R
tbl_ceramics_lookup.method_id fk_ceramics_lookup_method_id R
tbl_ceramics_measurements.method_id fk_ceramics_measurements_method_id R
tbl_colours.method_id fk_colours_method_id R
tbl_coordinate_method_dimensions.method_id fk_coordinate_method_dimensions_method_id R
tbl_datasets.method_id fk_datasets_method_id R
tbl_horizons.method_id fk_horizons_method_id R
tbl_relative_dates.method_id fk_relative_dates_method_id R
tbl_sample_dimensions.method_id fk_sample_dimensions_measurement_method_id R
tbl_sample_groups.method_id fk_sample_groups_method_id R
tbl_site_natgridrefs.method_id fk_site_natgridrefs_method_id R
tbl_value_classes.method_id tbl_value_classes_method_id_fkey R

Primary key (automatically incremented).
biblio_id int4 10 √
tbl_biblio.biblio_id fk_methods_biblio_id R

Specifies the publication that describes or mentions the method.
date_updated timestamptz 35,6 √
description text 2147483647

Detailed description of the analysis method.
method_abbrev_or_alt_name varchar(50) 50 √

Abbreviation or alternative name for the method.
method_group_id int4 10
tbl_method_groups.method_group_id fk_methods_method_group_id R

Specifies the group category of the method.
method_name varchar(50) 50

Full name of the analysis method.
record_type_id int4 10 √
tbl_record_types.record_type_id fk_methods_record_type_id R

Specifies the type of record related to the method.
unit_id int4 10 √
tbl_units.unit_id fk_methods_unit_id R

Specifies the unit of measurement used in the method.
method_uuid uuid 2147483647

Indexes

Constraint Name Type Sort Column(s)
tbl_methods_pkey Primary key Asc method_id
pk_tbl_methods Must be unique Asc method_uuid
tbl_methods_method_abbrev_or_alt_name_key Must be unique Asc method_abbrev_or_alt_name
tbl_methods_method_abbrev_or_alt_name_unique Must be unique Asc method_abbrev_or_alt_name

Relationships

Close relationships within degrees of separation