> ## Documentation Index
> Fetch the complete documentation index at: https://superofficeas-bugfix-ty-screen-designer-paradox.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# login_customer table

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

## 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

## Fields

| Name              | Description                                                                                                                          | Type                      | Nullable |
| ----------------- | ------------------------------------------------------------------------------------------------------------------------------------ | ------------------------- | :------: |
| id                | The primary key (auto-incremented)                                                                                                   | PK                        |    No    |
| customer\_id      | The id of the customer this entry references.                                                                                        | FK [person](./person.mdx) |    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   |

<img src="https://mintcdn.com/superofficeas-bugfix-ty-screen-designer-paradox/bBv7ep-d5A4oaYwj/media/loc/en/database/tables/login_customer.png?fit=max&auto=format&n=bBv7ep-d5A4oaYwj&q=85&s=932b867938f9e42cf932e2611c64ace7" alt="login_customer table relationship diagram" width="414" height="59" data-path="media/loc/en/database/tables/login_customer.png" />

## Indexes

| Fields       | Types      | Description |
| ------------ | ---------- | ----------- |
| customer\_id | FK         | Index       |
| session\_key | String(32) | Index       |
| origin       | Int        | Index       |

## Relationships

| Table              | Description |
| ------------------ | ----------- |
| [person](./person) | Persons     |

## Replication Flags

* None

## Security Flags

* No access control via user's Role.