action.eresource_link_click_course

Cascading Deletes: Rows in this table will be automatically deleted when rows are deleted from: action.eresource_link_click.

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('action.eresource_link_click_course_id_seq'::regclass)
click FK	`bigint`	No		→ action.eresource_link_click(id)
course FK	`integer`	Yes		→ asset.course_module_course(id)
course_name	`text`	No
course_number	`text`	No

id PK

integer

nextval('action.eresource_link_click_course_id_seq'::regclass)

click FK

bigint

course FK

integer

Yes

course_name

text

course_number

text

(id)

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`click`	action.eresource_link_click(id)	CASCADE	NO ACTION	No	`eresource_link_click_course_click_fkey`
`course`	asset.course_module_course(id)	SET NULL	CASCADE	No	`eresource_link_click_course_course_fkey`

click

CASCADE

NO ACTION

eresource_link_click_course_click_fkey

course

SET NULL

CASCADE

eresource_link_click_course_course_fkey

Index Method Definition

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

eresource_link_click_course_pkey PK

btree

CREATE UNIQUE INDEX eresource_link_click_course_pkey ON action.eresource_link_click_course USING btree (id)