Table marinedb.master_site_reference
master site reference for all survey sites

 Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
site_code char 6
abalone_habitat_sites.site_code FK_abalone_habitat_sites_master R
biodiversity_sites.site_code FK_biodiversity_sites_master R
cit_sites.site_code FK_cit_sites_master R
marine_sites.site_code FK_marine_sites_master R
mussel_watch_sites.site_code FK_mussel_watch_sites_master R
oil_spill_sites.site_code FK_oil_spill_sites_master R
other_sites.site_code FK_other_sites_master R
temperature_sites.site_code FK_temperature_sites_master R
vouchered_sites.site_code FK_vouchered_sites_master R
marine_site_name varchar 50
marine_sort_order int unsigned 10
county varchar 30
island varchar 30
state_province varchar 30
country varchar 30
latitude float 12,8
longitude float 10,5
pisco_code char 6  √  null
mpa_designation varchar 10  √  null
mpa_region varchar 50  √  null
mpa_lt_region varchar 50  √  null
mpa_name varchar 50  √  null
nms_name varchar 50  √  null
asbs_name varchar 100  √  null
national_designation varchar 50  √  null
nps_network_code varchar 4 NONE
state_province_designation varchar 50  √  null
county_designation varchar 50  √  null
other_designation varchar 50  √  null
site_filename varchar 50  √  null
georegion varchar 50  √  null
bioregion varchar 50  √  null
site_link varchar 255
comments varchar 300
create_date date 10
modify_date timestamp 19 current_timestamp()

Table contained 422 rows at Thu Apr 03 16:08 PDT 2025

Indexes:
Column(s) Type Sort Constraint Name
site_code Primary key Asc PRIMARY

Close relationships  within of separation: