| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| site_code |
char |
6 |
|
|
|
|
|
| marine_site_name |
varchar |
50 |
|
|
|
|
|
| restricted_site_code |
char |
6 |
|
|
|
|
|
| restricted_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 5 rows at Thu Nov 06 11:53 PST 2025
|
