| business_id |
int8 |
19 |
√ |
|
null |
|
|
{“what”:“Identifier of the business being checked.”,“why”:“Links each check to a specific business; without it, checks can’t be attributed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:57.773893292+00:00”} |
| domain |
text |
2147483647 |
√ |
|
null |
|
|
{“what”:“Website domain (e.g., example.com) that was crawled.”,“why”:“Identifies the URL target; without it, we don’t know which site was tested.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:57.811646775+00:00”} |
| title |
text |
2147483647 |
√ |
|
null |
|
|
{“what”:“HTML text extracted from the crawled page.”,“why”:“Provides evidence of page content; without it, we can’t verify the site is the business’s own.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:57.833110599+00:00”}</p></td>
</tr>
<tr>
<td><span id="alive">alive</span></td>
<td>bool</td>
<td>1</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><p>{“what”:“Boolean flag indicating whether the domain responded successfully.”,“why”:“Distinguishes reachable from dead sites; without it, we can’t filter for live businesses.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:57.845291465+00:00”}</p></td>
</tr>
<tr>
<td><span id="checked_at">checked_at</span></td>
<td>timestamptz</td>
<td>35,6</td>
<td title='nullable'>√</td>
<td title=''></td>
<td>now()</td>
<td>
<table border='0' cellspacing='0' cellpadding='0'>
</table>
</td>
<td>
<table border='0' cellspacing='0' cellpadding='0'>
</table>
</td>
<td><p>{“what”:“Timestamp (with time zone) when the check was performed, defaults to now().”,“why”:“Records recency of the check; without it, we can’t know if data is stale.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:57.882311521+00:00”}</p></td>
</tr>
<tr>
<td><span id="attempts">attempts</span></td>
<td>int2</td>
<td>5</td>
<td title=''></td>
<td title=''></td>
<td>1</td>
<td>
<table border='0' cellspacing='0' cellpadding='0'>
</table>
</td>
<td>
<table border='0' cellspacing='0' cellpadding='0'>
</table>
</td>
<td><p>{“what”:“Number of retry attempts made for this check, default 1.”,“why”:“Tracks retry count; without it, we can’t distinguish single vs multiple tries, affecting reliability.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:57.905489196+00:00”}</p></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"
data-paging="true"
data-page-length="10"
data-length-change="false">
<thead>
<tr>
<th>Constraint Name</th>
<th>Type</th>
<th>Sort</th>
<th>Column(s)</th>
</tr>
</thead>
<tbody>
<tr>
<td class='uniqueKey' title='Unique Key'><i class='icon ion-key iconkey'></i> crawl_reachability_domain_key</td>
<td>Must be unique</td>
<td><span title='Ascending'>Asc</span></td>
<td>domain</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>
</ul>
<div class="tab-content no-padding">
<div class="chart tab-pane active" id="oneDegreeImg-chart" style="position: relative; overflow-x:auto;">
<a name='diagram'><object type="image/svg+xml" id="oneDegreeImg" data="../diagrams/tables/crawl_reachability.1degree.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.2.4</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> |