Visits to the registration page and check requests, per completion, recorded whether or not the completion has a ledger row or a linked student number yet. A row that starts waiting for an enrolment takes its group from here.
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| check_request_source | enrolment_check_source | true | Who asked for the check at last_check_requested_at. | |||
| course_module_completion_id | uuid | false | public.course_module_completions | The completion the signals are about. Unique among live rows. | ||
| created_at | timestamp with time zone | now() | false | Timestamp when the record was created. | ||
| deleted_at | timestamp with time zone | true | Timestamp when the record was deleted. If null, the record is not deleted. | |||
| id | uuid | uuid_generate_v4() | false | A unique, stable identifier for the record. | ||
| last_check_requested_at | timestamp with time zone | true | When a check was last asked for: by the student, by a teacher, or by linking a student number from a roster mail. | |||
| last_visited_at | timestamp with time zone | true | When the student last opened the registration page after completing, while it showed the enrolment instructions. | |||
| updated_at | timestamp with time zone | now() | false | Timestamp when the record was last updated. The field is updated automatically by the set_timestamp trigger. |
| Name | Type | Definition |
|---|---|---|
| credit_registration_enrolm_course_module_completion_i_not_null1 | n | NOT NULL course_module_completion_id |
| credit_registration_enrolment_check_signals_created_at_not_null | n | NOT NULL created_at |
| credit_registration_enrolment_check_signals_id_not_null | n | NOT NULL id |
| credit_registration_enrolment_check_signals_pkey | PRIMARY KEY | PRIMARY KEY (id) |
| credit_registration_enrolment_check_signals_request_source | CHECK | CHECK ((((last_check_requested_at IS NULL) = (check_request_source IS NULL)) AND (check_request_source IS DISTINCT FROM ‘schedule’::enrolment_check_source) AND (check_request_source IS DISTINCT FROM ‘roster_listing’::enrolment_check_source) AND (check_request_source IS DISTINCT FROM ‘admin_request’::enrolment_check_source))) |
| credit_registration_enrolment_check_signals_updated_at_not_null | n | NOT NULL updated_at |
| credit_registration_enrolment_course_module_completion_id_fkey1 | FOREIGN KEY | FOREIGN KEY (course_module_completion_id) REFERENCES course_module_completions(id) |
| Name | Definition |
|---|---|
| credit_registration_enrolment_check_signals_pkey | CREATE UNIQUE INDEX credit_registration_enrolment_check_signals_pkey ON public.credit_registration_enrolment_check_signals USING btree (id) |
| uq_credit_registration_enrolment_check_signals_completion | CREATE UNIQUE INDEX uq_credit_registration_enrolment_check_signals_completion ON public.credit_registration_enrolment_check_signals USING btree (course_module_completion_id, deleted_at) NULLS NOT DISTINCT |
| Name | Definition |
|---|---|
| set_timestamp | CREATE TRIGGER set_timestamp BEFORE UPDATE ON public.credit_registration_enrolment_check_signals FOR EACH ROW EXECUTE FUNCTION trigger_set_timestamp() |
Generated by tbls