The DAACS website is powered by a large relational database designed by Archive staff with the input from Steering Committee members and collaborating institutions. Over two hundred tables come together to form the robust relational database that is the backbone of the archive. Today the database contains fine-grained information on over 1.5 million artifacts and 18,000 excavated contexts from 57 sites located throughout the Maryland, Virginia, South Carolina, Jamaica, Nevis, and St. Kitts.
The DAACS database application consists of a data-entry client, written in Visual Basic, linked to a MS-SQL Server backend, via a local network. The front-end was completely built and customized in-house, by Derek Wheeler, for efficient navigation by data entry personnel. The links below provide access to the data structures of each major data table in the DAACS database. Each table structure includes field names, authority terms, and basic schematic relationship diagrams for those interested in the structure behind the DAACS database. The fields and authority terms are updated regularly so you will view the most current data structures. Please contact us if you would like more detailed information on the DAACS database.