login_customer table

login_customer Table (298)

This table contains entries for customer sessions. At first only used for Soap logins, but will later also be used for web logins

Name	Description	Type	Nullable
id	The primary key (auto-incremented)	PK	No
customer_id	The id of the customer this entry references.	FK person	No
session_key	A random 32 characters value used as authentication key for the session.	String(32)	No
expire	The last time this session was active.	DateTime	Yes
seconds_to_live	The session key will expire after a given number of seconds.	Int	No
remote_addr	For future use: The IP address of the client for this session.	String(64)	Yes
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)	Yes
error_message	Stores the last error message recorded on this session	String(255)	Yes
origin	1=soap call, 2=customer pages	Int	No
created_at	When the entry was created	DateTime	Yes

Table	Description
person	Persons