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 |