Server:
mysql.puroparty.com
Database:
puroparty
Table:
email_form_lists
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
Links to
InnoDB
formid
--
email_autoresponders->autoresponderid
email_autoresponders->ownerid
email_autoresponders->name
email_autoresponders->subject
email_autoresponders->format
email_autoresponders->createdate
email_autoresponders->active
email_autoresponders->hoursaftersubscription
email_autoresponders->listid
email_autoresponders->tracklinks
email_autoresponders->trackopens
email_autoresponders->multipart
email_autoresponders->queueid
email_autoresponders->sendfromname
email_autoresponders->sendfromemail
email_autoresponders->replytoemail
email_autoresponders->bounceemail
email_autoresponders->charset
email_autoresponders->embedimages
email_autoresponders->to_firstname
email_autoresponders->to_lastname
email_autoresponders->autorespondersize
email_banned_emails->banid
email_banned_emails->list
email_banned_emails->emailaddress
email_banned_emails->bandate
email_customfield_lists->cflid
email_customfield_lists->fieldid
email_customfield_lists->listid
email_customfields->fieldid
email_customfields->name
email_customfields->createdate
email_customfields->ownerid
email_customfields->fieldtype
email_customfields->defaultvalue
email_customfields->required
email_form_customfields->formid
email_form_customfields->fieldid
email_form_customfields->fieldorder
email_form_lists->formid
email_form_lists->listid
email_form_pages->pageid
email_form_pages->formid
email_form_pages->pagetype
email_form_pages->url
email_form_pages->sendfromname
email_form_pages->sendfromemail
email_form_pages->replytoemail
email_form_pages->bounceemail
email_form_pages->emailsubject
email_forms->formid
email_forms->name
email_forms->design
email_forms->createdate
email_forms->chooseformat
email_forms->changeformat
email_forms->sendthanks
email_forms->requireconfirm
email_forms->ownerid
email_forms->formtype
email_forms->contactform
email_forms->usecaptcha
email_jobs->jobid
email_jobs->jobtime
email_jobs->lastupdatetime
email_jobs->queueid
email_jobs->fkid
email_jobs->ownerid
email_jobs->jobtype
email_jobs->jobstatus
email_jobs->fktype
email_jobs->approved
email_jobs->authorisedtosend
email_jobs->resendcount
email_jobs_lists->jobid
email_jobs_lists->listid
email_links->linkid
email_links->url
email_list_subscriber_bounces->bounceid
email_list_subscriber_bounces->subscriberid
email_list_subscriber_bounces->statid
email_list_subscriber_bounces->listid
email_list_subscriber_bounces->bouncetime
email_list_subscriber_bounces->bouncetype
email_list_subscriber_bounces->bouncerule
email_list_subscribers->subscriberid
email_list_subscribers->emailaddress
email_list_subscribers->listid
email_list_subscribers->confirmcode
email_list_subscribers->subscribedate
email_list_subscribers->domainname
email_list_subscribers->format
email_list_subscribers->confirmed
email_list_subscribers->requestdate
email_list_subscribers->requestip
email_list_subscribers->confirmdate
email_list_subscribers->confirmip
email_list_subscribers->bounced
email_list_subscribers->unsubscribed
email_list_subscribers->unsubscribeconfirmed
email_list_subscribers->formid
email_list_subscribers_unsubscribe->subscriberid
email_list_subscribers_unsubscribe->unsubscribetime
email_list_subscribers_unsubscribe->listid
email_list_subscribers_unsubscribe->statid
email_list_subscribers_unsubscribe->unsubscribeip
email_list_subscribers_unsubscribe->unsubscriberequesttime
email_list_subscribers_unsubscribe->unsubscriberequestip
email_list_subscribers_unsubscribe->unsubscribearea
email_lists->listid
email_lists->name
email_lists->createdate
email_lists->ownerid
email_lists->ownername
email_lists->owneremail
email_lists->bounceemail
email_lists->replytoemail
email_lists->bounceserver
email_lists->bounceusername
email_lists->bouncepassword
email_lists->extramailsettings
email_lists->companyname
email_lists->companyaddress
email_lists->companyphone
email_lists->format
email_lists->notifyowner
email_lists->imapaccount
email_lists->subscribecount
email_lists->unsubscribecount
email_lists->bouncecount
email_lists->processbounce
email_lists->agreedelete
email_log_system_administrator->logid
email_log_system_administrator->loguserid
email_log_system_administrator->logip
email_log_system_administrator->logdate
email_log_system_administrator->logtodo
email_log_system_system->logid
email_log_system_system->logtype
email_log_system_system->logmodule
email_log_system_system->logseverity
email_log_system_system->logsummary
email_log_system_system->logdate
email_module_tracker->statid
email_module_tracker->stattype
email_module_tracker->trackername
email_module_tracker->newsletterid
email_modules->modulename
email_modules->moduleversion
email_newsletters->newsletterid
email_newsletters->name
email_newsletters->ownerid
email_newsletters->format
email_newsletters->subject
email_newsletters->createdate
email_newsletters->active
email_newsletters->archive
email_queues->queueid
email_queues->queuetype
email_queues->recipient
email_queues->processed
email_queues->ownerid
email_queues->sent
email_queues->processtime
email_queues_sequence->id
email_queues_unsent->recipient
email_queues_unsent->queueid
email_queues_unsent->reasoncode
email_segments->segmentid
email_segments->segmentname
email_segments->createdate
email_segments->ownerid
email_settings->cronok
email_settings->cronrun1
email_settings->cronrun2
email_settings->database_version
email_stats_autoresponders->statid
email_stats_autoresponders->htmlrecipients
email_stats_autoresponders->textrecipients
email_stats_autoresponders->multipartrecipients
email_stats_autoresponders->bouncecount_soft
email_stats_autoresponders->bouncecount_hard
email_stats_autoresponders->bouncecount_unknown
email_stats_autoresponders->unsubscribecount
email_stats_autoresponders->autoresponderid
email_stats_autoresponders->linkclicks
email_stats_autoresponders->emailopens
email_stats_autoresponders->emailforwards
email_stats_autoresponders->emailopens_unique
email_stats_autoresponders->htmlopens
email_stats_autoresponders->htmlopens_unique
email_stats_autoresponders->textopens
email_stats_autoresponders->textopens_unique
email_stats_autoresponders->hiddenby
email_stats_autoresponders_recipients->statid
email_stats_autoresponders_recipients->autoresponderid
email_stats_autoresponders_recipients->send_status
email_stats_autoresponders_recipients->recipient
email_stats_autoresponders_recipients->reason
email_stats_autoresponders_recipients->sendtime
email_stats_emailforwards->forwardid
email_stats_emailforwards->forwardtime
email_stats_emailforwards->forwardip
email_stats_emailforwards->subscriberid
email_stats_emailforwards->statid
email_stats_emailforwards->subscribed
email_stats_emailforwards->listid
email_stats_emailforwards->emailaddress
email_stats_emailopens->openid
email_stats_emailopens->subscriberid
email_stats_emailopens->statid
email_stats_emailopens->opentime
email_stats_emailopens->openip
email_stats_emailopens->fromlink
email_stats_emailopens->opentype
email_stats_linkclicks->clickid
email_stats_linkclicks->subscriberid
email_stats_linkclicks->statid
email_stats_linkclicks->linkid
email_stats_linkclicks->clicktime
email_stats_linkclicks->clickip
email_stats_links->statid
email_stats_links->linkid
email_stats_newsletter_lists->listid
email_stats_newsletter_lists->statid
email_stats_newsletters->statid
email_stats_newsletters->queueid
email_stats_newsletters->jobid
email_stats_newsletters->starttime
email_stats_newsletters->sentby
email_stats_newsletters->finishtime
email_stats_newsletters->htmlrecipients
email_stats_newsletters->textrecipients
email_stats_newsletters->multipartrecipients
email_stats_newsletters->trackopens
email_stats_newsletters->tracklinks
email_stats_newsletters->bouncecount_soft
email_stats_newsletters->bouncecount_hard
email_stats_newsletters->bouncecount_unknown
email_stats_newsletters->unsubscribecount
email_stats_newsletters->newsletterid
email_stats_newsletters->sendfromname
email_stats_newsletters->sendfromemail
email_stats_newsletters->bounceemail
email_stats_newsletters->replytoemail
email_stats_newsletters->charset
email_stats_newsletters->sendsize
email_stats_newsletters->notifyowner
email_stats_newsletters->linkclicks
email_stats_newsletters->emailopens
email_stats_newsletters->emailforwards
email_stats_newsletters->emailopens_unique
email_stats_newsletters->htmlopens
email_stats_newsletters->htmlopens_unique
email_stats_newsletters->textopens
email_stats_newsletters->textopens_unique
email_stats_newsletters->hiddenby
email_stats_newsletters->sendtestmode
email_stats_sequence->id
email_stats_users->statid
email_stats_users->jobid
email_stats_users->queuetime
email_stats_users->userid
email_stats_users->queuesize
email_subscribers_data->subscriberid
email_subscribers_data->fieldid
email_subscribers_data->data
email_templates->templateid
email_templates->ownerid
email_templates->name
email_templates->format
email_templates->createdate
email_templates->active
email_templates->isglobal
email_user_access->id
email_user_access->userid
email_user_access->area
email_user_permissions->userid
email_user_permissions->area
email_user_permissions->subarea
email_user_stats_emailsperhour->summaryid
email_user_stats_emailsperhour->statid
email_user_stats_emailsperhour->userid
email_user_stats_emailsperhour->sendtime
email_user_stats_emailsperhour->emailssent
email_users->userid
email_users->username
email_users->password
email_users->admintype
email_users->listadmintype
email_users->segmentadmintype
email_users->emailaddress
email_users->usertimezone
email_users->createdate
email_users->lastloggedin
email_users->templateadmintype
email_users->status
email_users->fullname
email_users->editownsettings
email_users->maxlists
email_users->perhour
email_users->permonth
email_users->unlimitedmaxemails
email_users->maxemails
email_users->infotips
email_users->smtpserver
email_users->smtpusername
email_users->smtppassword
email_users->smtpport
email_users->forgotpasscode
email_users->usewysiwyg
email_users->xmlapi
email_users->xmltoken
email_users->gettingstarted
ON DELETE
--
CASCADE
SET NULL
NO ACTION
RESTRICT
ON UPDATE
--
CASCADE
SET NULL
NO ACTION
RESTRICT
listid
--
email_autoresponders->autoresponderid
email_autoresponders->ownerid
email_autoresponders->name
email_autoresponders->subject
email_autoresponders->format
email_autoresponders->createdate
email_autoresponders->active
email_autoresponders->hoursaftersubscription
email_autoresponders->listid
email_autoresponders->tracklinks
email_autoresponders->trackopens
email_autoresponders->multipart
email_autoresponders->queueid
email_autoresponders->sendfromname
email_autoresponders->sendfromemail
email_autoresponders->replytoemail
email_autoresponders->bounceemail
email_autoresponders->charset
email_autoresponders->embedimages
email_autoresponders->to_firstname
email_autoresponders->to_lastname
email_autoresponders->autorespondersize
email_banned_emails->banid
email_banned_emails->list
email_banned_emails->emailaddress
email_banned_emails->bandate
email_customfield_lists->cflid
email_customfield_lists->fieldid
email_customfield_lists->listid
email_customfields->fieldid
email_customfields->name
email_customfields->createdate
email_customfields->ownerid
email_customfields->fieldtype
email_customfields->defaultvalue
email_customfields->required
email_form_customfields->formid
email_form_customfields->fieldid
email_form_customfields->fieldorder
email_form_lists->formid
email_form_lists->listid
email_form_pages->pageid
email_form_pages->formid
email_form_pages->pagetype
email_form_pages->url
email_form_pages->sendfromname
email_form_pages->sendfromemail
email_form_pages->replytoemail
email_form_pages->bounceemail
email_form_pages->emailsubject
email_forms->formid
email_forms->name
email_forms->design
email_forms->createdate
email_forms->chooseformat
email_forms->changeformat
email_forms->sendthanks
email_forms->requireconfirm
email_forms->ownerid
email_forms->formtype
email_forms->contactform
email_forms->usecaptcha
email_jobs->jobid
email_jobs->jobtime
email_jobs->lastupdatetime
email_jobs->queueid
email_jobs->fkid
email_jobs->ownerid
email_jobs->jobtype
email_jobs->jobstatus
email_jobs->fktype
email_jobs->approved
email_jobs->authorisedtosend
email_jobs->resendcount
email_jobs_lists->jobid
email_jobs_lists->listid
email_links->linkid
email_links->url
email_list_subscriber_bounces->bounceid
email_list_subscriber_bounces->subscriberid
email_list_subscriber_bounces->statid
email_list_subscriber_bounces->listid
email_list_subscriber_bounces->bouncetime
email_list_subscriber_bounces->bouncetype
email_list_subscriber_bounces->bouncerule
email_list_subscribers->subscriberid
email_list_subscribers->emailaddress
email_list_subscribers->listid
email_list_subscribers->confirmcode
email_list_subscribers->subscribedate
email_list_subscribers->domainname
email_list_subscribers->format
email_list_subscribers->confirmed
email_list_subscribers->requestdate
email_list_subscribers->requestip
email_list_subscribers->confirmdate
email_list_subscribers->confirmip
email_list_subscribers->bounced
email_list_subscribers->unsubscribed
email_list_subscribers->unsubscribeconfirmed
email_list_subscribers->formid
email_list_subscribers_unsubscribe->subscriberid
email_list_subscribers_unsubscribe->unsubscribetime
email_list_subscribers_unsubscribe->listid
email_list_subscribers_unsubscribe->statid
email_list_subscribers_unsubscribe->unsubscribeip
email_list_subscribers_unsubscribe->unsubscriberequesttime
email_list_subscribers_unsubscribe->unsubscriberequestip
email_list_subscribers_unsubscribe->unsubscribearea
email_lists->listid
email_lists->name
email_lists->createdate
email_lists->ownerid
email_lists->ownername
email_lists->owneremail
email_lists->bounceemail
email_lists->replytoemail
email_lists->bounceserver
email_lists->bounceusername
email_lists->bouncepassword
email_lists->extramailsettings
email_lists->companyname
email_lists->companyaddress
email_lists->companyphone
email_lists->format
email_lists->notifyowner
email_lists->imapaccount
email_lists->subscribecount
email_lists->unsubscribecount
email_lists->bouncecount
email_lists->processbounce
email_lists->agreedelete
email_log_system_administrator->logid
email_log_system_administrator->loguserid
email_log_system_administrator->logip
email_log_system_administrator->logdate
email_log_system_administrator->logtodo
email_log_system_system->logid
email_log_system_system->logtype
email_log_system_system->logmodule
email_log_system_system->logseverity
email_log_system_system->logsummary
email_log_system_system->logdate
email_module_tracker->statid
email_module_tracker->stattype
email_module_tracker->trackername
email_module_tracker->newsletterid
email_modules->modulename
email_modules->moduleversion
email_newsletters->newsletterid
email_newsletters->name
email_newsletters->ownerid
email_newsletters->format
email_newsletters->subject
email_newsletters->createdate
email_newsletters->active
email_newsletters->archive
email_queues->queueid
email_queues->queuetype
email_queues->recipient
email_queues->processed
email_queues->ownerid
email_queues->sent
email_queues->processtime
email_queues_sequence->id
email_queues_unsent->recipient
email_queues_unsent->queueid
email_queues_unsent->reasoncode
email_segments->segmentid
email_segments->segmentname
email_segments->createdate
email_segments->ownerid
email_settings->cronok
email_settings->cronrun1
email_settings->cronrun2
email_settings->database_version
email_stats_autoresponders->statid
email_stats_autoresponders->htmlrecipients
email_stats_autoresponders->textrecipients
email_stats_autoresponders->multipartrecipients
email_stats_autoresponders->bouncecount_soft
email_stats_autoresponders->bouncecount_hard
email_stats_autoresponders->bouncecount_unknown
email_stats_autoresponders->unsubscribecount
email_stats_autoresponders->autoresponderid
email_stats_autoresponders->linkclicks
email_stats_autoresponders->emailopens
email_stats_autoresponders->emailforwards
email_stats_autoresponders->emailopens_unique
email_stats_autoresponders->htmlopens
email_stats_autoresponders->htmlopens_unique
email_stats_autoresponders->textopens
email_stats_autoresponders->textopens_unique
email_stats_autoresponders->hiddenby
email_stats_autoresponders_recipients->statid
email_stats_autoresponders_recipients->autoresponderid
email_stats_autoresponders_recipients->send_status
email_stats_autoresponders_recipients->recipient
email_stats_autoresponders_recipients->reason
email_stats_autoresponders_recipients->sendtime
email_stats_emailforwards->forwardid
email_stats_emailforwards->forwardtime
email_stats_emailforwards->forwardip
email_stats_emailforwards->subscriberid
email_stats_emailforwards->statid
email_stats_emailforwards->subscribed
email_stats_emailforwards->listid
email_stats_emailforwards->emailaddress
email_stats_emailopens->openid
email_stats_emailopens->subscriberid
email_stats_emailopens->statid
email_stats_emailopens->opentime
email_stats_emailopens->openip
email_stats_emailopens->fromlink
email_stats_emailopens->opentype
email_stats_linkclicks->clickid
email_stats_linkclicks->subscriberid
email_stats_linkclicks->statid
email_stats_linkclicks->linkid
email_stats_linkclicks->clicktime
email_stats_linkclicks->clickip
email_stats_links->statid
email_stats_links->linkid
email_stats_newsletter_lists->listid
email_stats_newsletter_lists->statid
email_stats_newsletters->statid
email_stats_newsletters->queueid
email_stats_newsletters->jobid
email_stats_newsletters->starttime
email_stats_newsletters->sentby
email_stats_newsletters->finishtime
email_stats_newsletters->htmlrecipients
email_stats_newsletters->textrecipients
email_stats_newsletters->multipartrecipients
email_stats_newsletters->trackopens
email_stats_newsletters->tracklinks
email_stats_newsletters->bouncecount_soft
email_stats_newsletters->bouncecount_hard
email_stats_newsletters->bouncecount_unknown
email_stats_newsletters->unsubscribecount
email_stats_newsletters->newsletterid
email_stats_newsletters->sendfromname
email_stats_newsletters->sendfromemail
email_stats_newsletters->bounceemail
email_stats_newsletters->replytoemail
email_stats_newsletters->charset
email_stats_newsletters->sendsize
email_stats_newsletters->notifyowner
email_stats_newsletters->linkclicks
email_stats_newsletters->emailopens
email_stats_newsletters->emailforwards
email_stats_newsletters->emailopens_unique
email_stats_newsletters->htmlopens
email_stats_newsletters->htmlopens_unique
email_stats_newsletters->textopens
email_stats_newsletters->textopens_unique
email_stats_newsletters->hiddenby
email_stats_newsletters->sendtestmode
email_stats_sequence->id
email_stats_users->statid
email_stats_users->jobid
email_stats_users->queuetime
email_stats_users->userid
email_stats_users->queuesize
email_subscribers_data->subscriberid
email_subscribers_data->fieldid
email_subscribers_data->data
email_templates->templateid
email_templates->ownerid
email_templates->name
email_templates->format
email_templates->createdate
email_templates->active
email_templates->isglobal
email_user_access->id
email_user_access->userid
email_user_access->area
email_user_permissions->userid
email_user_permissions->area
email_user_permissions->subarea
email_user_stats_emailsperhour->summaryid
email_user_stats_emailsperhour->statid
email_user_stats_emailsperhour->userid
email_user_stats_emailsperhour->sendtime
email_user_stats_emailsperhour->emailssent
email_users->userid
email_users->username
email_users->password
email_users->admintype
email_users->listadmintype
email_users->segmentadmintype
email_users->emailaddress
email_users->usertimezone
email_users->createdate
email_users->lastloggedin
email_users->templateadmintype
email_users->status
email_users->fullname
email_users->editownsettings
email_users->maxlists
email_users->perhour
email_users->permonth
email_users->unlimitedmaxemails
email_users->maxemails
email_users->infotips
email_users->smtpserver
email_users->smtpusername
email_users->smtppassword
email_users->smtpport
email_users->forgotpasscode
email_users->usewysiwyg
email_users->xmlapi
email_users->xmltoken
email_users->gettingstarted
ON DELETE
--
CASCADE
SET NULL
NO ACTION
RESTRICT
ON UPDATE
--
CASCADE
SET NULL
NO ACTION
RESTRICT