constraints.html (14099B)
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>Constraints</h1> 77 </section> 78 <!-- Main content --> 79 <section class="content"> 80 <div class="box box-primary"> 81 <div class="box-header with-border"> 82 <i class="ion ion-key"></i> 83 <h3 class="box-title">2 Foreign Key Constraints</h3> 84 <div class="box-tools pull-right"> 85 <button type="button" class="btn btn-box-tool" data-widget="collapse"><i class="fa fa-minus"></i></button> 86 <button type="button" class="btn btn-box-tool" data-widget="remove"><i class="fa fa-times"></i></button> 87 </div> 88 </div> 89 <div class="box-body"> 90 <table 91 id="fk_table" 92 class="table table-bordered table-striped dataTable" 93 role="grid" 94 data-paging="true" 95 data-page-length="50" 96 data-length-change="false"> 97 <thead align='left'> 98 <tr> 99 <th>Constraint Name</th> 100 <th>Child Column</th> 101 <th>Parent Column</th> 102 <th>Delete Rule</th> 103 </tr> 104 </thead> 105 <tbody> 106 <tr> 107 <td>terminal_provider_id_fkey</td> 108 <td> 109 <table border='0' cellspacing='0' cellpadding='0'> 110 <tr> 111 <td><a href='tables/terminal.html'>terminal</a><span>.provider_id</span></td> 112 </tr> 113 </table> 114 </td> 115 <td> 116 <table border='0' cellspacing='0' cellpadding='0'> 117 <tr> 118 <td><a href='tables/provider.html'>provider</a><span>.provider_id</span></td> 119 </tr> 120 </table> 121 </td> 122 <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> 123 </tr> 124 <tr> 125 <td>withdrawal_terminal_id_fkey</td> 126 <td> 127 <table border='0' cellspacing='0' cellpadding='0'> 128 <tr> 129 <td><a href='tables/withdrawal.html'>withdrawal</a><span>.terminal_id</span></td> 130 </tr> 131 </table> 132 </td> 133 <td> 134 <table border='0' cellspacing='0' cellpadding='0'> 135 <tr> 136 <td><a href='tables/terminal.html'>terminal</a><span>.terminal_id</span></td> 137 </tr> 138 </table> 139 </td> 140 <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> 141 </tr> 142 </tbody> 143 </table> 144 </div> 145 </div> 146 <div class="box box-primary"> 147 <div class="box-header with-border"> 148 <i class="fa fa-sitemap"></i> 149 <h3 class="box-title">Check Constraints</h3> 150 <div class="box-tools pull-right"> 151 <button type="button" class="btn btn-box-tool" data-widget="collapse"><i class="fa fa-minus"></i></button> 152 <button type="button" class="btn btn-box-tool" data-widget="remove"><i class="fa fa-times"></i></button> 153 </div> 154 </div> 155 <div class="box-body"> 156 <table 157 id="check_table" 158 class="table table-bordered table-striped dataTable" 159 role="grid" 160 data-paging="true" 161 data-page-length="10" 162 data-length-change="false"> 163 <thead align='left'> 164 <tr> 165 <th>Table</th> 166 <th>Constraint Name</th> 167 <th>Constraint</th> 168 </tr> 169 </thead> 170 <tbody> 171 <tr> 172 <td><a href='tables/withdrawal.html'>withdrawal</a></td> 173 <td>withdrawal_reserve_pub_key_check</td> 174 <td>((length(reserve_pub_key) = 32))</td> 175 </tr> 176 <tr> 177 <td><a href='tables/withdrawal.html'>withdrawal</a></td> 178 <td>withdrawal_wopid_check</td> 179 <td>((length(wopid) = 32))</td> 180 </tr> 181 </tbody> 182 </table> 183 </div> 184 </div> 185 </section> 186 <script> 187 var config = { 188 pagination: true 189 } 190 </script> 191 </div> 192 <!-- /.content-wrapper --> 193 <footer class="main-footer"> 194 <div> 195 <div class="pull-right hidden-xs"> 196 <a href="https://github.com/schemaspy/schemaspy" title="GitHub for SchemaSpy"><i class="fa fa-github-square fa-2x"></i></a> 197 <a href="http://stackoverflow.com/questions/tagged/schemaspy" title="StackOverflow for SchemaSpy"><i class="fa fa-stack-overflow fa-2x"></i></a> 198 </div> 199 <strong>Generated by <a href="http://schemaspy.org/" class="logo-text"><i class="fa fa-database"></i> SchemaSpy 6.2.4</a></strong> 200 </div> 201 <!-- /.container --> 202 </footer> 203 </div> 204 <!-- ./wrapper --> 205 206 <!-- jQuery 2.2.3 --> 207 <script src="bower/admin-lte/plugins/jQuery/jquery-2.2.3.min.js"></script> 208 <script src="bower/admin-lte/plugins/jQueryUI/jquery-ui.min.js"></script> 209 <!-- Bootstrap 3.3.5 --> 210 <script src="bower/admin-lte/bootstrap/js/bootstrap.min.js"></script> 211 <!-- DataTables --> 212 <script src="bower/datatables.net/jquery.dataTables.min.js"></script> 213 <script src="bower/datatables.net-bs/js/dataTables.bootstrap.min.js"></script> 214 <script src="bower/datatables.net-buttons/dataTables.buttons.min.js"></script> 215 <script src="bower/datatables.net-buttons-bs/js/buttons.bootstrap.min.js"></script> 216 <script src="bower/datatables.net-buttons/buttons.html5.min.js"></script> 217 <script src="bower/datatables.net-buttons/buttons.print.min.js"></script> 218 <script src="bower/datatables.net-buttons/buttons.colVis.min.js"></script> 219 <!-- SheetJS --> 220 <script src="bower/js-xlsx/xlsx.full.min.js"></script> 221 <!-- pdfmake --> 222 <script src="bower/pdfmake/pdfmake.min.js"></script> 223 <script src="bower/pdfmake/vfs_fonts.js"></script> 224 <!-- SlimScroll --> 225 <script src="bower/admin-lte/plugins/slimScroll/jquery.slimscroll.min.js"></script> 226 <!-- FastClick --> 227 <script src="bower/admin-lte/plugins/fastclick/fastclick.js"></script> 228 <!-- Salvattore --> 229 <script src="bower/salvattore/salvattore.min.js"></script> 230 <!-- AnchorJS --> 231 <script src="bower/anchor-js/anchor.min.js"></script> 232 <!-- CodeMirror --> 233 <script src="bower/codemirror/codemirror.js"></script> 234 <script src="bower/codemirror/sql.js"></script> 235 <!-- AdminLTE App --> 236 <script src="bower/admin-lte/dist/js/app.min.js"></script> 237 <script src="constraint.js"></script> 238 <script src="schemaSpy.js"></script> 239 </body> 240 </html>