eab_entry Table (315)
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.