action.eresource_link_click

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`bigint`	No	nextval('action.eresource_link_click_id_seq'::regclass)
clicked_at	`timestamp with time zone`	No	now()
url	`text`	Yes
record FK	`bigint`	No		→ biblio.record_entry(id)

id PK

bigint

nextval('action.eresource_link_click_id_seq'::regclass)

clicked_at

timestamp with time zone

now()

url

text

Yes

record FK

bigint

(id)

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`record`	biblio.record_entry(id)	NO ACTION	NO ACTION	No	`eresource_link_click_record_fkey`

record

NO ACTION

eresource_link_click_record_fkey

Index Method Definition

Index	Method	Definition
`eresource_link_click_pkey` PK	btree	`CREATE UNIQUE INDEX eresource_link_click_pkey ON action.eresource_link_click USING btree (id)`

eresource_link_click_pkey PK

btree

CREATE UNIQUE INDEX eresource_link_click_pkey ON action.eresource_link_click USING btree (id)

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

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

Table	Referencing Column(s)	Referenced Column(s)	Constraint
action.eresource_link_click_course	`click`	`id`	`eresource_link_click_course_click_fkey`

click

id

eresource_link_click_course_click_fkey