4,395
edits
Changes
Jump to navigation
Jump to search
→Structure
Line 14:
Line 14:
| NULL
| 0
= Structure =
= Structure =
+== Table ==
+'''Version 1.1 2009/10/07'''
{| 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 25:
Line 27:
| rowid
| rowid
| int(11)
| int(11)
−|
+| NO
| PRI
| PRI
−| NULL
+|
| auto_increment
| auto_increment
| technical index
| technical index
Line 49:
Line 51:
| tms
| tms
| timestamp
| timestamp
−| YES
+| NO
|
|
| CURRENT_TIMESTAMP
| CURRENT_TIMESTAMP
Line 73:
Line 75:
| fk_typepayment
| fk_typepayment
| int(11)
| int(11)
−| YES
+| NO
+|
|
|
−|
|
| ID type of payment ([[Table llx_c_paiement|llx_c_paiement]]->id)
| ID type of payment ([[Table llx_c_paiement|llx_c_paiement]]->id)
Line 97:
Line 99:
| fk_bank
| fk_bank
| int(11)
| int(11)
−| YES
+| NO
+|
|
|
−|
|
| ID of bank to pay ([[Table llx_bank_account|llx_bank_account]]->rowid)
| ID of bank to pay ([[Table llx_bank_account|llx_bank_account]]->rowid)
Line 118:
Line 120:
|
|
| ID of last modifier user ([[Table llx_user|llx_user]]->rowid)
| ID of last modifier user ([[Table llx_user|llx_user]]->rowid)
−|}
+|}
+== Keys ==
+'''Version 1.1 2009/10/07'''
+{| 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>Key</b>
+ |style="background-color: #e9e9ef"| <b>Type</b>
+ |style="background-color: #e9e9ef"| <b>Fields</b>
+|-
+| PRIMARY
+| PRIMARY
+| rowid
+|}