family-genealogy-database

Summary

This repository contains the SQL code, data model, and supporting materials for a personal Family Genealogy Database implemented with PostgreSQL.

• The purpose of this SQL code is to create a relational database used to record, maintain, query, and report on personal family genealogical data.

• The SQL code contained within this repository is compatible with PostgreSQL version 9.6 and has not been tested with any other SQL database engines.

• Please Note: This genealogy database has not been tested for compatibility with the latest Genealogical Data Communication (GEDCOM) Standard.

Data Model

The current version of the data model (2017-09-26) contains the following tables listed below:

1. individual
2. parent
3. parent_type
4. family
5. relationship
6. occupation
7. education
8. health_condition
9. relationship_type
10. role_type
11. occupation_type
12. health_condition_type
13. education_type
14. individual_memory
15. family_event
16. individual_memory_object
17. family_event_object
18. object_type

Additional documentation will be added soon.

See the embedded PNG below for a visual representation of these tables and associated fields, field types, and logical relationships comprising the current data model:

See Also

Special thanks to Barry Williams, whose suggested data model on databaseanswers.com was my starting point while building this model.