Database documentation: squ_ce

  Download as PDF (95.1KB)

K. A.Mackay

NIWA Internal Report 2001

Revised on 30 January 2001

Contents

1 Introduction to the Database Document series

 

2 Arrow squid fishery catch effort data

 

3 Data Structures

3.1 Table relationships
3.2 Database design

4 Table Summaries

5 squ_ce Tables

5.1 Table 1: t_events
5.2 Table 2: t_fish_evnts
5.3 Table 3: t_catches
5.4 Table 4: t_proc_evnts
5.5 Table 5: t_proc_state
5.6 Table 6: t_environ
5.7 Table 7: t_versions
5.8 Table 8: t_vessels
5.9 Table 9: t_vess_reg
5.10 Table 10: t_vess_types

6 squ_ce Views

6.1 View 1: v_events
6.2 View 2: v_fish_evnts
6.3 View 3: v_catches
6.4 View 4: v_proc_evnts
6.5 View 5: v_environ
6.6 View 6: v_fish
6.7 View 7: v_proc
6.8 View 8: v_env
6.9 View 9: v_jigs

7 References

/dl>

List of Figures:
Figure 1: Entity Relationship Diagram (ERD) for the squ_ce database
Figure 2: GENSPEC diagram for the "events" entity
Figure 3: ERD of the specialisations of the entity "events"
Figure 4: ERD of the squid jig view incorporating the v_fish and v_proc views