| mooring_id | varchar(10) | NOT NULL, PRIMARY KEY | An example would be "F0101". The first character species a region. The second and third specify a location within that region. The fourth and fifth characters specify a deployment at that particular site. |
| active | char(1) | | Either "Y" or "N"
|
| type | varchar(20) | | Either "coastal" or "basin"
|
| latitude | float(10,4) | | Latitude where deployed.
|
| longitude | float(10,4) | | Longitude where deployed.
|
| water_depth | float(10,1) | | Depth of water column at deployment site.
|
| scope | float(10,1) | | Needs explanation.
|
| time_dep | datetime | | Time of deployment
|
| time_rec | datetime | | Time when the mooring was recovered.
|
| light_list | char(2) | | Needs explanation.
|
| buoy_sn | varchar(30) | | Serial number of buoy. More detailed explanation??
|
| wirerope_length | float(10,1) | | Needs explanation.
|
| chain_length | float(10,1) | | Needs explanation.
|
| anchor_weight | float(10,1) | | Needs explanation.
|
| solar_watts | float(10,1) | | Needs explanation.
|
| solar_angle | float(10,1) | | Needs explanation.
|
| campbell_id | smallint(3) | | Needs explanation.
|
| site_name | varchar(40) | | Short 2-3 word description of mooring location.
|
| add_magnetic_variation | float(10,1) | | Needs explanation.
|
| location_description | text | | More detailed description of mooring location.
|
| buoy_schematic_image_url | varchar(255) | | URL of full size schematic of a particular buoy.
|
| buoy_schematic_thumbnail_image_url | varchar(255) | | URL of thumbnail schematic of a particular buoy. Smaller version of
buoy_schematic_image_url.
|
| goes_platform_id | char | |
ID string to use when processing a buoy via the GOES satellite.
|
| time_entry | timestamp(14) | | Identifies when a change to the record was made.
|
| status_comment | text | | Displayed on an individual buoy web page. Usually some sort of
current status message.
|