asset.course_module_term

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('asset.course_module_term_id_seq'::regclass)
name	`text`	No
owning_lib FK	`integer`	Yes		→ actor.org_unit(id)
start_date	`timestamp with time zone`	Yes
end_date	`timestamp with time zone`	Yes

id PK

integer

nextval('asset.course_module_term_id_seq'::regclass)

name

text

owning_lib FK

integer

Yes

start_date

timestamp with time zone

Yes

end_date

timestamp with time zone

Yes

(id)

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`owning_lib`	actor.org_unit(id)	NO ACTION	NO ACTION	No	`course_module_term_owning_lib_fkey`

owning_lib

NO ACTION

course_module_term_owning_lib_fkey

Index Method Definition

Index	Method	Definition
`course_module_term_pkey` PK	btree	`CREATE UNIQUE INDEX course_module_term_pkey ON asset.course_module_term USING btree (id)`
`cmt_once_per_owning_lib` UNIQUE	btree	`CREATE UNIQUE INDEX cmt_once_per_owning_lib ON asset.course_module_term USING btree (owning_lib, name)`

course_module_term_pkey PK

btree

CREATE UNIQUE INDEX course_module_term_pkey ON asset.course_module_term USING btree (id)

cmt_once_per_owning_lib UNIQUE

btree

CREATE UNIQUE INDEX cmt_once_per_owning_lib ON asset.course_module_term USING btree (owning_lib, name)

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

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

Table	Referencing Column(s)	Referenced Column(s)	Constraint
asset.course_module_term_course_map	`term`	`id`	`course_module_term_course_map_term_fkey`

term

id

course_module_term_course_map_term_fkey