53
edits
Changes
→Table: insert link
Line 6:
Line 6:
|- +| rowid
−| int(11)
−|
−| PRI
−| NULL
−| auto_increment
−| technical index
| +|-
−|Author
−|varchar(40)
−|YES
−|
−|NULL
−|
−|
+
{{ListOfTables}}
{{ListOfTables}}
−= Content/Contenu =
+= Content/Contenu/Contenido =
{{flag en}} Contains the transactions operated on bank accounts.
{{flag en}} Contains the transactions operated on bank accounts.
Line 15:
Line 15:
= Structure =
= Structure =
−{| 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"
+== Table ==
+{| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
|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 23:
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}}
−|-
|-
|datec
|datec
Line 39:
Line 33:
|
|
|date of creation technical
|date of creation technical
+{{FieldTms}}
|-
|-
|datev
|datev
|date
|date
|YES
|YES
−|
+|MUL
|NULL
|NULL
|
|
Line 51:
Line 46:
|date
|date
|YES
|YES
−|
+|MUL
|NULL
|NULL
|
|
Line 57:
Line 52:
|-
|-
|amount
|amount
−|double
+|double(24,8)
+|NO
|
|
−|0.00000000
−|0
|
|
|amount of the transaction
|amount of the transaction
Line 75:
Line 70:
|int(11)
|int(11)
|YES
|YES
−|
+|MUL
|NULL
|NULL
|
|
Line 102:
Line 97:
|NULL
|NULL
|
|
−|transaction type
+|[[Transaction_type|transaction type]]
|-
|-
|num_releve
|num_releve
Line 123:
Line 118:
|tinyint(4)
|tinyint(4)
|YES
|YES
−|
+|MUL
|0
|0
|
|
Line 135:
Line 130:
|
|
|note
|note
−|-
|-
|fk_bordereau
|fk_bordereau
Line 167:
Line 154:
|
|
|name of the issuer of the check
|name of the issuer of the check
−|}
+|-
+|author
+|varchar(40)
+|YES
+|
+|NULL
+|
+|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
+|}