tbl_projects

506 rows


Description

Contains information about projects, including their names and descriptions, pertinent to datasets for specific sites.

Columns

Column Type Size Nulls Auto Children Parents Comments
project_id int4 10 √
tbl_datasets.project_id fk_datasets_project_id R

Primary key (automatically incremented).
project_type_id int4 10 √
tbl_project_types.project_type_id fk_projects_project_type_id R

Specifies the type of the project, linking to the corresponding type details.
project_stage_id int4 10 √
tbl_project_stages.project_stage_id fk_projects_project_stage_id R

Specifies the project’s stage, linking to the corresponding stage details.
project_name varchar(150) 150 √

The full name of the project (e.g., Phil’s PhD Thesis, Malm� Ring Road V�gverket).
project_abbrev_name varchar(25) 25 √

An optional field for the abbreviation or acronym of the project name (e.g., VGV, SWEDAB).
description text 2147483647 √

A brief overview of the project, including relevant details that facilitate further exploration.
date_updated timestamptz 35,6 √

Indexes

Constraint Name Type Sort Column(s)
tbl_projects_pkey Primary key Asc project_id
tbl_projects_project_abbrev_name_unique Must be unique Asc project_abbrev_name

Relationships

Close relationships within degrees of separation