Table llx paiementfourn facturefourn: Difference between revisions

Table llx paiementfourn facturefourn (view source)

731 bytes added , 16 years ago

4,395

edits

@@ Line 14: / Line 14: @@
 = Structure =
+== Table ==
+'''Version 1.2 2009/10/24'''
 {|  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>
@@ Line 25: / Line 27: @@
 | rowid
 | int(11)
-| &nbsp;
+| NO
 | PRI
-| NULL
+|
 | auto_increment
 | technical index
@@ Line 34: / Line 36: @@
 | int(11)
 | YES
-|
+| UNI
 | NULL
 |
@@ Line 42: / Line 44: @@
 | int(11)
 | YES
-|
+| UNI
 | NULL
 |
@@ Line 54: / Line 56: @@
 |
 | amount of payment
-|}
+|}&nbsp;
+== 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
+|-
+| uk_paiementfourn_facturefourn
+| UNIQUE
+| fk_paiementfourn,fk_facturefourn
+|-
+| idx_paiementfourn_facturefourn_fk_facturefourn
+| MULTIPLE
+| fk_facture
+|-
+| idx_paiementfourn_facturefourn_fk_paiementfourn
+| MULTIPLE
+| fk_facture
+|}&nbsp;