real_full_rec

20340 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('metabib.full_rec_id_seq'::regclass)
record int8 19 null
record_entry.id metabib_full_rec_record_fkey C
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