vandelay.match_set_quality

↑ vandelay schema

Cascading Deletes: Deleting rows from this table will cascade to: vandelay.match_set.

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('vandelay.match_set_quality_id_seq'::regclass)

match_set FK

integer

No

→ vandelay.match_set(id)

svf FK

text

Yes

→ config.record_attr_definition(name)

tag

text

Yes

subfield

text

Yes

value

text

No

quality

integer

No

1

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

match_set

vandelay.match_set(id)

CASCADE

NO ACTION

No

match_set_quality_match_set_fkey

svf

config.record_attr_definition(name)

NO ACTION

NO ACTION

No

match_set_quality_svf_fkey

Check Constraints

  • vmsq_need_a_subfield_with_a_tag: CHECK ((tag IS NOT NULL) AND (subfield IS NOT NULL OR (tag IS NULL)))

  • vmsq_need_a_tag_or_a_ff: CHECK ((tag IS NOT NULL) AND (svf IS NULL OR tag IS NULL) AND (svf IS NOT NULL))

Indexes

Index Method Definition

match_set_quality_pkey PK

btree

CREATE UNIQUE INDEX match_set_quality_pkey ON vandelay.match_set_quality USING btree (id)

vmsq_def_once_per_set UNIQUE

btree

CREATE UNIQUE INDEX vmsq_def_once_per_set ON vandelay.match_set_quality USING btree (match_set, COALESCE(tag, ''::text), COALESCE(subfield, ''::text), COALESCE(svf, ''::text), value)
Previous
Next