Table Summaries

The following is a listing of the tables contained in the squ_ce database:

1. t_events : contains locations and times of events. Events include fishing, recording of environmental information and daily processing.
2. t_fish_evnts : contains effort and overall catch for each fishing event.
3. t_catches: contains estimated weights for each species caught. This table is used for trawling only.
4. t_proc_evnts : contains daily processing details of each species. Contains processing data and calculated green weight
5. t_proc_state : table describing the codes for processing states used in t_proc_evnts.
6. t_environ : contains observations of environmental conditions. Time and position for each set of observations (each environmental event) can be found in t_events. Jigging environmental observations are made at 0100 hr, and for trawling they are made before the first shot of the day.
7. t_versions : contains the current version number for each event. This table can be used to speed up the extraction of data where there are joins between event tables.
8. t_vessels: contains details on each vessel, including identification, country of origin and size.
9. t_vess_reg: contains details for the types of fishing vessel for each registration period.
10. t_vess_types: contains the codes and descriptions for vessel types used in t_vess_reg.

The following is a listing of the tables contained in the squ_ce database:

1. v_events : Current version of events as recorded in the t_events table, including fishing,recording of environmental information and daily processing events.
2. v_fish_evnts : Contains the latest version of effort and overall catch for each fishing event.
3. v_catches : Current version of catch weight records for each species caught as recorded in the t_catches table.
4. v_proc_evnts : Current version of daily processing records of each species. Contains processing data and calculated green weight
5. v_environ : Latest version of observations of environmental conditions. Time and position for each set of observations (each environmental event) can be found in t_events. For jigging environmental observations are made at0100 hr and for trawling they are made before the first shot of the day.
6. v_fish : This view joins the latest versions of the tables t_events andt_fish_events.The result is time and location data associated with data for each fishing event.
7. v_proc : This view joins the latest versions of the tables t_events and t_proc_evnts.The result is time and location data associated with each processing event
8. v_env : This view joins the current versions of the tables t_events and t_environ.The result is time and location data associated with data for each environmental event.
9. v_jigs : This view joins tables t_fish_evnts, t_proc_evnts and t_environ. It thus represents all the data from any night's jigging from a single vessel.