metabib.full_rec (view)

↑ metabib schema

This is a database view, not a base table. It has no triggers, indexes, or FK constraints of its own. Querying this view may be more efficient than joining the underlying tables directly.

Columns

Column Type Nullable Notes

Column	Type	Nullable
id	`bigint`	Yes
record	`bigint`	Yes
tag	`character(3)`	Yes
ind1	`text`	Yes
ind2	`text`	Yes
subfield	`text`	Yes
value	`text`	Yes
index_vector	`tsvector`	Yes

bigint

Yes

record

bigint

Yes

tag

character(3)

Yes

ind1

text

Yes

ind2

text

Yes

subfield

text

Yes

value

text

Yes

index_vector

tsvector

Yes

View Definition

 SELECT real_full_rec.id,
    real_full_rec.record,
    real_full_rec.tag,
    real_full_rec.ind1,
    real_full_rec.ind2,
    real_full_rec.subfield,
    "substring"(real_full_rec.value, 1, 1024) AS value,
    real_full_rec.index_vector
   FROM metabib.real_full_rec;