moped_proj_component_work_types

0 rows


Description

Tracks many work types per each project component

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('moped_proj_component_work_types_id_seq'::regclass)
project_component_id int4 10 null
moped_proj_components.project_component_id moped_proj_component_work_types_project_component_id_fkeyC
work_type_id int4 10 null
moped_work_types.id moped_proj_component_work_types_work_type_id_fkeyC
is_deleted bool 1 false
created_at timestamptz 35,6 now()

Timestamp when the record was created
created_by_user_id int4 10 √ null
moped_users.user_id project_component_work_types_created_by_fkeyR

ID of the user who created the record
updated_by_user_id int4 10 √ null
moped_users.user_id project_component_work_types_updated_by_fkeyR

ID of the user who last updated the record
updated_at timestamptz 35,6 now()

Timestamp when the record was last updated

Indexes

Constraint Name Type Sort Column(s)
moped_proj_component_work_types_pkey Primary key Asc id
moped_proj_component_work_types_project_component_id_work_type_ Must be unique Asc/Asc project_component_id + work_type_id

Relationships

Close relationships within degrees of separation