match_set_quality

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('vandelay.match_set_quality_id_seq'::regclass)
match_set int4 10 null
match_set.id match_set_quality_match_set_fkey C
svf text 2147483647 √ null
record_attr_definition.name match_set_quality_svf_fkey R
tag text 2147483647 √ null
subfield text 2147483647 √ null
value text 2147483647 null
quality int4 10 1

Indexes

Constraint Name Type Sort Column(s)
match_set_quality_pkey Primary key Asc id
vmsq_def_once_per_set Must be unique Asc/Asc match_set + value

Check Constraints

Constraint Name Constraint
vmsq_need_a_tag_or_a_ff ((((tag IS NOT NULL) AND (svf IS NULL)) OR ((tag IS NULL) AND (svf IS NOT NULL))))
vmsq_need_a_subfield_with_a_tag ((((tag IS NOT NULL) AND (subfield IS NOT NULL)) OR (tag IS NULL)))

Relationships

Close relationships within degrees of separation