vandelay.match_set_point

↑ 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_point_id_seq'::regclass)

match_set FK

integer

Yes

→ vandelay.match_set(id)

parent FK

integer

Yes

→ vandelay.match_set_point(id)

bool_op

text

Yes

svf FK

text

Yes

→ config.record_attr_definition(name)

tag

text

Yes

subfield

text

Yes

negate

boolean

Yes

false

quality

integer

No

1

heading

boolean

No

false

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_point_match_set_fkey

parent

vandelay.match_set_point(id)

NO ACTION

NO ACTION

No

match_set_point_parent_fkey

svf

config.record_attr_definition(name)

NO ACTION

NO ACTION

No

match_set_point_svf_fkey

Check Constraints

  • match_set_point_bool_op_check: CHECK

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

  • vmsp_need_a_tag_or_a_ff_or_a_bo: CHECK ((tag IS NOT NULL) AND (svf IS NULL) AND (heading IS FALSE) AND (bool_op IS NULL OR tag IS NULL) AND (svf IS NOT NULL) AND (heading IS FALSE) AND (bool_op IS NULL OR tag IS NULL) AND (svf IS NULL) AND (heading IS TRUE) AND (bool_op IS NULL OR tag IS NULL) AND (svf IS NULL) AND (heading IS FALSE) AND (bool_op IS NOT NULL))

Indexes

Index Method Definition

match_set_point_pkey PK

btree

CREATE UNIQUE INDEX match_set_point_pkey ON vandelay.match_set_point USING btree (id)

Referenced By

The following tables have foreign keys pointing to vandelay.match_set_point (1 referencing table(s)):

Table Referencing Column(s) Referenced Column(s) Constraint

vandelay.match_set_point

parent

id

match_set_point_parent_fkey
Previous
Next