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.