| 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. |
| email_domain |
varchar(255) |
|
true |
|
|
|
| id |
uuid |
uuid_generate_v4() |
false |
public.code_giveaway_codes public.course_background_question_answers public.course_instance_enrollments public.course_module_completion_registered_to_study_registries public.course_module_completions public.course_specific_consent_form_answers public.email_deliveries public.exam_enrollments public.exercise_reset_logs public.exercise_slide_submissions public.feedback public.file_uploads public.flagged_answers public.generated_certificates public.join_code_uses public.offered_answers_to_peer_review_temporary public.page_history public.peer_or_self_review_submissions public.peer_review_queue_entries public.proposed_page_edits public.regradings public.rejected_exercise_slide_submissions public.roles public.student_countries public.suspected_cheaters public.teacher_grading_decisions public.user_course_instance_exercise_service_variables public.user_course_settings public.user_details public.user_exercise_states public.user_marketing_consents public.user_research_consents |
|
A unique, stable identifier for the record. |
| 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. |
| upstream_id |
integer |
|
true |
|
|
User’s id in upstream system (currently TMC). It is used to interact with the upstream authentication system. Internally the preferred identifier is user.id. |
