Skip to content

modules/db/structures_metadata/SCHEDAIND_table.py

Overview

This file contains 3 documented elements.

Classes

SCHEDAIND_table

No description available. A SQLAlchemy table definition class representing individual archaeological records, mapped to the individui_table database table. It defines columns capturing identification, contextual, and physical attributes of skeletal individuals, including site and stratigraphic unit references, demographic estimates (sex, age range, age class), skeletal measurements, positional data, and a UUID-based persistent identifier. A unique constraint enforces that the combination of sito and nr_individuo remains distinct across all records.

Methods

define_table(cls, metadata)

No description available. A class method that defines and returns a SQLAlchemy Table object named 'individui_table' bound to the provided metadata instance. The table schema represents individual archaeological records and includes columns for site identification (sito, area, us), individual attributes (sesso, eta_min, eta_max, classi_eta), skeletal measurements and positional data (lunghezza_scheletro, posizione_scheletro, posizione_cranio, posizione_arti_superiori, posizione_arti_inferiori, orientamento_asse, orientamento_azimut), record metadata (data_schedatura, schedatore), and a StratiGraph UUID (entity_uuid). A UniqueConstraint named 'ID_individuo_unico' enforces uniqueness on the combination of sito and nr_individuo.