# PHOS4D Objects Schema Documentation

## Introduction

The database schema holds the data concerning the archaeological finds in relation to the location it was found and contextualizing the activities that were performed therein with those finds/objects by connecting them to the daylight amount by the architecture. Metadata is also stored in this database.

This document holds all tables realised in the database, excluding the junction tables. It will be updated should the database structure be changed in the future.

For more information on the PHOS4D project please visit: 

https://tudatalib.ulb.tu-darmstadt.de/handle/tudatalib/4302

https://www.archaeologie.architektur.tu-darmstadt.de/klarch/news_klarch/news_klarch_details_120000.de.jsp

## Overview

The folder contains:

- an ERD in .png and .drawio.
- a .txt file containing the SQL queries to setup and load the data
- a .txt file containing only the schema (no data)
- a LibreOffice Base file to be used to input data
- a short instruction manual on how to setup and use the schema and the software
- the textual documentaton in .pdf and .md

*Further information can be found in the respective folders.*