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:
|
|
|date of creation technical
|date of creation technical
+
{{FieldTms}}
|-
|-
|datev
|datev
Line 104:
Line 97:
|NULL
|NULL
|
|
−
|transaction type
+
|[[Transaction_type|transaction type]]
|-
|-
|num_releve
|num_releve
Line 169:
Line 162:
|
|
|to delete after migration
|to delete after migration
−
|}
+
|}
+
+
== 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
+
|}