Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
id | serial | 10 | √ | nextval('moped_component_tags_id_seq'::regclass) |
|
|
||||
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 |