diff options
Diffstat (limited to 'dbdocs/tables')
| -rw-r--r-- | dbdocs/tables/doc.html | 267 | ||||
| -rw-r--r-- | dbdocs/tables/table.js | 85 |
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 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 + }); +} |