postgreSQL/README.md

In EDIorg/ecocomDP: Tools to Create, Use, and Convert ecocomDP Data

EcoCom DP - posgreSQL

The ecocomDP model is specific to any one language. ecocomDP is composed of 7 tables, which can be linked via their indexes. An RDB implmentation illustrates this well, but of course, there are other equally usable mechanisms (eg, R data frames).

This directory contains the postgreSQL implementation of EDI's design pattern for ecological community survey data (ecocomDP)

File: create_7tables_ecocomDP_postgres.sql

creates the seven tables (see ../documentation) in a pre-existing posgtres schema called "ecocom_dp". Example is given for a read-only user, called "read_only_user", and an owner ("mob").

Directory: html

directory contains model documentation generated by a java program called schemaSpy (http://schemaspy.sourceforge.net/)

To use: if you clone this repository, view pages using

file:///path/to/index.html

Or use the preview here:

https://htmlpreview.github.io/?https://github.com/EDIorg/ecocomDP/blob/master/postgreSQL/html/index.html

EDIorg/ecocomDP documentation built on Aug. 22, 2024, 9:34 a.m.