login_customer Table (298)
•
Environment: onsite, online
Some tooltip text!
• 2 minutes to read
• 2 minutes to read
This table contains entries for customer sessions. At first only used for Soap logins, but will later also be used for web logins
Fields
Name | Description | Type | Null |
---|---|---|---|
id | The primary key (auto-incremented) | PK | |
customer_id | The id of the customer this entry references. | FK person | |
session_key | A random 32 characters value used as authentication key for the session. | String(32) | |
expire | The last time this session was active. | DateTime | ● |
seconds_to_live | The session key will expire after a given number of seconds. | Int | |
remote_addr | For future use: The IP address of the client for this session. | String(64) | ● |
remote_host | For future use: The hostname (depending on whether reverse lookup is enabled in httpd) or IP address of the client for this session. | String(64) | ● |
error_message | Stores the last error message recorded on this session | String(255) | ● |
origin | 1=soap call, 2=customer pages | Int | |
created_at | When the entry was created | DateTime | ● |
Indexes
Fields | Types | Description |
---|---|---|
id | PK | Clustered, Unique |
customer_id | FK | Index |
session_key | String(32) | Index |
origin | Int | Index |
Relationships
Table | Description |
---|---|
person | Persons in a company or an organizations. All associates have a corresponding person record |
Replication Flags
- None
Security Flags
- No access control via user's Role.