cloud.users
Schema: cloud
English table: cloud.users
Italian original table: cloud._users
Description: Central identity table for all individuals accessing the platform.
Overview
- Columns: 19
- Primary key: usr_user_id
- Outgoing foreign keys: 0
- Incoming foreign keys: 0
- Indexes: 0
Columns
| English column | Italian original column | Type | Null | Default / Generated | Description |
|---|---|---|---|---|---|
usr_user_id | us_id | uuid | NO | public.uuid_generate_v4() | Unique UUID for the user. |
usr_email | us_email | character varying | NO | Primary login identifier and contact email. | |
usr_password_hash | us_password | character varying | NO | Encrypted password string (Bcrypt/Argon2). | |
usr_user_type_id | us_tenant_id | smallint | NO | Classification of user (e.g., 1=SuperAdmin, 2=TenantAdmin, 3=Employee). | |
usr_avatar_url | us_user_type | character varying | YES | URL or path to the user's profile picture. | |
usr_last_name | us_avatar | character varying | NO | The legal last name (surname) of the user. | |
usr_first_name | us_last_name | character varying | NO | The legal first name of the user. | |
usr_language_id | us_first_name | smallint | NO | Reference to the preferred language (cloud.languages). | |
usr_ui_theme_config | us_language_id | character varying | YES | JSON string or code representing UI preferences (Dark/Light mode, colors). | |
usr_employee_code | us_theme_settings | character varying | YES | Optional company-specific payroll or identification code. | |
usr_address | us_personal_code | character varying | YES | Physical or residential address of the user. | |
usr_phone_number | us_address | character varying | YES | Contact phone number, preferably in E.164 format. | |
usr_status_code | us_phone | smallint | NO | Current account status (1=Active, 0=Inactive, 2=Pending). | |
usr_deactivated_at | us_status | timestamp without time zone | YES | Timestamp recorded when the user account was disabled. | |
usr_created_at | us_deactivation_timestamp | timestamp without time zone | YES | CURRENT_TIMESTAMP | Timestamp of user registration/creation. |
usr_updated_at | us_created_at | timestamp without time zone | YES | CURRENT_TIMESTAMP | Timestamp of the last update to the user profile or security settings. |
usr_password_expires_at | us_updated_at | timestamp without time zone | YES | Optional expiration date for the current password (security policy). | |
user_id | us_password_expire | integer | NO | Primary key of the user record. | |
usr_tenant_uuid | `` | integer | NO | UUID reference to the user's home tenant (cloud.tenants.ten_uuid). |
Relationships
Outgoing foreign keys
No outgoing foreign keys found.
Referenced by
No incoming foreign keys found.
Constraints
- Primary key:
pk_users→usr_user_id - Unique:
c_uk_usr_email→usr_email - Unique:
c_uk_usr_employee_code→usr_employee_code
Indexes
No indexes detected.
Navigation
- Back to main index
- [Back to
cloudindex]../)