moped_proj_tags

5 rows


Description

Stores tag / project relationships

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('moped_proj_tags_id_seq'::regclass)
project_id int4 10 null
moped_project.project_id moped_proj_tags_project_id_fkeyC
tag_id int4 10 null
moped_tags.id moped_proj_tags_tag_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_tags_created_by_fkeyR

ID of the user who created the record
updated_by_user_id int4 10 √ null
moped_users.user_id project_tags_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_tags_pkey Primary key Asc id
moped_proj_tags_project_id_idx Performance Asc project_id

Relationships

Close relationships within degrees of separation