4,395
edits
Changes
→Structure
Line 15:
Line 15:
| +|-
−|Author
−|varchar(40)
−|YES
−|
−|NULL
−|
−|
= Structure =
= Structure =
+'''Version 1.13 2009/04/27'''
+
{| 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"
{| 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>
Line 26:
Line 28:
| rowid
| rowid
| int(11)
| int(11)
−|
+| NO
| PRI
| PRI
| NULL
| NULL
Line 43:
Line 45:
|date
|date
|YES
|YES
−|
+|MUL
|NULL
|NULL
|
|
Line 51:
Line 53:
|date
|date
|YES
|YES
−|
+|MUL
|NULL
|NULL
|
|
Line 57:
Line 59:
|-
|-
|amount
|amount
−|double
+|double(24,8)
+|NO
|
|
−|0.00000000
−|0
|
|
|amount of the transaction
|amount of the transaction
Line 75:
Line 77:
|int(11)
|int(11)
|YES
|YES
−|
+|MUL
|NULL
|NULL
|
|
Line 123:
Line 125:
|tinyint(4)
|tinyint(4)
|YES
|YES
−|
+|MUL
|0
|0
|
|
Line 135:
Line 137:
|
|
|note
|note
−|-
|-
|fk_bordereau
|fk_bordereau
Line 167:
Line 161:
|
|
|name of the issuer of the check
|name of the issuer of the check
+|-
+|author
+|varchar(40)
+|YES
+|
+|NULL
+|
+|to delete after migration
|}
|}