Index

public.users

Description

Either students, teachers or staff.

Columns

Name Type Default Nullable Children Parents Comment
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.chapter_lock_action_logs public.code_giveaway_codes public.course_background_question_answers public.course_designer_plan_events public.course_designer_plan_members public.course_designer_plan_stage_tasks public.course_designer_plans 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.email_verification_tokens public.error_occurrences 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.oauth_access_tokens public.oauth_auth_codes public.oauth_refresh_tokens public.oauth_user_client_scopes public.offered_answers_to_peer_review_temporary public.page_history public.password_reset_tokens 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_chapter_locking_statuses public.user_course_exercise_service_variables public.user_course_settings public.user_details public.user_email_codes public.user_exercise_states public.user_marketing_consents public.user_passwords 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.

Constraints

Name Type Definition
users_created_at_not_null n NOT NULL created_at
users_email_domain_check CHECK CHECK ((TRIM(BOTH FROM email_domain) <> ’’::text))
users_id_not_null n NOT NULL id
users_pkey PRIMARY KEY PRIMARY KEY (id)
users_updated_at_not_null n NOT NULL updated_at

Indexes

Name Definition
users_pkey CREATE UNIQUE INDEX users_pkey ON public.users USING btree (id)
users_upstream_id_idx CREATE INDEX users_upstream_id_idx ON public.users USING btree (upstream_id)

Triggers

Name Definition
set_timestamp CREATE TRIGGER set_timestamp BEFORE UPDATE ON public.users FOR EACH ROW EXECUTE FUNCTION trigger_set_timestamp()

Relations

er

Generated by tbls