tbl_feature_types

111 rows


Description

The ‘tbl_feature_types’ table categorizes archaeological features by their function, shape, or construction to facilitate the study of historical human activities. Categories include: domestic structures (e.g., homes), public and ceremonial spaces (e.g., temples, public buildings), economic and industrial areas (e.g., workshops, kilns), defensive structures (e.g., fortifications, walls), agricultural modifications (e.g., terraces, irrigation systems), funerary sites (e.g., graves, tombs), transportation routes (e.g., roads, bridges), and water management systems (e.g., wells, aqueducts). These classifications provide insights into societal organization, cultural practices, and technological advancements across various eras and regions.

Columns

Column Type Size Nulls Auto Children Parents Comments
feature_type_id int4 10 √
tbl_features.feature_type_id fk_feature_type_id_feature_type_id C

Primary key (automatically incremented).
feature_type_name varchar(128) 128 √

The name of the feature type, providing a concise label for identification.
feature_type_description text 2147483647 √

A detailed description of the feature type, explaining its characteristics and significance.
date_updated timestamptz 35,6 √

Indexes

Constraint Name Type Sort Column(s)
tbl_feature_types_pkey Primary key Asc feature_type_id

Relationships

Close relationships within degrees of separation