SesarDB

Home Tables Schemas Diagrams Foreign Keys Indexes
sesardb Indexes
Name Table Columns Unique Clustered
archive_name_idx archive_lkup name
classification_name_idx classification name
classification_parent_clssfctn_idx classification parent_classification_id
collection_method_name_idx collection_method_lkup name
collector_name_idx collector_lkup name
country_name_uk country name

cruise_field_prgrm_name_idx cruise_field_prgrm_lkup name
group_sample_uk group_sample group_id, sample_id

platform_type_name_idx platform_type_lkup name
primary_location_name_name_idx primary_location_name_lkup name
primary_location_type_name_idx primary_location_type_lkup name
cruise_field_program_idx sample cruise_field_prgrm
launch_id_idx sample launch_id
launch_type_id_idx sample launch_type_id
nav_type_id_idx sample nav_type_id
primary_location_name_idx sample primary_location_name
primary_location_type_idx sample primary_location_type
purpose_idx sample purpose
sample_classification_id_idx sample classification_id
sample_collection_method_idx sample collection_method
sample_collector_idx sample collector
sample_cruise_field_prgrm_idx sample cruise_field_prgrm
sample_current_archive_idx sample current_archive
sample_geom_latlong_idx sample geom_latlong
sample_igsn_idx sample igsn
sample_igsn_prefix_idx sample igsn_prefix
sample_igsn_prefix_igsn_to_int_idx sample igsn_prefix, igsn_to_int
sample_igsn_to_int_idx sample igsn_to_int
sample_name_idx sample name
sample_odp_igsn_to_int_idx sample igsn_to_int
sample_origin_sample_id_idx sample origin_sample_id
sample_platform_name_idx sample platform_name
sample_platform_type_idx sample platform_type
sample_top_level_classfct_id_idx sample top_level_classification_id
sample_additional_name_sample_id_idx sample_additional_name sample_id
sample_publication_url_url_idx sample_publication_url url
sample_type_name_idx sample_type name
sesar_user_code_idx sesar_user_code user_code