moped_subphases

30 rows


Description

Standardized list of project sub-phases

Columns

Column Type Size Nulls Auto Default Children Parents Comments
subphase_id serial 10 nextval('moped_subphases_subphase_id_seq'::regclass)
moped_proj_components.subphase_id moped_proj_components_subphase_id_fkeyN
moped_proj_phases.subphase_id moped_proj_phases_subphase_id_fkeyN
subphase_name text 2147483647 null
subphase_description text 2147483647 null
related_phase_id int4 10 null
moped_phases.phase_id moped_subphases_related_phase_id_fkeyN

Indexes

Constraint Name Type Sort Column(s)
moped_subphases_subphase_id_pkey Primary key Asc subphase_id
moped_subphases_subphase_name_related_phase_id_key Must be unique Asc/Asc subphase_name + related_phase_id

Relationships