moped_component_tags

43 rows


Description

Lookup table for component tags

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 nextval('moped_component_tags_id_seq'::regclass)
moped_proj_component_tags.component_tag_id moped_proj_component_tags_component_tag_id_fkeyC
name text 2147483647 null
type text 2147483647 null
slug text 2147483647 null
is_deleted bool 1 false
full_name text 2147483647 CASE WHEN ((type IS NOT NULL) AND (name IS NOT NULL)) THEN ((type || ' - '::text) || name) WHEN (type IS NOT NULL) THEN type WHEN (name IS NOT NULL) THEN name ELSE NULL::text END

Full name of the component tag; type and name are concatenated if both present

Indexes

Constraint Name Type Sort Column(s)
moped_component_tags_pkey Primary key Asc id
moped_component_tags_name_key Must be unique Asc/Asc name + type
moped_component_tags_slug_key Must be unique Asc slug

Relationships