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 |