A Country has properties of country name. A Country may have many Regions.
A Location has properties of
location name, latitude and longitude.
A Location is identified by its locationName.
A Location must
be had by one Region.
A Location must
directions one Confluence.
A Region has properties of region name. A Region may have many Locations. A Region must be had by one Country. A Region may have many Confluences.
A Confluence has properties of
latitude, longitude, altitude and kind (kind).
A Confluence is identified by its latitude and longitude.
latitude
A Visit has properties of
date visited, description (html), accuracy, status (status) and progress (progress).
A Visit is identified by its visitid.
description
A Picture has properties of
seqno, image (image) and title.
A Picture is identified by its seqno.
title
A Visitor has properties of
visitorid, name, email, total visits and unique visits.
A Visitor is identified by its visitorid.
totalVisits
Type status is restricted to the values successful and incomplete.
Type kind is restricted to the values primary, secondary and water.
Type progress is restricted to the values active, pending and submitting.