anomalies.html (18115B)
1 <!DOCTYPE html> 2 <html> 3 <head> 4 <meta charset="utf-8"> 5 <meta http-equiv="X-UA-Compatible" content="IE=edge"> 6 <title>postgres.c2ec</title> 7 <!-- Tell the browser to be responsive to screen width --> 8 <meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no" name="viewport"> 9 <link rel="icon" type="image/png" sizes="16x16" href="favicon.png"> 10 <!-- Bootstrap 3.3.5 --> 11 <link rel="stylesheet" href="bower/admin-lte/bootstrap/css/bootstrap.min.css"> 12 <!-- Font Awesome --> 13 <link rel="stylesheet" href="bower/font-awesome/css/font-awesome.min.css"> 14 <!-- Ionicons --> 15 <link rel="stylesheet" href="bower/ionicons/css/ionicons.min.css"> 16 <!-- DataTables --> 17 <link rel="stylesheet" href="bower/datatables.net-bs/css/dataTables.bootstrap.min.css"> 18 <link rel="stylesheet" href="bower/datatables.net-buttons-bs/css/buttons.bootstrap.min.css"> 19 <!-- Code Mirror --> 20 <link rel="stylesheet" href="bower/codemirror/codemirror.css"> 21 <!-- Fonts --> 22 <link href='fonts/indieflower/indie-flower.css' rel='stylesheet' type='text/css'> 23 <link href='fonts/source-sans-pro/source-sans-pro.css' rel='stylesheet' type='text/css'> 24 25 <!-- Theme style --> 26 <link rel="stylesheet" href="bower/admin-lte/dist/css/AdminLTE.min.css"> 27 <!-- Salvattore --> 28 <link rel="stylesheet" href="bower/salvattore/salvattore.css"> 29 <!-- AdminLTE Skins. Choose a skin from the css/skins 30 folder instead of downloading all of them to reduce the load. --> 31 <link rel="stylesheet" href="bower/admin-lte/dist/css/skins/_all-skins.min.css"> 32 <!-- SchemaSpy --> 33 <link rel="stylesheet" href="schemaSpy.css"> 34 35 <!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries --> 36 <!-- WARNING: Respond.js doesn't work if you view the page via file:// --> 37 <!--[if lt IE 9]> 38 <script src="bower/html5shiv/html5shiv.min.js"></script> 39 <script src="bower/respond/respond.min.js"></script> 40 <![endif]--> 41 </head> 42 <!-- ADD THE CLASS layout-top-nav TO REMOVE THE SIDEBAR. --> 43 <body class="hold-transition skin-blue layout-top-nav"> 44 <div class="wrapper"> 45 <header class="main-header"> 46 <nav class="navbar navbar-static-top"> 47 <div class="container"> 48 <div class="navbar-header"> 49 <a href="index.html" class="navbar-brand"><b>postgres</b></a><span class="navbar-brand" style="padding-left: 0">.c2ec</span> 50 <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#navbar-collapse"><i class="fa fa-bars"></i></button> 51 </div> 52 53 <!-- Collect the nav links, forms, and other content for toggling --> 54 <div class="collapse navbar-collapse pull-left" id="navbar-collapse"> 55 <ul class="nav navbar-nav"> 56 <li><a href="index.html">Tables <span class="sr-only">(current)</span></a></li> 57 <li><a href="columns.html" title="All of the columns in the schema">Columns</a></li> 58 <li><a href="constraints.html" title="Useful for diagnosing error messages that just give constraint name or number">Constraints</a></li> 59 <li><a href="relationships.html" title="Diagram of table relationships">Relationships</a></li> 60 <li><a href="orphans.html" title="View of tables with neither parents nor children">Orphan Tables</a></li> 61 <li><a href="anomalies.html" title="Things that might not be quite right">Anomalies</a></li> 62 <li><a href="routines.html" title="Procedures and functions">Routines</a></li> 63 </ul> 64 </div> 65 <!-- /.navbar-collapse --> 66 <!-- Navbar Right Menu --> 67 </div> 68 <!-- /.container-fluid --> 69 </nav> 70 </header> 71 <!-- Main content --> 72 <!-- Full Width Column --> 73 <div class="content-wrapper"> 74 <!-- Content Header (Page header) --> 75 <section class="content-header"> 76 <h1>Anomalies</h1><br /> 77 <div class="callout callout-warning"> 78 <p>Things that might not be 'quite right' about your database and schema</p> 79 </div> 80 </section> 81 <!-- Main content --> 82 <section class="content"> 83 <div class="row"> 84 <div class="col-md-6"> <!-- Implied Relationship --> 85 <div class="box box-success"> 86 <div class="box-header with-border"> 87 <h3 class="box-title">Columns whose name and type imply a relationship to another table's primary key</h3> 88 <div class="box-tools pull-right"> 89 <button type="button" class="btn btn-box-tool" data-widget="collapse"><i class="fa fa-minus"></i></button> 90 <button type="button" class="btn btn-box-tool" data-widget="remove"><i class="fa fa-times"></i></button> 91 </div> 92 </div> 93 <div class="box-body"> 94 <table 95 id="implied_constraint" 96 class="table table-bordered table-striped dataTable" 97 role="grid" 98 data-paging="true" 99 data-page-length="10" 100 data-length-change="false"> 101 <thead align='left'> 102 <tr> 103 <th>Child Column</th> 104 <th>Implied Parent Column</th> 105 </tr> 106 </thead> 107 <tbody> 108 <tr> 109 <td colspan="3">Anomaly not detected</td> 110 </tr> 111 </tbody> 112 </table> 113 </div> 114 </div> 115 </div> 116 <div class="col-md-6"> <!-- Tables without indexes --> 117 <div class="box box-danger"> 118 <div class="box-header with-border"> 119 <h3 class="box-title">Tables without indexes</h3> 120 <div class="box-tools pull-right"> 121 <button type="button" class="btn btn-box-tool" data-widget="collapse"><i class="fa fa-minus"></i></button> 122 <button type="button" class="btn btn-box-tool" data-widget="remove"><i class="fa fa-times"></i></button> 123 </div> 124 </div> 125 <div class="box-body"> 126 <table 127 id="un_indexed_table" 128 class="table table-bordered table-striped dataTable" 129 role="grid" 130 data-paging="true" 131 data-page-length="10" 132 data-length-change="false"> 133 <thead align='left'> 134 <tr> 135 <th>Table</th> 136 <th>Rows</th> 137 </tr> 138 </thead> 139 <tbody> 140 <tr> 141 <td colspan="3">Anomaly not detected</td> 142 </tr> 143 </tbody> 144 </table> 145 </div> 146 </div> 147 </div> 148 <div class="col-md-6"> <!-- Tables that contain a single column --> 149 <div class="box box-info"> 150 <div class="box-header with-border"> 151 <h3 class="box-title">Tables that contain a single column</h3> 152 <div class="box-tools pull-right"> 153 <button type="button" class="btn btn-box-tool" data-widget="collapse"><i class="fa fa-minus"></i></button> 154 <button type="button" class="btn btn-box-tool" data-widget="remove"><i class="fa fa-times"></i></button> 155 </div> 156 </div> 157 <div class="box-body"> 158 <table 159 id="single_column_table" 160 class="table table-bordered table-striped dataTable" 161 role="grid" 162 data-paging="true" 163 data-page-length="10" 164 data-length-change="false"> 165 <thead align='left'> 166 <tr> 167 <th>Table</th> 168 <th>Column</th> 169 </tr> 170 </thead> 171 <tbody> 172 <tr> 173 <td colspan="3">Anomaly not detected</td> 174 </tr> 175 </tbody> 176 </table> 177 </div> 178 </div> 179 </div> 180 <div class="col-md-6"> <!-- Tables with incrementing column names, potentially indicating denormalization --> 181 <div class="box box-danger"> 182 <div class="box-header with-border"> 183 <h3 class="box-title">Tables with incrementing column names, potentially indicating denormalization</h3> 184 <div class="box-tools pull-right"> 185 <button type="button" class="btn btn-box-tool" data-widget="collapse"><i class="fa fa-minus"></i></button> 186 <button type="button" class="btn btn-box-tool" data-widget="remove"><i class="fa fa-times"></i></button> 187 </div> 188 </div> 189 <div class="box-body"> 190 <table 191 id="inc_column_table" 192 class="table table-bordered table-striped dataTable" 193 role="grid" 194 data-paging="true" 195 data-page-length="10" 196 data-length-change="false"> 197 <thead align='left'> 198 <tr> 199 <th>Table</th> 200 </tr> 201 </thead> 202 <tbody> 203 <tr> 204 <td colspan="3">Anomaly not detected</td> 205 </tr> 206 </tbody> 207 </table> 208 </div> 209 </div> 210 </div> 211 <div class="col-md-6"> <!-- Columns whose default value is the word 'NULL' or 'null', but the SQL NULL value may have been intended --> 212 <div class="box box-primary"> 213 <div class="box-header with-border"> 214 <h3 class="box-title" title="Columns whose default value is the word 'NULL' or 'null', but the SQL NULL value may have been intende">Columns whose default value is the word 'NULL' or 'null'</h3> 215 <div class="box-tools pull-right"> 216 <button type="button" class="btn btn-box-tool" data-widget="collapse"><i class="fa fa-minus"></i></button> 217 <button type="button" class="btn btn-box-tool" data-widget="remove"><i class="fa fa-times"></i></button> 218 </div> 219 </div> 220 <div class="box-body"> 221 <table 222 id="null_string_table" 223 class="table table-bordered table-striped dataTable" 224 role="grid" 225 data-paging="true" 226 data-page-length="10" 227 data-length-change="false"> 228 <thead align='left'> 229 <tr> 230 <th>Table</th> 231 </tr> 232 </thead> 233 <tbody> 234 <tr> 235 <td colspan="3">Anomaly not detected</td> 236 </tr> 237 </tbody> 238 </table> 239 </div> 240 </div> 241 </div> 242 </div> 243 </section> 244 </div> 245 <!-- /.content-wrapper --> 246 <footer class="main-footer"> 247 <div> 248 <div class="pull-right hidden-xs"> 249 <a href="https://github.com/schemaspy/schemaspy" title="GitHub for SchemaSpy"><i class="fa fa-github-square fa-2x"></i></a> 250 <a href="http://stackoverflow.com/questions/tagged/schemaspy" title="StackOverflow for SchemaSpy"><i class="fa fa-stack-overflow fa-2x"></i></a> 251 </div> 252 <strong>Generated by <a href="http://schemaspy.org/" class="logo-text"><i class="fa fa-database"></i> SchemaSpy 6.2.4</a></strong> 253 </div> 254 <!-- /.container --> 255 </footer> 256 </div> 257 <!-- ./wrapper --> 258 259 <!-- jQuery 2.2.3 --> 260 <script src="bower/admin-lte/plugins/jQuery/jquery-2.2.3.min.js"></script> 261 <script src="bower/admin-lte/plugins/jQueryUI/jquery-ui.min.js"></script> 262 <!-- Bootstrap 3.3.5 --> 263 <script src="bower/admin-lte/bootstrap/js/bootstrap.min.js"></script> 264 <!-- DataTables --> 265 <script src="bower/datatables.net/jquery.dataTables.min.js"></script> 266 <script src="bower/datatables.net-bs/js/dataTables.bootstrap.min.js"></script> 267 <script src="bower/datatables.net-buttons/dataTables.buttons.min.js"></script> 268 <script src="bower/datatables.net-buttons-bs/js/buttons.bootstrap.min.js"></script> 269 <script src="bower/datatables.net-buttons/buttons.html5.min.js"></script> 270 <script src="bower/datatables.net-buttons/buttons.print.min.js"></script> 271 <script src="bower/datatables.net-buttons/buttons.colVis.min.js"></script> 272 <!-- SheetJS --> 273 <script src="bower/js-xlsx/xlsx.full.min.js"></script> 274 <!-- pdfmake --> 275 <script src="bower/pdfmake/pdfmake.min.js"></script> 276 <script src="bower/pdfmake/vfs_fonts.js"></script> 277 <!-- SlimScroll --> 278 <script src="bower/admin-lte/plugins/slimScroll/jquery.slimscroll.min.js"></script> 279 <!-- FastClick --> 280 <script src="bower/admin-lte/plugins/fastclick/fastclick.js"></script> 281 <!-- Salvattore --> 282 <script src="bower/salvattore/salvattore.min.js"></script> 283 <!-- AnchorJS --> 284 <script src="bower/anchor-js/anchor.min.js"></script> 285 <!-- CodeMirror --> 286 <script src="bower/codemirror/codemirror.js"></script> 287 <script src="bower/codemirror/sql.js"></script> 288 <!-- AdminLTE App --> 289 <script src="bower/admin-lte/dist/js/app.min.js"></script> 290 <script src="anomalies.js"></script> 291 <script src="schemaSpy.js"></script> 292 </body> 293 </html>