moped_proj_components

4 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
project_component_id serial 10 √ nextval('moped_proj_components_project_component_id_seq'::regclass)
features.component_id features_component_id_fkeyR
moped_proj_component_tags.project_component_id moped_proj_component_tags_project_component_id_fkeyC
moped_proj_component_work_types.project_component_id moped_proj_component_work_types_project_component_id_fkeyC
moped_proj_components_subcomponents.project_component_id moped_proj_components_subcomponents_project_component_id_fkeyC
project_id int4 10 null
moped_project.project_id moped_proj_components_project_id_fkeyC
component_id int4 10 null
moped_components.component_id moped_proj_components_component_id_fkeyN
description text 2147483647 √ null
is_deleted bool 1 false

Indicates soft deletion
interim_project_component_id int4 10 √ null
phase_id int4 10 √ null
moped_phases.phase_id moped_proj_components_phase_id_fkeyN
subphase_id int4 10 √ null
moped_subphases.subphase_id moped_proj_components_subphase_id_fkeyN
completion_date timestamptz 35,6 √ null
created_at timestamptz 35,6 now()
srts_id text 2147483647 √ null

The Safe Routes to School infrastructure plan record identifier
location_description text 2147483647 √ null
created_by_user_id int4 10 √ null
updated_by_user_id int4 10 √ null
updated_at timestamptz 35,6 √ now()

Indexes

Constraint Name Type Sort Column(s)
moped_proj_components_pkey Primary key Asc project_component_id
moped_proj_components_project_id_idx Performance Asc project_id

Relationships

Close relationships within degrees of separation