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.