asset.course_module_term_course_map

↑ asset schema

Cascading Deletes: Deleting rows from this table will cascade to: asset.course_module_course, asset.course_module_term.

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`bigint`	No	nextval('asset.course_module_term_course_map_id_seq'::regclass)
term FK	`integer`	No		→ asset.course_module_term(id)
course FK	`integer`	No		→ asset.course_module_course(id)

id PK

bigint

nextval('asset.course_module_term_course_map_id_seq'::regclass)

term FK

integer

→ asset.course_module_term(id)

course FK

integer

→ asset.course_module_course(id)

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`course`	asset.course_module_course(id)	CASCADE	CASCADE	DEFERRED	`course_module_term_course_map_course_fkey`
`term`	asset.course_module_term(id)	CASCADE	CASCADE	DEFERRED	`course_module_term_course_map_term_fkey`

course

asset.course_module_course(id)

CASCADE

DEFERRED

course_module_term_course_map_course_fkey

term

asset.course_module_term(id)

CASCADE

DEFERRED

course_module_term_course_map_term_fkey

Indexes

Index Method Definition

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

course_module_term_course_map_pkey PK

btree

CREATE UNIQUE INDEX course_module_term_course_map_pkey ON asset.course_module_term_course_map USING btree (id)