blob: 52130e05fbc5825882e46f0d8ad8469acb48fcbe [file] [log] [blame]
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<title>scheduled_email_campaign - fineract_default Database</title>
<!-- Tell the browser to be responsive to screen width -->
<meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no" name="viewport">
<link rel="icon" type="image/png" sizes="16x16" href="../favicon.png">
<!-- Bootstrap 3.3.5 -->
<link rel="stylesheet" href="../bower/admin-lte/bootstrap/css/bootstrap.min.css">
<!-- Font Awesome -->
<link rel="stylesheet" href="../bower/font-awesome/css/font-awesome.min.css">
<!-- Ionicons -->
<link rel="stylesheet" href="../bower/ionicons/css/ionicons.min.css">
<!-- DataTables -->
<link rel="stylesheet" href="../bower/datatables.net-bs/css/dataTables.bootstrap.min.css">
<link rel="stylesheet" href="../bower/datatables.net-buttons-bs/css/buttons.bootstrap.min.css">
<!-- Code Mirror -->
<link rel="stylesheet" href="../bower/codemirror/codemirror.css">
<!-- Fonts -->
<link href='../fonts/indieflower/indie-flower.css' rel='stylesheet' type='text/css'>
<link href='../fonts/source-sans-pro/source-sans-pro.css' rel='stylesheet' type='text/css'>
<!-- Theme style -->
<link rel="stylesheet" href="../bower/admin-lte/dist/css/AdminLTE.min.css">
<!-- Salvattore -->
<link rel="stylesheet" href="../bower/salvattore/salvattore.css">
<!-- AdminLTE Skins. Choose a skin from the css/skins
folder instead of downloading all of them to reduce the load. -->
<link rel="stylesheet" href="../bower/admin-lte/dist/css/skins/_all-skins.min.css">
<!-- SchemaSpy -->
<link rel="stylesheet" href="../schemaSpy.css">
<!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries -->
<!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
<!--[if lt IE 9]>
<script src="../bower/html5shiv/html5shiv.min.js"></script>
<script src="../bower/respond/respond.min.js"></script>
<![endif]-->
</head>
<!-- ADD THE CLASS layout-top-nav TO REMOVE THE SIDEBAR. -->
<body class="hold-transition skin-blue layout-top-nav">
<div class="wrapper">
<header class="main-header">
<nav class="navbar navbar-static-top">
<div class="container">
<div class="navbar-header">
<a href="../index.html" class="navbar-brand"><b>fineract_default</b> Database</a>
<button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#navbar-collapse"><i class="fa fa-bars"></i></button>
</div>
<!-- Collect the nav links, forms, and other content for toggling -->
<div class="collapse navbar-collapse pull-left" id="navbar-collapse">
<ul class="nav navbar-nav">
<li><a href="../index.html">Tables <span class="sr-only">(current)</span></a></li>
<li><a href="../columns.html" title="All of the columns in the schema">Columns</a></li>
<li><a href="../constraints.html" title="Useful for diagnosing error messages that just give constraint name or number">Constraints</a></li>
<li><a href="../relationships.html" title="Diagram of table relationships">Relationships</a></li>
<li><a href="../orphans.html" title="View of tables with neither parents nor children">Orphan&nbsp;Tables</a></li>
<li><a href="../anomalies.html" title="Things that might not be quite right">Anomalies</a></li>
<li><a href="../routines.html" title="Procedures and functions">Routines</a></li>
</ul>
</div>
<!-- /.navbar-collapse -->
<!-- Navbar Right Menu -->
</div>
<!-- /.container-fluid -->
</nav>
</header>
<!-- Main content -->
<!-- Full Width Column -->
<div class="content-wrapper">
<!-- Content Header (Page header) -->
<section class="content-header">
<h1>scheduled_email_campaign</h1><p><span id="recordNumber">0</span> rows</p><br />
</section>
<!-- Main content -->
<section class="content">
<div class="box box-primary">
<div class="box-header with-border">
<span class="glyphicon glyphicon-list-alt" aria-hidden="true"></span>
<h3 id="Columns" class="box-title">Columns</h3>
<div class="box-tools pull-right">
<button type="button" class="btn btn-box-tool" data-widget="collapse"><i class="fa fa-minus"></i></button>
<button type="button" class="btn btn-box-tool" data-widget="remove"><i class="fa fa-times"></i></button>
</div>
</div>
<div class="box-body">
<table id="standard_table" class="table table-bordered table-striped dataTable" role="grid">
<thead align='left'>
<tr>
<th>Column</th>
<th>Type</th>
<th>Size</th>
<th title='Are nulls allowed?'>Nulls</th>
<th title='Is column automatically updated?'>Auto</th>
<th title='Default value'>Default</th>
<th title='Columns in tables that reference this column'>Children</th>
<th title='Columns in tables that are referenced by this column'>Parents</th>
<th title='Comments' class="toggle"><span>Comments</span></th>
</tr>
</thead>
<tbody>
<tr>
<td class='primaryKey' title='Primary Key'><i class='icon ion-key iconkey' style='padding-left: 5px;'></i><span id="id">id</span></td>
<td>BIGINT</td>
<td>19</td>
<td title=''></td>
<td title='Automatically updated by the database'></td>
<td>null</td>
<td>
<table border='0' cellspacing='0' cellpadding='0'>
<tr>
<td title="scheduled_email_messages_outbound.email_campaign_id references scheduled_email_campaign.id via fk_schedule_email_campign1"><a href='scheduled_email_messages_outbound.html'>scheduled_email_messages_outbound</a><span class='relatedKey'>.email_campaign_id</span></td>
<td class="constraint detail">fk_schedule_email_campign1<span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
</tr>
</table>
</td>
<td>
<table border='0' cellspacing='0' cellpadding='0'>
</table>
</td>
<td></td>
</tr>
<tr>
<td><span id="campaign_name">campaign_name</span></td>
<td>VARCHAR</td>
<td>100</td>
<td title=''></td>
<td title=''></td>
<td>null</td>
<td>
<table border='0' cellspacing='0' cellpadding='0'>
</table>
</td>
<td>
<table border='0' cellspacing='0' cellpadding='0'>
</table>
</td>
<td></td>
</tr>
<tr>
<td><span id="campaign_type">campaign_type</span></td>
<td>INT</td>
<td>10</td>
<td title=''></td>
<td title=''></td>
<td>null</td>
<td>
<table border='0' cellspacing='0' cellpadding='0'>
</table>
</td>
<td>
<table border='0' cellspacing='0' cellpadding='0'>
</table>
</td>
<td></td>
</tr>
<tr>
<td><span id="business_rule_id">business_rule_id</span></td>
<td>INT</td>
<td>10</td>
<td title='nullable'></td>
<td title=''></td>
<td>NULL</td>
<td>
<table border='0' cellspacing='0' cellpadding='0'>
</table>
</td>
<td>
<table border='0' cellspacing='0' cellpadding='0'>
</table>
</td>
<td></td>
</tr>
<tr>
<td><span id="param_value">param_value</span></td>
<td>TEXT</td>
<td>65535</td>
<td title='nullable'></td>
<td title=''></td>
<td>NULL</td>
<td>
<table border='0' cellspacing='0' cellpadding='0'>
</table>
</td>
<td>
<table border='0' cellspacing='0' cellpadding='0'>
</table>
</td>
<td></td>
</tr>
<tr>
<td><span id="status_enum">status_enum</span></td>
<td>INT</td>
<td>10</td>
<td title=''></td>
<td title=''></td>
<td>null</td>
<td>
<table border='0' cellspacing='0' cellpadding='0'>
</table>
</td>
<td>
<table border='0' cellspacing='0' cellpadding='0'>
</table>
</td>
<td></td>
</tr>
<tr>
<td><span id="email_subject">email_subject</span></td>
<td>VARCHAR</td>
<td>100</td>
<td title=''></td>
<td title=''></td>
<td>null</td>
<td>
<table border='0' cellspacing='0' cellpadding='0'>
</table>
</td>
<td>
<table border='0' cellspacing='0' cellpadding='0'>
</table>
</td>
<td></td>
</tr>
<tr>
<td><span id="email_message">email_message</span></td>
<td>TEXT</td>
<td>65535</td>
<td title=''></td>
<td title=''></td>
<td>null</td>
<td>
<table border='0' cellspacing='0' cellpadding='0'>
</table>
</td>
<td>
<table border='0' cellspacing='0' cellpadding='0'>
</table>
</td>
<td></td>
</tr>
<tr>
<td><span id="email_attachment_file_format">email_attachment_file_format</span></td>
<td>VARCHAR</td>
<td>10</td>
<td title='nullable'></td>
<td title=''></td>
<td>NULL</td>
<td>
<table border='0' cellspacing='0' cellpadding='0'>
</table>
</td>
<td>
<table border='0' cellspacing='0' cellpadding='0'>
</table>
</td>
<td></td>
</tr>
<tr>
<td class='foreignKey' title='Foreign Key'><i class='icon ion-key iconkey' style='padding-left: 5px;'></i><span id="stretchy_report_id">stretchy_report_id</span></td>
<td>INT</td>
<td>10</td>
<td title='nullable'></td>
<td title=''></td>
<td>NULL</td>
<td>
<table border='0' cellspacing='0' cellpadding='0'>
</table>
</td>
<td>
<table border='0' cellspacing='0' cellpadding='0'>
<tr>
<td title="scheduled_email_campaign.stretchy_report_id references stretchy_report.id via scheduled_email_campaign_ibfk_1"><a href='stretchy_report.html'>stretchy_report</a><span class='relatedKey'>.id</span></td>
<td class="constraint detail">scheduled_email_campaign_ibfk_1<span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
</tr>
</table>
</td>
<td></td>
</tr>
<tr>
<td><span id="stretchy_report_param_map">stretchy_report_param_map</span></td>
<td>TEXT</td>
<td>65535</td>
<td title='nullable'></td>
<td title=''></td>
<td>NULL</td>
<td>
<table border='0' cellspacing='0' cellpadding='0'>
</table>
</td>
<td>
<table border='0' cellspacing='0' cellpadding='0'>
</table>
</td>
<td></td>
</tr>
<tr>
<td><span id="closedon_date">closedon_date</span></td>
<td>DATE</td>
<td>10</td>
<td title='nullable'></td>
<td title=''></td>
<td>NULL</td>
<td>
<table border='0' cellspacing='0' cellpadding='0'>
</table>
</td>
<td>
<table border='0' cellspacing='0' cellpadding='0'>
</table>
</td>
<td></td>
</tr>
<tr>
<td><span id="closedon_userid">closedon_userid</span></td>
<td>BIGINT</td>
<td>19</td>
<td title='nullable'></td>
<td title=''></td>
<td>NULL</td>
<td>
<table border='0' cellspacing='0' cellpadding='0'>
</table>
</td>
<td>
<table border='0' cellspacing='0' cellpadding='0'>
</table>
</td>
<td></td>
</tr>
<tr>
<td><span id="submittedon_date">submittedon_date</span></td>
<td>DATE</td>
<td>10</td>
<td title='nullable'></td>
<td title=''></td>
<td>NULL</td>
<td>
<table border='0' cellspacing='0' cellpadding='0'>
</table>
</td>
<td>
<table border='0' cellspacing='0' cellpadding='0'>
</table>
</td>
<td></td>
</tr>
<tr>
<td><span id="submittedon_userid">submittedon_userid</span></td>
<td>BIGINT</td>
<td>19</td>
<td title='nullable'></td>
<td title=''></td>
<td>NULL</td>
<td>
<table border='0' cellspacing='0' cellpadding='0'>
</table>
</td>
<td>
<table border='0' cellspacing='0' cellpadding='0'>
</table>
</td>
<td></td>
</tr>
<tr>
<td><span id="approvedon_date">approvedon_date</span></td>
<td>DATE</td>
<td>10</td>
<td title='nullable'></td>
<td title=''></td>
<td>NULL</td>
<td>
<table border='0' cellspacing='0' cellpadding='0'>
</table>
</td>
<td>
<table border='0' cellspacing='0' cellpadding='0'>
</table>
</td>
<td></td>
</tr>
<tr>
<td><span id="approvedon_userid">approvedon_userid</span></td>
<td>BIGINT</td>
<td>19</td>
<td title='nullable'></td>
<td title=''></td>
<td>NULL</td>
<td>
<table border='0' cellspacing='0' cellpadding='0'>
</table>
</td>
<td>
<table border='0' cellspacing='0' cellpadding='0'>
</table>
</td>
<td></td>
</tr>
<tr>
<td><span id="recurrence">recurrence</span></td>
<td>VARCHAR</td>
<td>100</td>
<td title='nullable'></td>
<td title=''></td>
<td>NULL</td>
<td>
<table border='0' cellspacing='0' cellpadding='0'>
</table>
</td>
<td>
<table border='0' cellspacing='0' cellpadding='0'>
</table>
</td>
<td></td>
</tr>
<tr>
<td><span id="next_trigger_date">next_trigger_date</span></td>
<td>DATETIME</td>
<td>19</td>
<td title='nullable'></td>
<td title=''></td>
<td>NULL</td>
<td>
<table border='0' cellspacing='0' cellpadding='0'>
</table>
</td>
<td>
<table border='0' cellspacing='0' cellpadding='0'>
</table>
</td>
<td></td>
</tr>
<tr>
<td><span id="last_trigger_date">last_trigger_date</span></td>
<td>DATETIME</td>
<td>19</td>
<td title='nullable'></td>
<td title=''></td>
<td>NULL</td>
<td>
<table border='0' cellspacing='0' cellpadding='0'>
</table>
</td>
<td>
<table border='0' cellspacing='0' cellpadding='0'>
</table>
</td>
<td></td>
</tr>
<tr>
<td><span id="recurrence_start_date">recurrence_start_date</span></td>
<td>DATETIME</td>
<td>19</td>
<td title='nullable'></td>
<td title=''></td>
<td>NULL</td>
<td>
<table border='0' cellspacing='0' cellpadding='0'>
</table>
</td>
<td>
<table border='0' cellspacing='0' cellpadding='0'>
</table>
</td>
<td></td>
</tr>
<tr>
<td><span id="is_visible">is_visible</span></td>
<td>BIT</td>
<td>1</td>
<td title='nullable'></td>
<td title=''></td>
<td>b&#39;1&#39;</td>
<td>
<table border='0' cellspacing='0' cellpadding='0'>
</table>
</td>
<td>
<table border='0' cellspacing='0' cellpadding='0'>
</table>
</td>
<td></td>
</tr>
<tr>
<td><span id="previous_run_error_log">previous_run_error_log</span></td>
<td>TEXT</td>
<td>65535</td>
<td title='nullable'></td>
<td title=''></td>
<td>NULL</td>
<td>
<table border='0' cellspacing='0' cellpadding='0'>
</table>
</td>
<td>
<table border='0' cellspacing='0' cellpadding='0'>
</table>
</td>
<td></td>
</tr>
<tr>
<td><span id="previous_run_error_message">previous_run_error_message</span></td>
<td>TEXT</td>
<td>65535</td>
<td title='nullable'></td>
<td title=''></td>
<td>NULL</td>
<td>
<table border='0' cellspacing='0' cellpadding='0'>
</table>
</td>
<td>
<table border='0' cellspacing='0' cellpadding='0'>
</table>
</td>
<td></td>
</tr>
<tr>
<td><span id="previous_run_status">previous_run_status</span></td>
<td>VARCHAR</td>
<td>10</td>
<td title='nullable'></td>
<td title=''></td>
<td>NULL</td>
<td>
<table border='0' cellspacing='0' cellpadding='0'>
</table>
</td>
<td>
<table border='0' cellspacing='0' cellpadding='0'>
</table>
</td>
<td></td>
</tr>
</tbody>
</table>
</div>
</div>
<div class="box box-primary">
<div class="box-header with-border">
<i class="fa fa-sitemap"></i>
<h3 id="Indexes" class="box-title">Indexes</h3>
<div class="box-tools pull-right">
<button type="button" class="btn btn-box-tool" data-widget="collapse"><i class="fa fa-minus"></i></button>
<button type="button" class="btn btn-box-tool" data-widget="remove"><i class="fa fa-times"></i></button>
</div>
</div>
<div class="box-body">
<table id="indexes_table" class="table table-bordered table-striped dataTable" role="grid">
<thead>
<tr>
<th>Constraint Name</th>
<th>Type</th>
<th>Sort</th>
<th>Column(s)</th>
</tr>
</thead>
<tbody>
<tr>
<td class='primaryKey' title='Primary Key'><i class='icon ion-key iconkey'></i> PRIMARY</td>
<td>Primary key</td>
<td><span title='Ascending'>Asc</span></td>
<td>id</td>
</tr>
<tr>
<td title='Indexed'>scheduled_email_campaign_ibfk_1</td>
<td>Performance</td>
<td><span title='Ascending'>Asc</span></td>
<td>stretchy_report_id</td>
</tr>
</tbody>
</table>
</div><!-- /.box-body -->
</div>
<div class="box box-primary">
<div class="box-header with-border">
<i class="fa fa-code-fork"></i>
<h3 id="Relationships" class="box-title">Relationships</h3>
<div class="box-tools pull-right">
<button type="button" class="btn btn-box-tool" data-widget="collapse"><i class="fa fa-minus"></i></button>
<button type="button" class="btn btn-box-tool" data-widget="remove"><i class="fa fa-times"></i></button>
</div>
</div>
<div class="box-body">
<div class="nav-tabs-custom"><!-- Tabs within a box -->
<h5>Close relationships within degrees of separation</h5>
<ul class="nav nav-tabs pull-left ui-sortable-handle">
<li class="active"><a href="#oneDegreeImg-chart" data-toggle="tab" aria-expanded="true">One</a></li>
<li class=""><a href="#twodegreesDegreeImg-chart" data-toggle="tab" aria-expanded="true">Two degrees</a></li>
</ul>
<div class="tab-content no-padding">
<div class="chart tab-pane active" id="oneDegreeImg-chart" style="position: relative; overflow-x:auto;">
<map id="oneDegreeRelationshipsDiagram" name="oneDegreeRelationshipsDiagram">
<area shape="rect" id="node1" href="../../tables/scheduled_email_campaign.html" target="_top" title="scheduled_email_campaign" alt="" coords="316,120,727,923">
<area shape="rect" id="node2" href="../../tables/stretchy_report.html" target="_top" title="stretchy_report" alt="" coords="5,387,272,533">
<area shape="rect" id="node3" href="../../tables/scheduled_email_messages_outbound.html" target="_top" title="scheduled_email_messages_outbound" alt="" coords="771,5,1160,240">
</map>
<a name='diagram'><object type="image/svg+xml" id="oneDegreeImg" data="../diagrams/tables/scheduled_email_campaign.1degree.svg" class="diagram" border="0" align="left"></object></a>
</div>
<div class="chart tab-pane " id="twodegreesDegreeImg-chart" style="position: relative; overflow-x:auto;">
<map id="twoDegreesRelationshipsDiagram" name="twoDegreesRelationshipsDiagram">
<area shape="rect" id="node1" href="../../tables/m_client.html" target="_top" title="m_client" alt="" coords="447,111,595,199">
<area shape="rect" id="node2" href="../../tables/m_staff.html" target="_top" title="m_staff" alt="" coords="69,111,209,199">
<area shape="rect" id="node3" href="../../tables/m_group.html" target="_top" title="m_group" alt="" coords="449,5,593,93">
<area shape="rect" id="node4" href="../../tables/m_report_mailing_job.html" target="_top" title="m_report_mailing_job" alt="" coords="405,1072,638,1160">
<area shape="rect" id="node5" href="../../tables/stretchy_report.html" target="_top" title="stretchy_report" alt="" coords="5,1121,272,1268">
<area shape="rect" id="node6" href="../../tables/scheduled_email_campaign.html" target="_top" title="scheduled_email_campaign" alt="" coords="316,252,727,1055">
<area shape="rect" id="node7" href="../../tables/scheduled_email_messages_outbound.html" target="_top" title="scheduled_email_messages_outbound" alt="" coords="771,69,1160,304">
<area shape="rect" id="node8" href="../../tables/sms_campaign.html" target="_top" title="sms_campaign" alt="" coords="429,1177,614,1265">
<area shape="rect" id="node9" href="../../tables/stretchy_report_parameter.html" target="_top" title="stretchy_report_parameter" alt="" coords="387,1283,655,1371">
</map>
<a name='diagram'><object type="image/svg+xml" id="twodegreesDegreeImg" data="../diagrams/tables/scheduled_email_campaign.2degrees.svg" class="diagram" border="0" align="left"></object></a>
</div>
</div>
</div>
</div><!-- /.box-body -->
</div>
</section>
<script>
var config = {
pagination: true
}
</script>
</div>
<!-- /.content-wrapper -->
<footer class="main-footer">
<div>
<div class="pull-right hidden-xs">
<a href="https://github.com/schemaspy/schemaspy" title="GitHub for SchemaSpy"><i class="fa fa-github-square fa-2x"></i></a>
<a href="http://stackoverflow.com/questions/tagged/schemaspy" title="StackOverflow for SchemaSpy"><i class="fa fa-stack-overflow fa-2x"></i></a>
</div>
<strong>Generated by <a href="http://schemaspy.org/" class="logo-text"><i class="fa fa-database"></i> SchemaSpy 6.1.0</a></strong>
</div>
<!-- /.container -->
</footer>
</div>
<!-- ./wrapper -->
<!-- jQuery 2.2.3 -->
<script src="../bower/admin-lte/plugins/jQuery/jquery-2.2.3.min.js"></script>
<script src="../bower/admin-lte/plugins/jQueryUI/jquery-ui.min.js"></script>
<!-- Bootstrap 3.3.5 -->
<script src="../bower/admin-lte/bootstrap/js/bootstrap.min.js"></script>
<!-- DataTables -->
<script src="../bower/datatables.net/jquery.dataTables.min.js"></script>
<script src="../bower/datatables.net-bs/js/dataTables.bootstrap.min.js"></script>
<script src="../bower/datatables.net-buttons/dataTables.buttons.min.js"></script>
<script src="../bower/datatables.net-buttons-bs/js/buttons.bootstrap.min.js"></script>
<script src="../bower/datatables.net-buttons/buttons.html5.min.js"></script>
<script src="../bower/datatables.net-buttons/buttons.print.min.js"></script>
<script src="../bower/datatables.net-buttons/buttons.colVis.min.js"></script>
<!-- SheetJS -->
<script src="../bower/js-xlsx/xlsx.full.min.js"></script>
<!-- pdfmake -->
<script src="../bower/pdfmake/pdfmake.min.js"></script>
<script src="../bower/pdfmake/vfs_fonts.js"></script>
<!-- SlimScroll -->
<script src="../bower/admin-lte/plugins/slimScroll/jquery.slimscroll.min.js"></script>
<!-- FastClick -->
<script src="../bower/admin-lte/plugins/fastclick/fastclick.js"></script>
<!-- Salvattore -->
<script src="../bower/salvattore/salvattore.min.js"></script>
<!-- AnchorJS -->
<script src="../bower/anchor-js/anchor.min.js"></script>
<!-- CodeMirror -->
<script src="../bower/codemirror/codemirror.js"></script>
<script src="../bower/codemirror/sql.js"></script>
<!-- AdminLTE App -->
<script src="../bower/admin-lte/dist/js/app.min.js"></script>
<script src="table.js"></script>
<script src="../schemaSpy.js"></script>
</body>
</html>