config.coded_value_map

↑ config schema

Cascading Deletes: Deleting rows from this table will cascade to: config.record_attr_definition.

Deferrable Constraints: The following FK constraints are deferrable — they are checked at transaction end, not statement end: coded_value_map_ctype_fkey.

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('config.coded_value_map_id_seq'::regclass)

ctype FK

text

No

→ config.record_attr_definition(name)

code

text

No

value

text

No

description

text

Yes

opac_visible

boolean

No

true

search_label

text

Yes

is_simple

boolean

No

false

concept_uri

text

Yes

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

ctype

config.record_attr_definition(name)

CASCADE

NO ACTION

DEFERRED

coded_value_map_ctype_fkey

Indexes

Index Method Definition

coded_value_map_pkey PK

btree

CREATE UNIQUE INDEX coded_value_map_pkey ON config.coded_value_map USING btree (id)

config_coded_value_map_ctype_idx

btree

CREATE INDEX config_coded_value_map_ctype_idx ON config.coded_value_map USING btree (ctype)

Referenced By

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

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

config.composite_attr_entry_definition

coded_value

id

composite_attr_entry_definition_coded_value_fkey
Previous
Next