| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| user_uuid | uuid | false | sr.user_role_member sr.participant sr.cloud_account_user | |||
| email_address | varchar(100) | false | ||||
| organization_uuid | uuid | true | sr.organization | |||
| auth_provider_id | varchar(100) | true | ||||
| first_name | varchar(100) | true | ||||
| last_name | varchar(100) | true | ||||
| phone | varchar(20) | true | ||||
| email_verified | boolean | false | false | |||
| registered | boolean | false | false | |||
| settings | jsonb | true | ||||
| ts_created | timestamp without time zone | (now() AT TIME ZONE 'utc'::text) | true | |||
| ts_modified | timestamp without time zone | (now() AT TIME ZONE 'utc'::text) | true | |||
| tags | jsonb | true | ||||
| job_title | varchar(50) | true | ||||
| ts_last_login | timestamp without time zone | (now() AT TIME ZONE 'utc'::text) | true |
| Name | Type | Definition |
|---|---|---|
| fk_organization | FOREIGN KEY | FOREIGN KEY (organization_uuid) REFERENCES sr.organization(organization_uuid) |
| user_pkey | PRIMARY KEY | PRIMARY KEY (user_uuid) |
| Name | Definition |
|---|---|
| user_pkey | CREATE UNIQUE INDEX user_pkey ON sr."user" USING btree (user_uuid) |
Generated by tbls