match_set_point

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('vandelay.match_set_point_id_seq'::regclass)
match_set_point.parent match_set_point_parent_fkey R
match_set int4 10 √ null
match_set.id match_set_point_match_set_fkey C
parent int4 10 √ null
match_set_point.id match_set_point_parent_fkey R
bool_op text 2147483647 √ null
svf text 2147483647 √ null
record_attr_definition.name match_set_point_svf_fkey R
tag text 2147483647 √ null
subfield text 2147483647 √ null
negate bool 1 √ false
quality int4 10 1
heading bool 1 false

Indexes

Constraint Name Type Sort Column(s)
match_set_point_pkey Primary key Asc id

Check Constraints

Constraint Name Constraint
vmsp_need_a_subfield_with_a_tag ((((tag IS NOT NULL) AND (subfield IS NOT NULL)) OR (tag IS NULL)))
match_set_point_bool_op_check (((bool_op IS NULL) OR (bool_op = ANY (ARRAY['AND'::text, 'OR'::text, 'NOT'::text]))))
vmsp_need_a_tag_or_a_ff_or_a_bo ((((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))))

Relationships

Close relationships within degrees of separation