| socialLoginProvider | stringAuth provider (amazon) |
| socialLoginId | stringAuth provider-unique user id (for ex. facebook user id) |
| gaClientId | stringGoogle analytics cid |
| wizardState | stringVendor wizard state |
| conciergeUserId | string |
| mail_chimp_lists | ArrayMailChimp lists |
| mail_chimp_interests | ArrayMailChimp lists |
| mail_chimp_segments | ArrayMailChimp segments |
| vendorImage | |
| vendor | |
| cleanURLs | ArrayClean URLs |
| shippingMethods | ArrayShipping methods |
| vendorConfig | ArrayVendor config |
| vendorRoleRequested | booleanVendor role requested |
| paypalLogin | stringPaypal login (email) |
| firstName | stringPaypal first name |
| lastName | stringPaypal last name |
| paypalLoginStatus | stringPaypal login status |
| paypalConnectionStatus | stringPaypal login status |
| bankDetails | stringBank details |
| paypalMerchantId | stringPaypal merchant id |
| paypalPartnerReferralId | stringPaypal partner referral id |
| profileTransactions | ArrayProfileTransactions |
| lastShippingIdByVendor | ArrayLast shipping id (by order vendor) |
| specialRevshareFeeDst | stringRevshare fee value |
| hasSpecialRevshareFeeDst | booleanRevshare fee type flag |
| specialRevshareFeeShipping | stringRevshare fee shipping value |
| hasSpecialRevshareFeeShipping | booleanRevshare fee shipping type flag |
| companyFieldValues | ArrayValues |
| products | ArrayProducts |
| conversations | ArrayCoupons |
| profile_id | integerProfile unique ID |
| login | stringLogin (e-mail) |
| password | stringPassword |
| password_hint | stringPassword hint |
| password_hint_answer | stringPassword hint answer |
| passwordResetKey | stringPassword reset key (for 'Forgot password') |
| passwordResetKeyDate | integerTimestamp of reset key creation date |
| access_level | integerAccess level |
| cms_profile_id | integerCMS profile Id |
| cms_name | stringCMS name |
| added | integerTimestamp of profile creation date |
| first_login | integerTimestamp of first login event |
| last_login | integerTimestamp of last login event |
| status | stringProfile status |
| statusComment | stringStatus comment (reason) |
| referer | stringReferer |
| order | |
| event | ArrayRelation to an event |
| language | stringLanguage code |
| last_shipping_id | integerLast selected shipping id |
| last_payment_id | integerLast selected payment id |
| membership | object (Membership: many-to-one relation with memberships table)Membership: many-to-one relation with memberships table |
|
| pending_membership | object (Pending membership: many-to-one relation with memberships table)Pending membership: many-to-one relation with memberships table |
|
| addresses | ArrayAddress book: one-to-many relation with address book entity |
| roles | ArrayRoles |
| anonymous | booleanFlag of anonymous profile (used for checkout process only) |
| forceChangePassword | booleanFlag if the user needs to change the password.
The customers only |
| dateOfLoginAttempt | integerDate of last login attempt |
| countOfLoginAttempts | integerCount of login attempt |
| searchFakeField | stringFake field for search |
| xcPendingExport | booleanFlag to exporting entities |
| lastCheckoutEmail | stringCheckout email |