moped_work_types

12 rows


Description

Lookup table for component work types

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 nextval('moped_work_types_id_seq'::regclass)
moped_component_work_types.work_type_id moped_component_work_types_work_type_id_fkeyC
moped_proj_component_work_types.work_type_id moped_proj_component_work_types_work_type_id_fkeyC
name text 2147483647 null
key text 2147483647 null
is_deleted bool 1 false

Indexes

Constraint Name Type Sort Column(s)
moped_work_types_pkey Primary key Asc id
moped_work_types_key_key Must be unique Asc key

Relationships