asset.uri :: EVG Database

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default
id PK	`integer`	No	nextval('asset.uri_id_seq'::regclass)
href	`text`	No
label	`text`	Yes
use_restriction	`text`	Yes
active	`boolean`	No	true

id PK

integer

No

nextval('asset.uri_id_seq'::regclass)

href

text

No

label

text

Yes

use_restriction

text

Yes

active

boolean

No

true

(id)

Index Method Definition

Index	Method	Definition
`uri_pkey` PK	btree	`CREATE UNIQUE INDEX uri_pkey ON asset.uri USING btree (id)`

uri_pkey PK

btree

CREATE UNIQUE INDEX uri_pkey ON asset.uri USING btree (id)

The following tables have foreign keys pointing to asset.uri (2 referencing table(s)):

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

Table	Referencing Column(s)	Referenced Column(s)	Constraint
asset.uri_call_number_map	`uri`	`id`	`uri_call_number_map_uri_fkey`
serial.item	`uri`	`id`	`item_uri_fkey`

uri

id

uri_call_number_map_uri_fkey

uri

id

item_uri_fkey