Data Architecture - Woz-U-Group-Projects/team-the-grinchs-posse GitHub Wiki

Data Architecture Analysis

by Robert Hieger

As the Gift Wish List is very much a data-driven application reliant on database transactions and CRUD operations, I felt it important to make a basic analysis of the data architecture.

The Entity Relationship Diagram (ERD) below is a first rendering and subject to change and/or triage.

Gift Wish List ERD

A FEW NOTES ABOUT THE DIAGRAM:

  1. The notation PK in the top column of every entity (table) stands for primary key, i.e. the primary index for the table, and the column that uniquely identifies a row.

  2. The notation NOT NULL means that MySQL will assure that any column thus marked will not be allowed to remain empty or NULL.

  3. The notation FK that appears at the end of some column descriptions stands for foreign key, a column which the diagram clearly shows relates to a corresponding primary key in another table or tables.

Return to Wiki Home