Database Documentation for Ministry of Fisheries Marine Biodiversity & Biosecurity Database
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.