Changes

→‎Table: insert link
Line 15: Line 15:     
= Structure =
 
= Structure =
'''Version 1.13 2009/04/27'''
+
== Table ==
 
+
{|  align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
{|  align="left" width="100%" border="0" rules="all" cellpadding="1" cellspacing="0" style="margin: 0 0 1px 1px; border: 1px solid #dddddd; border-right-width: 2px; border-bottom-width: 2px; background-color: #f3f3f5"
   
  |style="background-color: #e9e9ef"| <b>Field</b>
 
  |style="background-color: #e9e9ef"| <b>Field</b>
 
  |style="background-color: #e9e9ef"| <b>Type</b>
 
  |style="background-color: #e9e9ef"| <b>Type</b>
Line 25: Line 24:  
  |style="background-color: #e9e9ef"| <b>Extra</b>
 
  |style="background-color: #e9e9ef"| <b>Extra</b>
 
  |style="background-color: #e9e9ef"| <b>Description</b>
 
  |style="background-color: #e9e9ef"| <b>Description</b>
|-
+
{{FieldRowid}}
| rowid
  −
| int(11)
  −
| NO
  −
| PRI
  −
| NULL
  −
| auto_increment
  −
| technical index
   
|-  
 
|-  
 
|datec  
 
|datec  
Line 41: Line 33:  
|&nbsp;
 
|&nbsp;
 
|date of creation technical
 
|date of creation technical
 +
{{FieldTms}}
 
|-  
 
|-  
 
|datev  
 
|datev  
Line 104: Line 97:  
|NULL
 
|NULL
 
|&nbsp;
 
|&nbsp;
|transaction type
+
|[[Transaction_type|transaction type]]
 
|-  
 
|-  
 
|num_releve  
 
|num_releve  
Line 169: Line 162:  
|&nbsp;
 
|&nbsp;
 
|to delete after migration
 
|to delete after migration
|}
+
|}&nbsp;
 +
 
 +
== Keys ==
 +
{|  align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
 +
|style="background-color: #e9e9ef"| <b>Key</b>
 +
|style="background-color: #e9e9ef"| <b>Type</b>
 +
|style="background-color: #e9e9ef"| <b>Fields</b>
 +
|-
 +
| PRIMARY
 +
| PRIMARY
 +
| rowid
 +
|-
 +
| idx_bank_datev
 +
| MULTIPLE
 +
| datev
 +
|-
 +
| idx_bank_dateo
 +
| MULTIPLE
 +
| dateo
 +
|-
 +
| idx_bank_fk_account
 +
| MULTIPLE
 +
| fk_account
 +
|-
 +
| idx_bank_rappro
 +
| MULTIPLE
 +
| rappro
 +
|}&nbsp;
53

edits