Database Documentation for Ministry of Fisheries Marine Biodiversity & Biosecurity Database


Adobe  Download as PDF (104KB)

biods

Fred Wei

NIWA Fisheries Data Management Database Documentation

Series Last modified in August 2005

Version Control

Version Status Changed By Reason Date
0.1 draft Fred Wei initial version 12 Sep 2003
0.2 draft Fred Wei revised based on D Fisher’s review 30 Sep 2003
1.0 Internal review Fred Wei revised based on K Mackay’s review 6 Oct 2003
1.1
Fred Wei Added Constraint column in table summaries. 7 Oct 2003
1.2
Fred Wei Added more fields in tables based on 28th Nov meeting. 1 Dec 2003
1.3
Fred Wei Revised based on Don’s comments and MFish’s biosecurity database workshop 18 Dec 2003
1.4
Fred Wei Revised based on real data and Graham Fenwick’s feedback. Split Species into Taxon and Taxon Detail, added Habitat, Organisation and Allocation tables. 8 Oct 2004
1.5
Fred Wei Added four new tables: t_effort_detail, t_sample_freq, t_sample_biol, t_sample_stage to cope with db trawl CE data. 11 Aug 2005

Contents

1. Database documentation series

2. Biodiversity and biosecurity data

2.1 Data Source

3. Data structures.

3.1 Conceptual Data Model

3.2 Database description

4. Table summaries

5. Biods Tables

5.1 Meta

5.2 Survey

5.3 Taxon_Classification

5.4 Taxon .

5.5 Taxon_Detail

5.6 Site

5.7 Habitat

5.8 Effort.

5.9 Effort_Detail

5.10 Sample

5.11 Sample_Freq

5.12 Sample_Stage.

5.13 Sample_Biol.

5.14 Organisation

5.15 Allocation

5.16 Archive

5.17 Method.

6. Data Loading and Validation

6.1 Introduction to business rules

6.2 Business Rules

7. Acknowledgements

8. References

List of Figures

Figure 1: Entity Relationship Diagram (ERD) of the biodiversity database.


Previous | Next
Updated : 16 November 2007