login Table (297)
This table contains entries for the user sessions.Fields
| Name | Description | Type | Nullable |
|---|---|---|---|
| id | The primary key (auto-incremented) | PK | No |
| user_id | The id of the user this entry references. | FK ejuser | No |
| session_key | A random 32 characters value used as authentication key for the session. | String(32) | No |
| remote_addr | The IP address of the client for this session. | String(64) | Yes |
| remote_host | The hostname (depending on whether reverse lookup is enabled in httpd) or IP address of the client for this session. | String(64) | Yes |
| logged_in | When this session started. | DateTime | Yes |
| idle | The last time this session was active. | DateTime | Yes |
| status | The status (enum) for this session. | Int | No |
| origin | 1=soap call, 2=web pages | Int | No |
| error_message | Stores the last error message recorded on this session | String(255) | Yes |
| authentication_type | The authentication type (enum) for this session. | authentication_type | Yes |
| active_menu | The currently active (open) left-menu for this session. | Int | Yes |
| ns_secret | Netserver login secret. | String(2000) | Yes |
| flags | Bitmask of flags for a service login session | Enum LoginFlags | Yes |
Indexes
| Fields | Types | Description |
|---|---|---|
| user_id | FK | Index |
| session_key | String(32) | Index |
| status | Int | Index |
| origin | Int | Index |
Relationships
| Table | Description |
|---|---|
| ejuser | This table contains entries for the users of the system. |
| extra_tables_result | Result set of executed search in ejournal extra tables |
| invoice_sum | This table is used temporarily when listing invoice statistics. It is used because we need to sort balances from both customers and companies. |
| session_object | Generic session object, accessible from ejscript etc, typically xml or name=value syntax, may be stored over several rows if big |
Replication Flags
- None
Security Flags
- No access control via user’s Role.