tbl_features

2669 rows


Description

The ‘tbl_features’ table represents archaeological features, which are immovable traces of past human activities. These features include structures or landscape modifications such as building remains, hearths, burials, pits, roads, terraces, and defensive constructions like mounds and ditches. They are vital for understanding the spatial organization, cultural practices, and daily life of ancient societies, providing context for interpreting artifacts and environmental interactions. Archaeological features are analyzed in situ through excavation and surveying to offer insights into historical human-environment dynamics.

Columns

Column Type Size Nulls Auto Children Parents Comments
feature_id int4 10 √
tbl_physical_sample_features.feature_id fk_physical_sample_features_feature_id C

Primary key (automatically incremented).
feature_type_id int4 10
tbl_feature_types.feature_type_id fk_feature_type_id_feature_type_id C

Specifies the type of feature.
feature_name varchar 2147483647 √

The established reference name or number for the feature, such as ‘well 47’, ‘anl.3’, or ‘c107’. Note: A sample may derive from multiple features (e.g., ‘c107’ within ‘well 47’), but each feature should be recorded separately.
feature_description text 2147483647 √

A detailed description of the feature, which may include field and lab notes or interpretative information helpful for analyzing the sample data.
date_updated timestamptz 35,6 √

Indexes

Constraint Name Type Sort Column(s)
tbl_features_pkey Primary key Asc feature_id
idx_features_feature_type_id Performance Asc feature_type_id

Relationships

Close relationships within degrees of separation