ERP 2.50:Developers Guide/Database Model/org.openbravo.model.ad.access/AD Session
Contents
|
AD_Session
History of Online or Web Sessions
- Name:ADSession
- Classname:Session
This table contains the following columns:
| Name | Nullable | Data Type | Description |
| AD_Session_ID | N | VARCHAR2(32) | User Session Online or Web |
| AD_Client_ID | N | VARCHAR2(32) | Client for this installation. |
| AD_Org_ID | N | VARCHAR2(32) | Organizational entity within client |
| IsActive | N | CHAR(1) | A flag indicating whether this record is available for use or de-activated. |
| Created | N | DATE | Time when the session started |
| CreatedBy | N | VARCHAR2(32) | User who created this records |
| Updated | N | DATE | x not implemented |
| UpdatedBy | N | VARCHAR2(32) | User who updated this records |
| WebSession | Y | VARCHAR2(40) | Web Session ID |
| Remote_Addr | Y | NVARCHAR2(60) | not part of task |
| Remote_Host | Y | NVARCHAR2(120) | not part of task |
| Processed | N | CHAR(1) | A confirmation that the associated documents or requests are processed. |
| Session_Active | N | CHAR(1) | Session Active |
| Server_Url | Y | VARCHAR2(255) | URL for the context the session is in |
| Last_Session_Ping | Y | DATE | Time for the last time the session sent ping |
| Username | Y | VARCHAR2(60) | User Name |
| Login_Status | Y | VARCHAR2(60) | Login Status |
Other Info
Check constraints
These are the check constraints for this table:
- AD_SESSION_ACTIVE_CHK: SESSION_ACTIVE IN ('Y', 'N')
Indexes
These are the indexes for this table (for each index there is a list of all the columns included within it):
Non Unique
- AD_SESSION_USER_IDX
Unique
- AD_SESSION_KEY
Columns
Session
Online or Web Session Information
- Physical column name: AD_Session_ID
- Property Name: id
- Reference: ID
- This column is part of the table's identifier
Client
- Physical column name: AD_Client_ID
- Property Name: client
- Reference: TableDir
- Default value: @AD_CLIENT_ID@
Foreign key column to AD_Client table, (column: AD_Client_ID)
Validation Rule AD_Client Security validation: Clients with user access rights. With the following code:
AD_Client.AD_Client_ID IN (@#User_Client@)
Organization
- Physical column name: AD_Org_ID
- Property Name: organization
- Reference: TableDir
- Default value: @AD_Org_ID@
Foreign key column to AD_Org table, (column: AD_Org_ID)
Active
There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reporting. There are two reasons for de-activating and not deleting records:
(1) The system requires the record for auditing purposes.
(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are existing invoices for it. By de-activating the Business Partner you prevent it from being used in future transactions.
- Physical column name: IsActive
- Property Name: active
- Reference: YesNo
Login time
Login time is the date and time when the session started.
- Physical column name: Created
- Property Name: creationDate
- Reference: DateTime
Created By
- Physical column name: CreatedBy
- Property Name: createdBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Updated
The Updated field indicates the date that this record was updated.
- Physical column name: Updated
- Property Name: updated
- Reference: DateTime
Updated By
- Physical column name: UpdatedBy
- Property Name: updatedBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Web Session
Web Session identifier
- Physical column name: WebSession
- Property Name: webSession
- Reference: String
Remote Address
The Remote Address indicates an alternative or external address.
- Physical column name: Remote_Addr
- Property Name: remoteAddress
- Reference: String
Remote Host
Remote Host
- Physical column name: Remote_Host
- Property Name: remoteHost
- Reference: String
Processed
The Processed checkbox indicates that a document has been processed.
- Physical column name: Processed
- Property Name: processed
- Reference: YesNo
Session_Active
Session Active indicates whether the session is currently active or not.
- Physical column name: Session_Active
- Property Name: sessionActive
- Reference: Button
- Default value: N
Server Url
URL for the context the session is in
- Physical column name: Server_Url
- Property Name: serverUrl
- Reference: String
Last Ping
Stores the last time the session made ping through the UI. In this way it is possible to determine whether the browser was closed without doing log out.
- Physical column name: Last_Session_Ping
- Property Name: lastPing
- Reference: DateTime
Username
Name that identifies the user in the System
- Physical column name: Username
- Property Name: username
- Reference: String
Login Status
Maintains the status for the log in. It determines whether there was any error in the log in.
- Physical column name: Login_Status
- Property Name: loginStatus
- Reference: List
List values: Session Login Status
The allowed values for this list are:
- CUR (Concurrent Users Limit Reached): Reached number of maximum concurrent users in the instance
- F (User/password fail): User and/or password was not correct
- IOBPS (Inacctive OBPS Instance)
- LBF (Last build failed)
- LU (Locked User)
- ME (Commercial module expired)
- RT (Restart Tomcat)
- S (Successfull): Sesion logged in successfully
- SUR (Soft Concurrent Users Reached): Reached the number of soft concurrent users
- WS (Web Service): Web Service Login