moped_component_work_types

367 rows


Description

Tracks allowed moped_work_types by component type

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 nextval('moped_component_work_types_id_seq'::regclass)
work_type_id int4 10 null
moped_work_types.id moped_component_work_types_work_type_id_fkeyC
component_id int4 10 null
moped_components.component_id moped_component_work_types_component_id_fkeyC

Indexes

Constraint Name Type Sort Column(s)
moped_component_work_types_pkey Primary key Asc id
unique_work_type_component Must be unique Asc/Asc work_type_id + component_id

Relationships