moped_proj_components_subcomponents

1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
component_subcomponent_id serial 10 √ nextval('moped_proj_components_subcomponen_component_subcomponent_id_seq'::regclass)
project_component_id int4 10 null
moped_proj_components.project_component_id moped_proj_components_subcomponents_project_component_id_fkeyC
subcomponent_id int4 10 null
moped_subcomponents.subcomponent_id moped_proj_components_subcomponents_subcomponent_id_fkeyC
is_deleted bool 1 false

Indicates soft deletion
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_subcomponent_created_by_fkeyR

ID of the user who created the record
updated_by_user_id int4 10 √ null
moped_users.user_id project_component_subcomponent_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_components_subcomponents_pkey Primary key Asc component_subcomponent_id
unique_component_and_subcomponent Must be unique Asc/Asc project_component_id + subcomponent_id

Relationships

Close relationships within degrees of separation