hr.user_session
Schema: hr
English table: hr.user_session
Italian original table: hr._session
Description: User sessions (authentication/session tracking).
Overview
- Columns: 13
- Primary key: id
- Outgoing foreign keys: 3
- Incoming foreign keys: 1
- Indexes: 6
Columns
| English column | Italian original column | Type | Null | Default / Generated | Description |
|---|---|---|---|---|---|
id | id | integer | NO | Surrogate primary key. | |
us_id | s_id | integer | NO | Logical session identifier (unique per tenant). | |
us_token | s_token | integer | NO | Session token (implementation-specific). | |
us_user_id | s_ut_id | integer | NO | User identifier (references users). | |
us_started_at | s_start | character varying(14) | NO | Session start timestamp stored as varchar(14), e.g. YYYYMMDDHH24MISS. | |
us_ended_at | s_end | character varying(14) | NO | Session end timestamp stored as varchar(14), e.g. YYYYMMDDHH24MISS. | |
us_ip_address | s_ip_address | character varying(15) | NO | IP address. | |
us_timeout_seconds | s_timeout | integer | NO | Session timeout in seconds. | |
us_language_id | s_lng_id | integer | YES | Language identifier (references languages). | |
us_session_id | s_sessionid | character varying(100) | NO | Application session id (string). | |
us_last_modified_at | s_last_modified | character varying(14) | NO | Last modification timestamp stored as varchar(14), e.g. YYYYMMDDHH24MISS. | |
us_path_language | s_path_language | character varying(100) | NO | Language path / routing language (implementation-specific). | |
tenant_id | tenant_id | integer | YES | Tenant identifier (multi-tenant isolation). |
Relationships
Outgoing foreign keys
| Constraint | Local columns | References | Referenced columns | On update | On delete |
|---|---|---|---|---|---|
fk_user_session_language | us_language_id, tenant_id | hr.languages | language_code_id, tenant_id | RESTRICT | RESTRICT |
fk_user_session_tenant | tenant_id | cloud.tenants | ten_internal_id | RESTRICT | CASCADE |
fk_user_session_user | us_user_id, tenant_id | hr.users | usr_id, tenant_id | RESTRICT | RESTRICT |
Referenced by
| From table | Foreign key | Source columns | Target columns |
|---|---|---|---|
hr.user_session_var | fk_user_session_var_session | usv_session_id, tenant_id | us_id, tenant_id |
Constraints
- Primary key:
user_session_pkey→id - Unique:
uk_us_id_tenant→us_id, tenant_id
Indexes
| Name | Unique | Method | Columns / expression |
|---|---|---|---|
idx_user_session_tenant | NO | btree | tenant_id |
idx_user_session_tenant_session_id | NO | btree | tenant_id, us_session_id |
idx_user_session_tenant_us_id | NO | btree | tenant_id, us_id |
idx_user_session_tenant_user_id | NO | btree | tenant_id, us_user_id |
idx_user_session_tenant_user_id_session_id | NO | btree | tenant_id, us_user_id, us_session_id |
idx_user_session_tenant_user_id_started_at | NO | btree | tenant_id, us_user_id, us_started_at DESC |
Navigation
- Back to main index
- [Back to
hrindex]../)