asset.course_module_course_users

Cascading Deletes: Deleting rows from this table will cascade to: asset.course_module_role.

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('asset.course_module_course_users_id_seq'::regclass)
course FK	`integer`	No		→ asset.course_module_course(id)
usr FK	`integer`	No		→ actor.usr(id)
usr_role FK	`integer`	Yes		→ asset.course_module_role(id)

id PK

integer

nextval('asset.course_module_course_users_id_seq'::regclass)

course FK

integer

→ asset.course_module_course(id)

usr FK

integer

→ actor.usr(id)

usr_role FK

integer

Yes

→ asset.course_module_role(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)	NO ACTION	NO ACTION	No	`course_module_course_users_course_fkey`
`usr`	actor.usr(id)	NO ACTION	NO ACTION	No	`course_module_course_users_usr_fkey`
`usr_role`	asset.course_module_role(id)	CASCADE	CASCADE	DEFERRED	`course_module_course_users_usr_role_fkey`

course

asset.course_module_course(id)

NO ACTION

course_module_course_users_course_fkey

usr

actor.usr(id)

NO ACTION

course_module_course_users_usr_fkey

usr_role

asset.course_module_role(id)

CASCADE

DEFERRED

course_module_course_users_usr_role_fkey

Indexes

Index Method Definition

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

course_module_course_users_pkey PK

btree

CREATE UNIQUE INDEX course_module_course_users_pkey ON asset.course_module_course_users USING btree (id)