# PHOS4D Architecture Schema Documentation

## Introduction

The database holds data and metadata concerning observations, openings (doors, windows, etc.) and reflective surfaces of the case studies of the project phos4d and is the base for the respective reconstruction models.

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

## binaries
The folder contains binary files referenced in the database, mostly documenting the naming systematic of the rooms in the three case studies (Pompeii, Orraon, Ostia).

## import_DWD

Files used for import of the doors and windows database of Lucia Michielin (see: https://github.com/Lucia-Michielin/DoorsAndWindows) into the project database.

Michielin, L., Fores et Fenestrae. A computational study of doors and windows in Roman domestic space. Phd thesis, University of Edinburgh, 2019. URI: http://hdl.handle.net/1842/36190

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