withdrawal.html (35794B)
1 <!DOCTYPE html> 2 <html> 3 <head> 4 <meta charset="utf-8"> 5 <meta http-equiv="X-UA-Compatible" content="IE=edge"> 6 <title>withdrawal - 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>withdrawal</h1><p><span id="recordNumber">128</span> rows</p><br /> 77 <div class="box box-primary"> 78 <div class="box-header with-border"> 79 <i class="fa fa-file-text-o"></i> 80 <h3 id="Description" class="box-title">Description</h3> 81 <div class="box-tools pull-right"> 82 <button type="button" class="btn btn-box-tool" data-widget="collapse"><i class="fa fa-minus"></i></button> 83 <button type="button" class="btn btn-box-tool" data-widget="remove"><i class="fa fa-times"></i></button> 84 </div> 85 </div><!-- /.box-header --> 86 <div class="box-body clearfix"> 87 <p>Table representing withdrawal processes initiated by terminals</p> 88 </div><!-- /.box-body --> 89 </div> 90 </section> 91 <!-- Main content --> 92 <section class="content"> 93 <div class="box box-primary"> 94 <div class="box-header with-border"> 95 <span class="glyphicon glyphicon-list-alt" aria-hidden="true"></span> 96 <h3 id="Columns" class="box-title">Columns</h3> 97 <div class="box-tools pull-right"> 98 <button type="button" class="btn btn-box-tool" data-widget="collapse"><i class="fa fa-minus"></i></button> 99 <button type="button" class="btn btn-box-tool" data-widget="remove"><i class="fa fa-times"></i></button> 100 </div> 101 </div> 102 <div class="box-body"> 103 <table 104 id="standard_table" 105 class="table table-bordered table-striped dataTable" 106 role="grid" 107 data-paging="true" 108 data-page-length="10" 109 data-length-change="false"> 110 <thead align='left'> 111 <tr> 112 <th>Column</th> 113 <th>Type</th> 114 <th>Size</th> 115 <th title='Are nulls allowed?'>Nulls</th> 116 <th title='Is column automatically updated?'>Auto</th> 117 <th title='Default value'>Default</th> 118 <th title='Columns in tables that reference this column'>Children</th> 119 <th title='Columns in tables that are referenced by this column'>Parents</th> 120 <th title='Comments' class="toggle"><span>Comments</span></th> 121 </tr> 122 </thead> 123 <tbody> 124 <tr> 125 <td class='primaryKey' title='Primary Key'><i class='icon ion-key iconkey' style='padding-left: 5px;'></i><span id="withdrawal_row_id">withdrawal_row_id</span></td> 126 <td>int8</td> 127 <td>19</td> 128 <td title=''></td> 129 <td title='Automatically updated by the database'>√</td> 130 <td>null</td> 131 <td> 132 <table border='0' cellspacing='0' cellpadding='0'> 133 </table> 134 </td> 135 <td> 136 <table border='0' cellspacing='0' cellpadding='0'> 137 </table> 138 </td> 139 <td><p>The withdrawal id is used a technical id used by the wire gateway to sequentially select new transactions</p></td> 140 </tr> 141 <tr> 142 <td class='indexedColumn' title='Indexed'><i class='fa fa-sitemap fa-rotate-120' style='padding-right: 5px;'></i><span id="request_uid">request_uid</span></td> 143 <td>text</td> 144 <td>2147483647</td> 145 <td title=''></td> 146 <td title=''></td> 147 <td>null</td> 148 <td> 149 <table border='0' cellspacing='0' cellpadding='0'> 150 </table> 151 </td> 152 <td> 153 <table border='0' cellspacing='0' cellpadding='0'> 154 </table> 155 </td> 156 <td><p>The request uid identifies each request and is stored to make the API interacting with withdrawals idempotent.</p></td> 157 </tr> 158 <tr> 159 <td class='indexedColumn' title='Indexed'><i class='fa fa-sitemap fa-rotate-120' style='padding-right: 5px;'></i><span id="wopid">wopid</span></td> 160 <td>bytea</td> 161 <td>2147483647</td> 162 <td title=''></td> 163 <td title=''></td> 164 <td>null</td> 165 <td> 166 <table border='0' cellspacing='0' cellpadding='0'> 167 </table> 168 </td> 169 <td> 170 <table border='0' cellspacing='0' cellpadding='0'> 171 </table> 172 </td> 173 <td><p>The wopid (withdrawal operation id) is a nonce generated by the terminal requesting a withdrawal. The wopid identifies a specific withdrawal spawning all involved systems.</p></td> 174 </tr> 175 <tr> 176 <td><span id="reserve_pub_key">reserve_pub_key</span></td> 177 <td>bytea</td> 178 <td>2147483647</td> 179 <td title='nullable'>√</td> 180 <td title=''></td> 181 <td>null</td> 182 <td> 183 <table border='0' cellspacing='0' cellpadding='0'> 184 </table> 185 </td> 186 <td> 187 <table border='0' cellspacing='0' cellpadding='0'> 188 </table> 189 </td> 190 <td><p>Reserve public key for the reserve which will hold the withdrawal amount after completion</p></td> 191 </tr> 192 <tr> 193 <td><span id="registration_ts">registration_ts</span></td> 194 <td>int8</td> 195 <td>19</td> 196 <td title=''></td> 197 <td title=''></td> 198 <td>null</td> 199 <td> 200 <table border='0' cellspacing='0' cellpadding='0'> 201 </table> 202 </td> 203 <td> 204 <table border='0' cellspacing='0' cellpadding='0'> 205 </table> 206 </td> 207 <td><p>Timestamp of when the withdrawal request was registered</p></td> 208 </tr> 209 <tr> 210 <td><span id="amount">amount</span></td> 211 <td>"c2ec"."taler_amount_currency"</td> 212 <td>2147483647</td> 213 <td title='nullable'>√</td> 214 <td title=''></td> 215 <td>null</td> 216 <td> 217 <table border='0' cellspacing='0' cellpadding='0'> 218 </table> 219 </td> 220 <td> 221 <table border='0' cellspacing='0' cellpadding='0'> 222 </table> 223 </td> 224 <td><p>Effective amount to be put into the reserve after completion</p></td> 225 </tr> 226 <tr> 227 <td><span id="suggested_amount">suggested_amount</span></td> 228 <td>"c2ec"."taler_amount_currency"</td> 229 <td>2147483647</td> 230 <td title='nullable'>√</td> 231 <td title=''></td> 232 <td>null</td> 233 <td> 234 <table border='0' cellspacing='0' cellpadding='0'> 235 </table> 236 </td> 237 <td> 238 <table border='0' cellspacing='0' cellpadding='0'> 239 </table> 240 </td> 241 <td><p>The suggested amount is given by the entity initializing the wihdrawal. If the suggested amount is given, the wallet may still change the amount.</p></td> 242 </tr> 243 <tr> 244 <td><span id="terminal_fees">terminal_fees</span></td> 245 <td>"c2ec"."taler_amount_currency"</td> 246 <td>2147483647</td> 247 <td title='nullable'>√</td> 248 <td title=''></td> 249 <td>null</td> 250 <td> 251 <table border='0' cellspacing='0' cellpadding='0'> 252 </table> 253 </td> 254 <td> 255 <table border='0' cellspacing='0' cellpadding='0'> 256 </table> 257 </td> 258 <td><p>Fees associated with the withdrawal but not related to the taler payment system.</p></td> 259 </tr> 260 <tr> 261 <td><span id="withdrawal_status">withdrawal_status</span></td> 262 <td>"c2ec"."withdrawal_operation_status"</td> 263 <td>2147483647</td> 264 <td title=''></td> 265 <td title=''></td> 266 <td>'pending'::c2ec.withdrawal_operation_status</td> 267 <td> 268 <table border='0' cellspacing='0' cellpadding='0'> 269 </table> 270 </td> 271 <td> 272 <table border='0' cellspacing='0' cellpadding='0'> 273 </table> 274 </td> 275 <td><p>Status of the withdrawal process</p></td> 276 </tr> 277 <tr> 278 <td class='foreignKey' title='Foreign Key'><i class='icon ion-key iconkey' style='padding-left: 5px;'></i><span id="terminal_id">terminal_id</span></td> 279 <td>int8</td> 280 <td>19</td> 281 <td title=''></td> 282 <td title=''></td> 283 <td>null</td> 284 <td> 285 <table border='0' cellspacing='0' cellpadding='0'> 286 </table> 287 </td> 288 <td> 289 <table border='0' cellspacing='0' cellpadding='0'> 290 <tr> 291 <td title="withdrawal.terminal_id references terminal.terminal_id via withdrawal_terminal_id_fkey"><a href='terminal.html'>terminal</a><span class='relatedKey'>.terminal_id</span></td> 292 <td class="constraint detail">withdrawal_terminal_id_fkey</td> 293 <td class="constraint detail"><span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> 294 </tr> 295 </table> 296 </td> 297 <td><p>ID of the terminal that initiated the withdrawal</p></td> 298 </tr> 299 <tr> 300 <td><span id="provider_transaction_id">provider_transaction_id</span></td> 301 <td>text</td> 302 <td>2147483647</td> 303 <td title='nullable'>√</td> 304 <td title=''></td> 305 <td>null</td> 306 <td> 307 <table border='0' cellspacing='0' cellpadding='0'> 308 </table> 309 </td> 310 <td> 311 <table border='0' cellspacing='0' cellpadding='0'> 312 </table> 313 </td> 314 <td><p>Transaction identifier supplied by the provider for backend request</p></td> 315 </tr> 316 <tr> 317 <td><span id="last_retry_ts">last_retry_ts</span></td> 318 <td>int8</td> 319 <td>19</td> 320 <td title='nullable'>√</td> 321 <td title=''></td> 322 <td>null</td> 323 <td> 324 <table border='0' cellspacing='0' cellpadding='0'> 325 </table> 326 </td> 327 <td> 328 <table border='0' cellspacing='0' cellpadding='0'> 329 </table> 330 </td> 331 <td><p>Timestamp of the last retry attempt</p></td> 332 </tr> 333 <tr> 334 <td><span id="retry_counter">retry_counter</span></td> 335 <td>int4</td> 336 <td>10</td> 337 <td title=''></td> 338 <td title=''></td> 339 <td>0</td> 340 <td> 341 <table border='0' cellspacing='0' cellpadding='0'> 342 </table> 343 </td> 344 <td> 345 <table border='0' cellspacing='0' cellpadding='0'> 346 </table> 347 </td> 348 <td><p>Number of retry attempts</p></td> 349 </tr> 350 <tr> 351 <td><span id="completion_proof">completion_proof</span></td> 352 <td>bytea</td> 353 <td>2147483647</td> 354 <td title='nullable'>√</td> 355 <td title=''></td> 356 <td>null</td> 357 <td> 358 <table border='0' cellspacing='0' cellpadding='0'> 359 </table> 360 </td> 361 <td> 362 <table border='0' cellspacing='0' cellpadding='0'> 363 </table> 364 </td> 365 <td><p>Proof of transaction upon final completion delivered by the providers system</p></td> 366 </tr> 367 <tr> 368 <td><span id="confirmed_row_id">confirmed_row_id</span></td> 369 <td>int8</td> 370 <td>19</td> 371 <td title='nullable'>√</td> 372 <td title=''></td> 373 <td>0</td> 374 <td> 375 <table border='0' cellspacing='0' cellpadding='0'> 376 </table> 377 </td> 378 <td> 379 <table border='0' cellspacing='0' cellpadding='0'> 380 </table> 381 </td> 382 <td><p>Used by the wire-gateway API do not mess up confirmed and unconfirmed transactions row ids.</p></td> 383 </tr> 384 </tbody> 385 </table> 386 </div> 387 </div> 388 <div class="box box-primary"> 389 <div class="box-header with-border"> 390 <i class="fa fa-sitemap"></i> 391 <h3 id="Indexes" class="box-title">Indexes</h3> 392 <div class="box-tools pull-right"> 393 <button type="button" class="btn btn-box-tool" data-widget="collapse"><i class="fa fa-minus"></i></button> 394 <button type="button" class="btn btn-box-tool" data-widget="remove"><i class="fa fa-times"></i></button> 395 </div> 396 </div> 397 <div class="box-body"> 398 <table 399 id="indexes_table" 400 class="table table-bordered table-striped dataTable" 401 role="grid" 402 data-paging="true" 403 data-page-length="10" 404 data-length-change="false"> 405 <thead> 406 <tr> 407 <th>Constraint Name</th> 408 <th>Type</th> 409 <th>Sort</th> 410 <th>Column(s)</th> 411 </tr> 412 </thead> 413 <tbody> 414 <tr> 415 <td class='primaryKey' title='Primary Key'><i class='icon ion-key iconkey'></i> withdrawal_pkey</td> 416 <td>Primary key</td> 417 <td><span title='Ascending'>Asc</span></td> 418 <td>withdrawal_row_id</td> 419 </tr> 420 <tr> 421 <td class='uniqueKey' title='Unique Key'><i class='icon ion-key iconkey'></i> withdrawal_request_uid_key</td> 422 <td>Must be unique</td> 423 <td><span title='Ascending'>Asc</span></td> 424 <td>request_uid</td> 425 </tr> 426 <tr> 427 <td class='uniqueKey' title='Unique Key'><i class='icon ion-key iconkey'></i> withdrawal_wopid_key</td> 428 <td>Must be unique</td> 429 <td><span title='Ascending'>Asc</span></td> 430 <td>wopid</td> 431 </tr> 432 <tr> 433 <td title='Indexed'>wopid_index</td> 434 <td>Performance</td> 435 <td><span title='Ascending'>Asc</span></td> 436 <td>wopid</td> 437 </tr> 438 </tbody> 439 </table> 440 </div><!-- /.box-body --> 441 </div> 442 <div class="box box-primary"> 443 <div class="box-header with-border"> 444 <i class="fa fa-sitemap"></i> 445 <h3 class="box-title">Check Constraints</h3> 446 <div class="box-tools pull-right"> 447 <button type="button" class="btn btn-box-tool" data-widget="collapse"><i class="fa fa-minus"></i></button> 448 <button type="button" class="btn btn-box-tool" data-widget="remove"><i class="fa fa-times"></i></button> 449 </div> 450 </div> 451 <div class="box-body"> 452 <table 453 id="check_table" 454 class="table table-bordered table-striped dataTable" 455 role="grid" 456 data-paging="true" 457 data-page-length="10" 458 data-length-change="false"> 459 <thead align='left'> 460 <tr> 461 <th>Constraint Name</th> 462 <th>Constraint</th> 463 </tr> 464 </thead> 465 <tbody> 466 <tr> 467 <td>withdrawal_reserve_pub_key_check</td> 468 <td>((length(reserve_pub_key) = 32))</td> 469 </tr> 470 <tr> 471 <td>withdrawal_wopid_check</td> 472 <td>((length(wopid) = 32))</td> 473 </tr> 474 </tbody> 475 </table> 476 </div> 477 </div> 478 <div class="box box-primary"> 479 <div class="box-header with-border"> 480 <i class="fa fa-code-fork"></i> 481 <h3 id="Relationships" class="box-title">Relationships</h3> 482 <div class="box-tools pull-right"> 483 <button type="button" class="btn btn-box-tool" data-widget="collapse"><i class="fa fa-minus"></i></button> 484 <button type="button" class="btn btn-box-tool" data-widget="remove"><i class="fa fa-times"></i></button> 485 </div> 486 </div> 487 <div class="box-body"> 488 <div class="nav-tabs-custom"><!-- Tabs within a box --> 489 <h5>Close relationships within degrees of separation</h5> 490 <ul class="nav nav-tabs pull-left ui-sortable-handle"> 491 <li class="active"><a href="#oneDegreeImg-chart" data-toggle="tab" aria-expanded="true">One</a></li> 492 <li class=""><a href="#twodegreesDegreeImg-chart" data-toggle="tab" aria-expanded="true">Two degrees</a></li> 493 </ul> 494 <div class="tab-content no-padding"> 495 <div class="chart tab-pane active" id="oneDegreeImg-chart" style="position: relative; overflow-x:auto;"> 496 <map id="oneDegreeRelationshipsDiagram" name="oneDegreeRelationshipsDiagram"> 497 <area shape="rect" id="node1" href="withdrawal.html" target="_top" title="withdrawal" alt="" coords="217,5,872,515"> 498 <area shape="rect" id="node2" href="terminal.html" target="_top" title="terminal" alt="" coords="5,272,173,419"> 499 </map> 500 <a name='diagram'><img id="oneDegreeImg" src="../diagrams/tables/withdrawal.1degree.png" usemap="#oneDegreeRelationshipsDiagram" class="diagram" border="0" align="left"></a> 501 </div> 502 <div class="chart tab-pane " id="twodegreesDegreeImg-chart" style="position: relative; overflow-x:auto;"> 503 <map id="twoDegreesRelationshipsDiagram" name="twoDegreesRelationshipsDiagram"> 504 <area shape="rect" id="node1" href="terminal.html" target="_top" title="terminal" alt="" coords="209,272,377,419"> 505 <area shape="rect" id="node2" href="provider.html" target="_top" title="provider" alt="" coords="5,304,165,392"> 506 <area shape="rect" id="node3" href="withdrawal.html" target="_top" title="withdrawal" alt="" coords="421,5,1076,515"> 507 </map> 508 <a name='diagram'><img id="twodegreesDegreeImg" src="../diagrams/tables/withdrawal.2degrees.png" usemap="#twoDegreesRelationshipsDiagram" class="diagram" border="0" align="left"></a> 509 </div> 510 </div> 511 </div> 512 </div><!-- /.box-body --> 513 </div> 514 </section> 515 <script> 516 var config = { 517 pagination: true 518 } 519 </script> 520 </div> 521 <!-- /.content-wrapper --> 522 <footer class="main-footer"> 523 <div> 524 <div class="pull-right hidden-xs"> 525 <a href="https://github.com/schemaspy/schemaspy" title="GitHub for SchemaSpy"><i class="fa fa-github-square fa-2x"></i></a> 526 <a href="http://stackoverflow.com/questions/tagged/schemaspy" title="StackOverflow for SchemaSpy"><i class="fa fa-stack-overflow fa-2x"></i></a> 527 </div> 528 <strong>Generated by <a href="http://schemaspy.org/" class="logo-text"><i class="fa fa-database"></i> SchemaSpy 6.2.4</a></strong> 529 </div> 530 <!-- /.container --> 531 </footer> 532 </div> 533 <!-- ./wrapper --> 534 535 <!-- jQuery 2.2.3 --> 536 <script src="../bower/admin-lte/plugins/jQuery/jquery-2.2.3.min.js"></script> 537 <script src="../bower/admin-lte/plugins/jQueryUI/jquery-ui.min.js"></script> 538 <!-- Bootstrap 3.3.5 --> 539 <script src="../bower/admin-lte/bootstrap/js/bootstrap.min.js"></script> 540 <!-- DataTables --> 541 <script src="../bower/datatables.net/jquery.dataTables.min.js"></script> 542 <script src="../bower/datatables.net-bs/js/dataTables.bootstrap.min.js"></script> 543 <script src="../bower/datatables.net-buttons/dataTables.buttons.min.js"></script> 544 <script src="../bower/datatables.net-buttons-bs/js/buttons.bootstrap.min.js"></script> 545 <script src="../bower/datatables.net-buttons/buttons.html5.min.js"></script> 546 <script src="../bower/datatables.net-buttons/buttons.print.min.js"></script> 547 <script src="../bower/datatables.net-buttons/buttons.colVis.min.js"></script> 548 <!-- SheetJS --> 549 <script src="../bower/js-xlsx/xlsx.full.min.js"></script> 550 <!-- pdfmake --> 551 <script src="../bower/pdfmake/pdfmake.min.js"></script> 552 <script src="../bower/pdfmake/vfs_fonts.js"></script> 553 <!-- SlimScroll --> 554 <script src="../bower/admin-lte/plugins/slimScroll/jquery.slimscroll.min.js"></script> 555 <!-- FastClick --> 556 <script src="../bower/admin-lte/plugins/fastclick/fastclick.js"></script> 557 <!-- Salvattore --> 558 <script src="../bower/salvattore/salvattore.min.js"></script> 559 <!-- AnchorJS --> 560 <script src="../bower/anchor-js/anchor.min.js"></script> 561 <!-- CodeMirror --> 562 <script src="../bower/codemirror/codemirror.js"></script> 563 <script src="../bower/codemirror/sql.js"></script> 564 <!-- AdminLTE App --> 565 <script src="../bower/admin-lte/dist/js/app.min.js"></script> 566 <script src="table.js"></script> 567 <script src="../schemaSpy.js"></script> 568 </body> 569 </html>