Contains the details of user accounts such as their email, names, etc. It is not possible to soft delete these records – only hard deletes are supported in this table.
| Name | Type | Default | Nullable | Extra Definition | Children | Parents | Comment |
|---|---|---|---|---|---|---|---|
| country | varchar(255) | true | The country that the user has provided to the system. | ||||
| created_at | timestamp with time zone | now() | false | Timestamp when the record was created. | |||
| varchar(255) | false | User’s email | |||||
| email_communication_consent | boolean | false | false | Whether user has given consent to receive emails related to MOOC.fi courses and the development of the learning environment | |||
| first_name | varchar(255) | true | The first name that the user has provided to the system. | ||||
| last_name | varchar(255) | true | The last name that the user has provided to the system. | ||||
| search_helper | text | true | GENERATED ALWAYS AS lower(replace((((((((((user_id)::text | ’ ’::text) | |||
| 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. | |||
| user_id | uuid | false | public.users | The user this record belongs to. |
| Name | Type | Definition |
|---|---|---|
| user_details_email_check | CHECK | CHECK (((email)::text ~~ ‘%@%’::text)) |
| user_details_first_name_check | CHECK | CHECK ((TRIM(BOTH FROM first_name) <> ’’::text)) |
| user_details_last_name_check | CHECK | CHECK ((TRIM(BOTH FROM last_name) <> ’’::text)) |
| user_details_pkey | PRIMARY KEY | PRIMARY KEY (user_id) |
| user_details_user_id_fkey | FOREIGN KEY | FOREIGN KEY (user_id) REFERENCES users(id) |
| Name | Definition |
|---|---|
| user_details_pkey | CREATE UNIQUE INDEX user_details_pkey ON public.user_details USING btree (user_id) |
| user_details_search_helper_gist | CREATE INDEX user_details_search_helper_gist ON public.user_details USING gist (search_helper gist_trgm_ops) |
| user_details_search_helper_lower | CREATE INDEX user_details_search_helper_lower ON public.user_details USING btree (lower(search_helper)) |
| users_email | CREATE UNIQUE INDEX users_email ON public.user_details USING btree (lower((email)::text)) |
| Name | Definition |
|---|---|
| set_timestamp | CREATE TRIGGER set_timestamp BEFORE UPDATE ON public.user_details FOR EACH ROW EXECUTE FUNCTION trigger_set_timestamp() |
Generated by tbls