The id of the member's current parent (aka Sponsor, aka Referrer)
The last name of the member
The email of the member
The username of the member
The member's default redirect URL. The redirect URL is the URL of the page a person is redirected to after they optin to a capture page.
The phone number of the member.
The password of the member. Stored with md5 encryption.
approvedTINYINT DEFAULT 0v3.21
The status of the member. If the value is 0 it means the member is inactive/suspended. If the value is greater than 0 it means the member is active. With a team system if the value of this field is 2 then it means the member belongs to the rotator.
addedINT UNSIGNED DEFAULT 0v3.21
The timestamp of the date/time the member was created
The postal street address of the member
The city the member lives in
The state the member lives in
The postal zipcode the member lives in
The country the member lives in
lastbroadcastINT UNSIGNED DEFAULT 0v3.21
The timestamp of the date on which the member sent his last broadcast email
originalparentINT UNSIGNED DEFAULT 1v5
The id of the member's original parent (aka Original Sponsor). The oparentid and parentid may contain different values when using a passup system or a matrix where a person's parent is not always the person that referred them.
failedloginsTINYINT DEFAULT 0v3.21
The amount consecutive failed login attempts the member has made.
The IP belonging to the member when they initially created their account
doubleoptinsettingsBIT(1) DEFAULT 0v5
Specifies whether or not the members capture pages require double optin where a new contact has to confirm their email before joining the mailing list. If set to 0 then they do not require double optin confirmation. If set to 1 they do require double op
contentgroupSMALLINT UNSIGNED DEFAULT 1v5
The id of the primary Content Group for this member
membershipSMALLINT UNSIGNED DEFAULT 1v3.21
The id of the membership which the member belongs to
Timestamp of the date which the member should perform his next payment. This is for internal purposes only and if manually modified it will not cause the payment to be made on the date specified.
The API key for the member to use to access their own API (v5.0)
contactnotifyBIT(1) DEFAULT 1v3.21
Set to 1 when the member wants to receive new contact notifications. If set to 0 the member will not receive new contact notifications.
languageSMALLINT UNSIGNED DEFAULT 1v3.21
The id of the language that the members area is translated into when the member is logged in.
The GoDaddy shopper id used when purchasing domain names.