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 | ||||
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 |
Name | Type | Definition |
---|---|---|
course_module_completions_completion_language_check | CHECK | CHECK (((completion_language)::text ~ â1{2,3}(-[A-Z][a-z]{3})?-[A-Z]{2}$â::text)) |
Generated by tbls
a-zâŠī¸