login Table (297)
•
Environment: onsite, online
Some tooltip text!
• 2 minutes to read
• 2 minutes to read
This table contains entries for the user sessions.
Fields
| Name | Description | Type | Null |
|---|---|---|---|
| id | The primary key (auto-incremented) | PK | |
| user_id | The id of the user this entry references. | FK ejuser | |
| session_key | A random 32 characters value used as authentication key for the session. | String(32) | |
| remote_addr | The IP address of the client for this session. | String(64) | ● |
| remote_host | The hostname (depending on whether reverse lookup is enabled in httpd) or IP address of the client for this session. | String(64) | ● |
| logged_in | When this session started. | DateTime | ● |
| idle | The last time this session was active. | DateTime | ● |
| status | The status (enum) for this session. | Int | |
| origin | 1=soap call, 2=web pages | Int | |
| error_message | Stores the last error message recorded on this session | String(255) | ● |
| authentication_type | The authentication type (enum) for this session. | authentication_type | ● |
| active_menu | The currently active (open) left-menu for this session. | Int | ● |
| ns_secret | Netserver login secret. | String(255) | ● |
| flags | Bitmask of flags for a service login session | Enum LoginFlags | ● |
Indexes
| Fields | Types | Description |
|---|---|---|
| id | PK | Clustered, Unique |
| 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.