index.html (19198B)
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>Tables</h1><br /> 77 <div class="row"> 78 <div class="col-md-12"> 79 <div class="callout callout-info"> 80 <h4>SchemaSpy Analysis of postgres.c2ec</h4> 81 <p>Generated on Wed Jun 05 15:16 CEST 2024</p> 82 </div> 83 </div> 84 </div> 85 <a href="postgres.c2ec.xml" title="XML Representation">XML Representation</a><br /> 86 <a href="insertionOrder.txt" title="Useful for loading data into a database">Insertion Order</a> 87 <a href="deletionOrder.txt" title="Useful for purging data from a database">Deletion Order</a> 88 </section> 89 <!-- Main content --> 90 <section class="content"> 91 <div class="row"> 92 <div class="col-md-2 col-sm-4 col-xs-12"> 93 <div class="info-box"> 94 <span class="info-box-icon bg-aqua"><i class="fa fa-table"></i></span> 95 <div class="info-box-content"> 96 <span class="info-box-text">TABLES</span> 97 <span class="info-box-number">4</span> 98 </div> 99 <!-- /.info-box-content --> 100 </div> 101 <!-- /.info-box --> 102 </div> 103 <!-- /.col --> 104 <div class="col-md-2 col-sm-4 col-xs-12"> 105 <div class="info-box"> 106 <span class="info-box-icon bg-teal"><i class="fa fa-table"></i></span> 107 <div class="info-box-content"> 108 <span class="info-box-text">VIEWS</span> 109 <span class="info-box-number">0</span> 110 </div> 111 <!-- /.info-box-content --> 112 </div> 113 <!-- /.info-box --> 114 </div> 115 <!-- /.col --> 116 <div class="col-md-2 col-sm-4 col-xs-12"> 117 <div class="info-box"> 118 <span class="info-box-icon bg-green"><span class="glyphicon glyphicon-list-alt" aria-hidden="true"></span></span> 119 <div class="info-box-content"> 120 <span class="info-box-text">COLUMNS</span> 121 <span class="info-box-number">35</span> 122 </div> 123 <!-- /.info-box-content --> 124 </div> 125 <!-- /.info-box --> 126 </div> 127 <!-- /.col --> 128 <div class="col-md-2 col-sm-4 col-xs-12"> 129 <div class="info-box"> 130 <span class="info-box-icon bg-yellow"><i class="ion ion-key"></i></span> 131 <div class="info-box-content"> 132 <span class="info-box-text">Constraints</span> 133 <span class="info-box-number">2</span> 134 </div> 135 <!-- /.info-box-content --> 136 </div> 137 <!-- /.info-box --> 138 </div> 139 <!-- /.col --> 140 <div class="col-md-2 col-sm-4 col-xs-12"> 141 <div class="info-box"> 142 <span class="info-box-icon bg-red-active"><i class="fa fa-question" aria-hidden="true"></i></span> 143 <div class="info-box-content"> 144 <span class="info-box-text">Anomalies</span> 145 <span class="info-box-number">0</span> 146 </div> 147 <!-- /.info-box-content --> 148 </div> 149 <!-- /.info-box --> 150 </div> 151 <!-- /.col --> 152 <div class="col-md-2 col-sm-4 col-xs-12"> 153 <div class="info-box"> 154 <span class="info-box-icon bg-navy"><i class="fa fa-file-code-o" aria-hidden="true"></i></span> 155 <div class="info-box-content"> 156 <span class="info-box-text">Routines</span> 157 <span class="info-box-number">4</span> 158 </div> 159 <!-- /.info-box-content --> 160 </div> 161 <!-- /.info-box --> 162 </div> 163 <!-- /.col --> 164 </div> 165 <div class="box box-primary"> 166 <div class="box-header with-border"> 167 <h3 class="box-title">Database Properties</h3> 168 <span class="label label-primary pull-right"><i class="fa fa-cog fa-2x"></i></span> 169 </div><!-- /.box-header --> 170 <div class="box-body"> 171 <p>Database Type: PostgreSQL - 15.2 (Debian 15.2-1.pgdg110+1)</p> 172 </div><!-- /.box-body --> 173 </div> 174 <div class="box box-primary"> 175 <div class="box-header with-border"> 176 <h3 class="box-title">Catalog postgres</h3> 177 <span class="label label-primary pull-right"><i class="fa fa-cog fa-2x"></i></span> 178 </div><!-- /.box-header --> 179 <div class="box-body"> 180 <p> <p>default administrative connection database</p> </p> 181 </div><!-- /.box-body --> 182 </div> 183 <div class="box box-primary"> 184 <div class="box-header with-border"> 185 <h3 class="box-title">Schema c2ec</h3> 186 <span class="label label-primary pull-right"><i class="fa fa-cog fa-2x"></i></span> 187 </div><!-- /.box-header --> 188 <div class="box-body"> 189 <p> <p>Schema containing all tables and types related to c2ec (cashless2ecash)</p> </p> 190 </div><!-- /.box-body --> 191 </div> 192 <div class="box box-primary"> 193 <div class="box-header with-border"> 194 <h3 class="box-title">Tables</h3> 195 <span class="label label-primary pull-right"><i class="fa fa-database fa-2x"></i></span> 196 </div><!-- /.box-header --> 197 <div class="box-body"> 198 <table 199 id="database_objects" 200 class="table table-bordered table-striped dataTable" 201 role="grid" 202 data-paging="true" 203 data-page-length="50" 204 data-length-change="false"> 205 <thead> 206 <tr> 207 <th valign="bottom">Table / View</th> 208 <th align="right" valign="bottom">Children</th> 209 <th align="right" valign="bottom">Parents</th> 210 <th align="right" valign="bottom">Columns</th> 211 <th align="right" valign="bottom">Rows</th> 212 <th align="right" valign="bottom">Type</th> 213 <th class="toggle">Comments</th> 214 </tr> 215 </thead> 216 <tbody> 217 <tr class="tbl even" valign="top"> 218 <td class="detail"><a href="tables/terminal.html">terminal</a></td> 219 <td class="detail" align="right">1</td> 220 <td class="detail" align="right">1</td> 221 <td class="detail" align="right">5</td> 222 <td class="detail" align="right">-1</td> 223 <td class="detail" align="right">Table</td> 224 <td class="comment detail" style="display: table-cell;"><p>Table containing information about terminals of providers</p></td> 225 </tr> 226 <tr class="tbl even" valign="top"> 227 <td class="detail"><a href="tables/transfer.html">transfer</a></td> 228 <td class="detail" align="right">0</td> 229 <td class="detail" align="right">0</td> 230 <td class="detail" align="right">10</td> 231 <td class="detail" align="right">-1</td> 232 <td class="detail" align="right">Table</td> 233 <td class="comment detail" style="display: table-cell;"><p>Table storing transfers which are sent by the exchange.</p></td> 234 </tr> 235 <tr class="tbl even" valign="top"> 236 <td class="detail"><a href="tables/provider.html">provider</a></td> 237 <td class="detail" align="right">1</td> 238 <td class="detail" align="right">0</td> 239 <td class="detail" align="right">5</td> 240 <td class="detail" align="right">-1</td> 241 <td class="detail" align="right">Table</td> 242 <td class="comment detail" style="display: table-cell;"><p>Table describing providers of c2ec terminal</p></td> 243 </tr> 244 <tr class="tbl even" valign="top"> 245 <td class="detail"><a href="tables/withdrawal.html">withdrawal</a></td> 246 <td class="detail" align="right">0</td> 247 <td class="detail" align="right">1</td> 248 <td class="detail" align="right">15</td> 249 <td class="detail" align="right">128</td> 250 <td class="detail" align="right">Table</td> 251 <td class="comment detail" style="display: table-cell;"><p>Table representing withdrawal processes initiated by terminals</p></td> 252 </tr> 253 </table> 254 </div> 255 </div><!-- /.box-body --> 256 </section> 257 <!-- /.content --> 258 <script> 259 var config = { 260 pagination: true 261 } 262 </script> 263 </div> 264 <!-- /.content-wrapper --> 265 <footer class="main-footer"> 266 <div> 267 <div class="pull-right hidden-xs"> 268 <a href="https://github.com/schemaspy/schemaspy" title="GitHub for SchemaSpy"><i class="fa fa-github-square fa-2x"></i></a> 269 <a href="http://stackoverflow.com/questions/tagged/schemaspy" title="StackOverflow for SchemaSpy"><i class="fa fa-stack-overflow fa-2x"></i></a> 270 </div> 271 <strong>Generated by <a href="http://schemaspy.org/" class="logo-text"><i class="fa fa-database"></i> SchemaSpy 6.2.4</a></strong> 272 </div> 273 <!-- /.container --> 274 </footer> 275 </div> 276 <!-- ./wrapper --> 277 278 <!-- jQuery 2.2.3 --> 279 <script src="bower/admin-lte/plugins/jQuery/jquery-2.2.3.min.js"></script> 280 <script src="bower/admin-lte/plugins/jQueryUI/jquery-ui.min.js"></script> 281 <!-- Bootstrap 3.3.5 --> 282 <script src="bower/admin-lte/bootstrap/js/bootstrap.min.js"></script> 283 <!-- DataTables --> 284 <script src="bower/datatables.net/jquery.dataTables.min.js"></script> 285 <script src="bower/datatables.net-bs/js/dataTables.bootstrap.min.js"></script> 286 <script src="bower/datatables.net-buttons/dataTables.buttons.min.js"></script> 287 <script src="bower/datatables.net-buttons-bs/js/buttons.bootstrap.min.js"></script> 288 <script src="bower/datatables.net-buttons/buttons.html5.min.js"></script> 289 <script src="bower/datatables.net-buttons/buttons.print.min.js"></script> 290 <script src="bower/datatables.net-buttons/buttons.colVis.min.js"></script> 291 <!-- SheetJS --> 292 <script src="bower/js-xlsx/xlsx.full.min.js"></script> 293 <!-- pdfmake --> 294 <script src="bower/pdfmake/pdfmake.min.js"></script> 295 <script src="bower/pdfmake/vfs_fonts.js"></script> 296 <!-- SlimScroll --> 297 <script src="bower/admin-lte/plugins/slimScroll/jquery.slimscroll.min.js"></script> 298 <!-- FastClick --> 299 <script src="bower/admin-lte/plugins/fastclick/fastclick.js"></script> 300 <!-- Salvattore --> 301 <script src="bower/salvattore/salvattore.min.js"></script> 302 <!-- AnchorJS --> 303 <script src="bower/anchor-js/anchor.min.js"></script> 304 <!-- CodeMirror --> 305 <script src="bower/codemirror/codemirror.js"></script> 306 <script src="bower/codemirror/sql.js"></script> 307 <!-- AdminLTE App --> 308 <script src="bower/admin-lte/dist/js/app.min.js"></script> 309 <script src="main.js"></script> 310 <script src="schemaSpy.js"></script> 311 </body> 312 </html>