tbl_project_types

5 rows


Description

Defines the categories of projects based on their primary purpose or objective, such as teaching, consultancy, research, or their combinations.

Columns

Column Type Size Nulls Auto Children Parents Comments
project_type_id int4 10 √
tbl_projects.project_type_id fk_projects_project_type_id R

Primary key (automatically incremented).
project_type_name varchar 2147483647 √

The name representing the project type, such as consultancy, research, teaching, or combinations like consultancy/teaching.
description text 2147483647 √

Details the combination of project types, if applicable, such as teaching/research.
date_updated timestamptz 35,6 √

Indexes

Constraint Name Type Sort Column(s)
tbl_project_types_pkey Primary key Asc project_type_id
tbl_project_types_project_type_name_key Must be unique Asc project_type_name
tbl_project_types_project_type_name_unique Must be unique Asc project_type_name

Relationships

Close relationships within degrees of separation