Contacts (leads) belonging to members.
member INT UNSIGNED NOT NULL v5
The id of the member that the contact belongs to
firstname VARCHAR(40) v4.03
The first name of the contact.
lastname VARCHAR(40) v4.03
The last name of the contact.
phone VARCHAR(20) v4.03
The phone number of the contact.
timetocall VARCHAR(100) v4.03
Contact Best time to call
email VARCHAR(100) v4.03
The email address of the contact.
added INT UNSIGNED v3.21
The timestamp of the date/time the contact was added
address VARCHAR(100) v4.03
The postal address of the contact.
ip VARCHAR(30) v3.21
The IP of the contact when they first opted into a capture page.
status SMALLINT UNSIGNED DEFAULT 1 v3.21
The id of the primary contact group that the contact belongs to. If 0 it means the contact is inactive.
openedmail TINYINT v3.21
Number of times the contact has opened emails
tracking VARCHAR(50) v4.94
Tracking campaign the contact belongs to (if the URL they used to optin had tracking assigned to it).
capturepage VARCHAR(100) v4.94
The Capture Page which the contact used to optin
flag TINYINT v4.03
Number of Flag color(0-none)(1-Red)(2-Blue)(3-Green)(4-Brown)(5-Cyan)(6-Purple)(7-Grey)
password VARCHAR(40) v3.21
The password for the contact to use to login to password protected pages.
points SMALLINT UNSIGNED DEFAULT 0 v3.21
The total amount of points the contact has earned performing misc actions. These points are used for the scoreboard.
lastactive INT UNSIGNED DEFAULT 0 v3.21
A timestamp of the date/time of the last activity performed by the contact.