an electronic mail address associated to a short alias

schema CWUser CWUser login (String) upassword (Password) firstname (String) surname (String) last_login_time (TZDatetime) EmailAddress EmailAddress alias (String) CWUser->EmailAddress primary_email 0..1 0..1 CWUser->EmailAddress use_email 0..n 0..1 Email Email subject (String) date (Datetime) messageid (String) headers (String) Email->EmailAddress recipients 0..n 0..n Email->EmailAddress cc 0..n 0..n Email->EmailAddress sender 0..1 0..n Person Person name (String) Person->EmailAddress email_address 0..n 0..1 EmailAddress->EmailAddress prefered_form 0..1 0..n

Attributes

name (5)typedefault valuerequiredconstraintsdescriptionoptions
alias (alias)Stringnosize <= 56fulltext indexed
address (address)Stringyesunique
size <= 512
indexed,fulltext indexed
modification_date (modification date)International date and timeyes

latest modification time of an entity

cwuri (internal uri)Stringyes

internal entity uri

creation_date (creation date)International date and timeyes

creation time of an entity

Relations

EmailAddress is subject of:
name (6)object typecardinalityconstraintsoptions
created_by (created by)CWUser (User)0..1
cw_source (source)CWSource (Data source)1composite=object
is (is)CWEType (Entity type)1
is_instance_of (is instance of)CWEType (Entity type)1..n
owned_by (owned by)CWUser (User)0..n
prefered_form (prefered form)EmailAddress (Email address)0..1
EmailAddress is object of:
name (7)subject typecardinalityconstraintsoptions
cc (cc)Email (Email)0..n
email_address (email_address_object)Person (Person)0..ncomposite=subject
prefered_form (prefered over)EmailAddress (Email address)0..1
primary_email (primary email of)CWUser (User)0..1RQLConstraint(DISTINCT Any O,S WHERE S use_email O)
recipients (recipient of)Email (Email)0..n
sender (has sent)Email (Email)0..1inlined
use_email (used by)CWUser (User)0..nfulltext container=subject,composite=subject