This table stores thresholds set by the instructor, representing the maximum score or duration a student can surpass before being suspected of cheating cheaters.
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| course_module_id | uuid | false | public.course_modules | The course module this threshold applies to. | ||
| 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. | |||
| duration_seconds | integer | false | The duration threshold in seconds. For the default course module (where name IS NULL), this represents the time from the start of the course until the completion of the course. For additional modules, this represents the time from the completion of the base module until the completion of the additional module. | |||
| id | uuid | uuid_generate_v4() | false | A unique, stable identifier for the record. | ||
| updated_at | timestamp with time zone | now() | false | Timestamp when the record was updated. |
| Name | Type | Definition |
|---|---|---|
| cheater_thresholds_course_module_id_fkey | FOREIGN KEY | FOREIGN KEY (course_module_id) REFERENCES course_modules(id) |
| cheater_thresholds_course_module_id_not_null | n | NOT NULL course_module_id |
| cheater_thresholds_created_at_not_null | n | NOT NULL created_at |
| cheater_thresholds_duration_seconds_not_null | n | NOT NULL duration_seconds |
| cheater_thresholds_id_not_null | n | NOT NULL id |
| cheater_thresholds_pkey | PRIMARY KEY | PRIMARY KEY (id) |
| cheater_thresholds_updated_at_not_null | n | NOT NULL updated_at |
| unique_course_module_id_constraint | UNIQUE | UNIQUE (course_module_id) |
| Name | Definition |
|---|---|
| cheater_thresholds_pkey | CREATE UNIQUE INDEX cheater_thresholds_pkey ON public.cheater_thresholds USING btree (id) |
| unique_course_module_id_constraint | CREATE UNIQUE INDEX unique_course_module_id_constraint ON public.cheater_thresholds USING btree (course_module_id) |
| Name | Definition |
|---|---|
| set_timestamp | CREATE TRIGGER set_timestamp BEFORE UPDATE ON public.cheater_thresholds FOR EACH ROW EXECUTE FUNCTION trigger_set_timestamp() |
Generated by tbls