asset.course_module_role

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default
id PK	`integer`	No	nextval('asset.course_module_role_id_seq'::regclass)
name	`text`	No
is_public	`boolean`	No	false

id PK

integer

nextval('asset.course_module_role_id_seq'::regclass)

name

text

is_public

boolean

false

(id)

Index Method Definition

Index	Method	Definition
`course_module_role_pkey` PK	btree	`CREATE UNIQUE INDEX course_module_role_pkey ON asset.course_module_role USING btree (id)`
`course_module_role_name_key` UNIQUE	btree	`CREATE UNIQUE INDEX course_module_role_name_key ON asset.course_module_role USING btree (name)`

course_module_role_pkey PK

btree

CREATE UNIQUE INDEX course_module_role_pkey ON asset.course_module_role USING btree (id)

course_module_role_name_key UNIQUE

btree

CREATE UNIQUE INDEX course_module_role_name_key ON asset.course_module_role USING btree (name)

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

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

Table	Referencing Column(s)	Referenced Column(s)	Constraint
asset.course_module_course_users	`usr_role`	`id`	`course_module_course_users_usr_role_fkey`

usr_role

id

course_module_course_users_usr_role_fkey