Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | bigserial | 19 | √ | nextval('metabib.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) |
|---|---|---|---|
| real_full_rec_pkey | Primary key | Asc | id |
| metabib_full_rec_02x_tag_subfield_lower_substring | Performance | Asc/Asc | tag + subfield |
| metabib_full_rec_index_vector_idx | Performance | Asc | index_vector |
| metabib_full_rec_isxn_caseless_idx | Performance | ||
| metabib_full_rec_record_idx | Performance | Asc | record |
| metabib_full_rec_tag_subfield_idx | Performance | Asc/Asc | tag + subfield |
| metabib_full_rec_value_idx | Performance | ||
| metabib_full_rec_value_tpo_index | Performance |
Relationships
Close relationships within degrees of separation
