Index

public.course_module_completions_backup

Description

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
completion_date	timestamp with time zone		false
completion_granter_user_id	uuid		true
completion_language	varchar(15)		false
completion_registration_attempt_date	timestamp with time zone		true
course_id	uuid		false
course_instance_id	uuid		false
course_module_id	uuid		false
created_at	timestamp with time zone	now()	false
deleted_at	timestamp with time zone		true
eligible_for_ects	boolean		false
email	varchar(255)		false
grade	integer		true
id	uuid	uuid_generate_v4()	false
needs_to_be_reviewed	boolean	false	false
passed	boolean		false
prerequisite_modules_completed	boolean	false	false
updated_at	timestamp with time zone	now()	false
user_id	uuid		false

Constraints

Name	Type	Definition
course_module_completions_completion_date_not_null	n	NOT NULL completion_date
course_module_completions_completion_language_check	CHECK	CHECK (((completion_language)::text ~ ‘¹{2,3}(-[A-Z][a-z]{3})?-[A-Z]{2}$’::text))
course_module_completions_completion_language_not_null	n	NOT NULL completion_language
course_module_completions_course_id_not_null	n	NOT NULL course_id
course_module_completions_course_instance_id_not_null	n	NOT NULL course_instance_id
course_module_completions_course_module_id_not_null	n	NOT NULL course_module_id
course_module_completions_created_at_not_null	n	NOT NULL created_at
course_module_completions_eligible_for_ects_not_null	n	NOT NULL eligible_for_ects
course_module_completions_email_not_null	n	NOT NULL email
course_module_completions_id_not_null	n	NOT NULL id
course_module_completions_needs_to_be_reviewed_not_null	n	NOT NULL needs_to_be_reviewed
course_module_completions_passed_not_null	n	NOT NULL passed
course_module_completions_prerequisite_modules_complet_not_null	n	NOT NULL prerequisite_modules_completed
course_module_completions_updated_at_not_null	n	NOT NULL updated_at
course_module_completions_user_id_not_null	n	NOT NULL user_id

Relations

er

Generated by tbls

a-z↩︎