Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | bigserial | 19 | √ | nextval('authority.full_rec_id_seq'::regclass) |
|
|
||
| record | int8 | 19 | null |
|
|
|||
| tag | bpchar | 3 | null |
|
|
|||
| ind1 | text | 2147483647 | √ | null |
|
|
||
| ind2 | text | 2147483647 | √ | null |
|
|
||
| subfield | text | 2147483647 | √ | null |
|
|
||
| value | text | 2147483647 | null |
|
|
|||
| index_vector | tsvector | 2147483647 | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| full_rec_pkey | Primary key | Asc | id |
| authority_full_rec_index_vector_idx | Performance | Asc | index_vector |
| authority_full_rec_record_idx | Performance | Asc | record |
| authority_full_rec_subfield_a_idx | Performance | Asc | value |
| authority_full_rec_tag_part_idx | Performance | ||
| authority_full_rec_tag_subfield_idx | Performance | Asc/Asc | tag + subfield |
| authority_full_rec_value_index | Performance | ||
| authority_full_rec_value_tpo_index | Performance |
Relationships
Close relationships within degrees of separation
