aboutsummaryrefslogtreecommitdiffstats
path: root/dbdocs/tables
diff options
context:
space:
mode:
authorterminaldweller <thabogre@gmail.com>2022-07-21 05:36:02 +0000
committerterminaldweller <thabogre@gmail.com>2022-07-21 05:36:02 +0000
commit85db7c5287ae58efc108263f7a40bdbd02de1a82 (patch)
tree8292d90db8999dabc2e3872ea75547cb7fcf0c2d /dbdocs/tables
parentchanged the max doc size to 40K characters.255 was not enough... (diff)
downloadmdrtl-85db7c5287ae58efc108263f7a40bdbd02de1a82.tar.gz
mdrtl-85db7c5287ae58efc108263f7a40bdbd02de1a82.zip
added docs for the db using schemaspy
Diffstat (limited to 'dbdocs/tables')
-rw-r--r--dbdocs/tables/doc.html267
-rw-r--r--dbdocs/tables/table.js85
2 files changed, 352 insertions, 0 deletions
diff --git a/dbdocs/tables/doc.html b/dbdocs/tables/doc.html
new file mode 100644
index 0000000..db9ab04
--- /dev/null
+++ b/dbdocs/tables/doc.html
@@ -0,0 +1,267 @@
+<!DOCTYPE html>
+<html>
+ <head>
+ <meta charset="utf-8">
+ <meta http-equiv="X-UA-Compatible" content="IE=edge">
+ <title>doc - spring 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>spring</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>doc</h1><p><span id="recordNumber">2</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>int8</td>
+ <td>19</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="body">body</span></td>
+ <td>varchar</td>
+ <td>10000</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_modified">last_modified</span></td>
+ <td>int8</td>
+ <td>19</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="name">name</span></td>
+ <td>varchar</td>
+ <td>255</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> doc_pkey</td>
+ <td>Primary key</td>
+ <td><span title='Ascending'>Asc</span></td>
+ <td>id</td>
+ </tr>
+ </tbody>
+ </table>
+ </div><!-- /.box-body -->
+ </div>
+ <div class="alert alert-warning alert-dismissible">
+ <button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button>
+ <h4><i class="icon fa fa-warning"></i>Diagram producer might be missing</h4>
+ <p>No diagrams were produced please see application output for any errors</p>
+ </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> \ No newline at end of file
diff --git a/dbdocs/tables/table.js b/dbdocs/tables/table.js
new file mode 100644
index 0000000..a07a96e
--- /dev/null
+++ b/dbdocs/tables/table.js
@@ -0,0 +1,85 @@
+$(document).ready(function() {
+ anchors.options.visible = 'always';
+ anchors.add('h3');
+
+ var table = $('#standard_table').DataTable( {
+ lengthChange: false,
+ ordering: false,
+ paging: config.pagination,
+ autoWidth: true,
+ buttons: [
+ {
+ text: 'Related columns',
+ action: function ( e, dt, node, config ) {
+ $(".relatedKey").toggle();
+ this.active( !this.active() );
+ table.columns.adjust().draw();
+ }
+ },
+ {
+ text: 'Constraint',
+ action: function ( e, dt, node, config ) {
+ $(".constraint").toggle();
+ this.active( !this.active() );
+ table.columns.adjust().draw();
+ }
+ },
+ {
+ extend: 'columnsToggle',
+ columns: '.toggle'
+ }
+ ]
+
+ } );
+ dataTableExportButtons(table);
+
+ if ($('#indexes_table').length) {
+ var indexes = $('#indexes_table').DataTable({
+ lengthChange: false,
+ paging: config.pagination,
+ ordering: false
+ });
+ dataTableExportButtons(indexes);
+ }
+
+ if ($('#check_table').length) {
+ var check = $('#check_table').DataTable( {
+ lengthChange: false,
+ paging: config.pagination,
+ ordering: false
+ } );
+ dataTableExportButtons(check);
+ }
+} );
+
+
+$(function() {
+ var $imgs = $('img.diagram, object.diagram');
+ $imgs.css("cursor", "move")
+ $imgs.draggable();
+});
+
+$.fn.digits = function(){
+ return this.each(function(){
+ $(this).text( $(this).text().replace(/(\d)(?=(\d\d\d)+(?!\d))/g, "1 ") );
+ })
+}
+
+$(function() {
+ $("#recordNumber").digits();
+});
+
+var codeElement = document.getElementById("sql-script-codemirror");
+var editor = null;
+if (null != codeElement) {
+ editor = CodeMirror.fromTextArea(codeElement, {
+ lineNumbers: true,
+ mode: 'text/x-sql',
+ indentWithTabs: true,
+ smartIndent: true,
+ lineNumbers: true,
+ matchBrackets: true,
+ autofocus: true,
+ readOnly: true
+ });
+}
generated by cgit v1.2.3 (git 2.25.1) at 2024-11-24 10:01:55 +0000