eab_entry Table (315)
•
Environment: onsite, online
Some tooltip text!
• 1 minute to read
• 1 minute to read
This table contains eab (email address book) entries, i.e. an alias ('Ola Hansen') and an address ('ola@hansen.as').
Fields
| Name | Description | Type | Null |
|---|---|---|---|
| id | The primary key (auto-incremented) | PK | |
| folder_id | The id of the folder in which this entry is located. | FK eab_folder | |
| name | The name of this email address | String(64) | |
| email_address | The actual email address. | String(255) | ● |
| sms_number | The sms number for this person | String(255) | ● |
| dbi_agent_id | Integration agent (eJournal) | FK dbi_agent | |
| dbi_key | The primary key for the integrated entry in the external datasource. | String(255) | |
| dbi_last_syncronized | Last external syncronization. | DateTime | |
| dbi_last_modified | When the entry was last modified. | DateTime | |
| dbi_delete | This field is used for determin which entry to delete during a synchronization | Short | ● |
Indexes
| Fields | Types | Description |
|---|---|---|
| id | PK | Clustered, Unique |
| folder_id | FK | Index |
| name | String(64) | Index |
| dbi_agent_id | FK | Index |
| dbi_key | String(255) | Index |
| dbi_last_syncronized | DateTime | Index |
| dbi_last_modified | DateTime | Index |
Relationships
| Table | Description |
|---|---|
| dbi_agent | DBI agent settings |
| eab_folder | This table contains eab (email address book) folders, used for containing email addresses. |
Replication Flags
- None
Security Flags
- No access control via user's Role.