Current loctn:
about >
data model v3
Data Model - Version 3
Data Subjects
Key Features
Diagrams
Data Subjects
The following data subjects provided in version 4 are not
provided in version 3:
- Payment Products
- Products
- Product Categoriess
- Product Price Sets
Single-use customizations
Single-use customizations of V3 have been developed to
add the following major information tracking capacities:
- Community Health Clinic - Data structures designed
to track appointments and visits.
- Conservation Agreements - Data structures designed
to track agreements made with parties indicating a willingness to
pledge energy conservation action.
- Gardens - Data structures for tracking information about
gardens provided to organizational constituents. Also tracks association
of volunteers associated with each garden as mentors, etc and actions
supported at each garden as well as materials provided for upkeep and
use of each garden. The history of association of different parties
with each garden through time can also be tracked.
- Residential Care Facility - Data structures for
tracking information about
clients of residential facilities and their associations with other parties
used as legal representatives, health care providers, etc.
- Staff Certification History - Data structures designed
to track history of required trainings received by staff members, including
certification expiration dates, etc.
Data storage structures developed for these customizations can be fairly
easily incorporated into new customizations of the database
top of page
Key features:
- A number of enhanced data loading features added to the V4
server
database for use by database administrators are
not provided in V3
top of page
Entity-Relationship Diagrams
This implementation provides an unabridged, very complete rendition of
the full data model with some extensions adding additional data tracking
capacities, and removing components specific to a natural resource
advocacy organization.
- Main Model
- Entities and relationships without attributes represented
(PNG file, 74Kb)
- Contact Submodel
- Entities closely related to storage of
contacts
,
with attributes represented (PNG file, 21Kb)
- Donation Submodel
- Entities closely related to storage of
donations
,
with attributes represented (PNG file, 29Kb)
- Focus Area Submodel
- Entities closely related to storage of
focus areas
,
with attributes represented (PNG file, 14Kb)
- Grant Submodel
- Entities closely related to storage of
grants
,
with attributes represented (PNG file, 21Kb)
- Outreach Response Submodel
- Entities closely related to storage of
outreach responses
,
with attributes represented (PNG file, 16Kb)
- Outreach Submodel
- Entities closely related to storage of
outreaches
,
with attributes represented (PNG file, 25Kb)
- Party Submodel
- Entities closely related to storage of
parties
,
with attributes represented (PNG file, 35Kb)
- Person Submodel
- Entities closely related to storage of
persons
,
with attributes represented (PNG file, 37Kb)
- Publication Submodel
- Entities closely related to storage of
publications
,
with attributes represented (PNG file, 8Kb)
- Team Submodel
- Entities closely related to storage of
teams
,
with attributes represented (PNG file, 20Kb)
- Volunteer Action Submodel
- Entities closely related to storage of
volunteer actions
,
with attributes represented (PNG file, 18Kb)
- Voter Submodel
- Entities closely related to storage of
voters
,
with attributes represented (PNG file, 14Kb)
top of page