tbl_project_stages

6 rows


Description

This table defines the various stages of an investigation, such as desktop study, prospection, full excavation, and reanalysis.

Columns

Column Type Size Nulls Auto Children Parents Comments
project_stage_id int4 10 √
tbl_projects.project_stage_id fk_projects_project_stage_id R

Primary key (automatically incremented).
stage_name varchar 2147483647 √

The name of the project stage within the investigative cycle, such as desktop study, prospection, or final excavation.
description text 2147483647 √

A detailed explanation of the project stage, outlining its purpose and general activities involved.
date_updated timestamptz 35,6 √

Indexes

Constraint Name Type Sort Column(s)
tbl_project_stages_pkey Primary key Asc project_stage_id
tbl_project_stages_stage_name_key Must be unique Asc stage_name
tbl_project_stages_stage_name_unique Must be unique Asc stage_name

Relationships

Close relationships within degrees of separation