GEDCOM in DDL

The GEDCOM UML model is a platform independent model. It can be transformed into other models that are platform specific, such as a database.

Here, a derived GEDCOM model for the SQLite 3 database is presented. Unlike the platform independent model which displays classes and associations, this model consists of tables and columns and relationships between tables are expressed via primary and foreign keys.

In addition to drawing diagrams and documenting a model, a UML tool can also generate SQL DDL (Data Definition Language) for a database model. This can be used to create a SQLite database. This model and the DDL were developed using Enterprise Architect from Sparx Systems. The current model is at version 0.6:

GEDCOM 5.5/5.5.1 Physical Data Model
(an HTML-frame based model browser)

GEDCOM 5.5/5.5.1 DDL