Database documentation: aer_sight

  Download as PDF (413KB)

David Fisher & Paul Taylor  

NIWA Fisheries

Data Management Database Documentation Series

Updated - 7 September 2001

Table of Contents

1 Introduction to the Database Document series
2 The Aerial Sightings Database

2.1 Data sources .

2.2 Data validation

2.3 Uses of the aerial sightings database

3 Data Structures

3.1 Table relationships ..

3.2 Database design ..

4 Table Summaries

4.1 Main tables

4.2 Code tables

4.3 Time tables .

4.4 Environmental tables .

5 Aerial Sightings Tables.

5.1 Main Tables

5.1.1 t_flight_group

5.1.2 t_flight

5.1.3 t_school_sight .

5.1.4 t_set

5.1.5 t_flightpath.

5.2 Code Tables

5.2.1 t_pilot_code

5.2.2 t_customer_code.

5.2.5 t_airfield_code

5.3 Time tables

5.3.1 t_flt_days .

5.3.2 Table: t_time

5.4 Environmental tables

5.4.1 t_soi .

5.4.2 t_astro_gen.

5.4.3 t_astro_moon

5.4.4 t_astro_sun

6 aer_sight business rules

6.1 Introduction to business rules .

6.2 Summary of rules

7 Acknowledgements

8 References

Appendix 1 - Data Integrity