Server: mysql.puroparty.com

Database: puroparty

Table: email_jobs_lists

Structure Browse SQL Search Insert Export Operations Empty Drop

Links to
	InnoDB
jobid	-- 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