Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
id | bigserial | 19 | √ | nextval('federated_search_models_id_seq'::regclass) |
|
|
||||
type | varchar | 255 | null |
|
|
|||||
name | varchar | 512 | null |
|
|
|||||
url | varchar | 512 | null |
|
|
|||||
description | text | 2147483647 | √ | null |
|
|
||||
attrs | json | 2147483647 | √ | null |
|
|
||||
created_at | timestamp | 22 | √ | null |
|
|
||||
updated_at | timestamp | 22 | √ | null |
|
|
||||
federated_search_instance_id | int4 | 10 | null |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
federated_search_models_pkey | Primary key | Asc | id |
Check Constraints
Constraint Name | Constraint |
---|---|
federated_search_models_type_check | (((type)::text = ANY ((ARRAY['Biigle\LabelTree'::character varying, 'Biigle\Project'::character varying, 'Biigle\Volume'::character varying])::text[]))) |