28,936
edits
Changes
→Table
Line 13:
Line 13:
+
= 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 24:
Line 25:
| rowid
| rowid
| int(11)
| int(11)
−|
+| NO
| PRI
| PRI
−| NULL
+|
| auto_increment
| auto_increment
| technical index
| technical index
Line 33:
Line 34:
| int(11)
| int(11)
| NO
| NO
−|
+| UNI
|
|
|
|
Line 44:
Line 45:
|
|
|
|
−| ID of contact ([[Table llx_socpeople|llx_socpeople]]->rowid)
+| ID of contact ([[Table llx_socpeople|llx_socpeople]]->rowid). 0 if record not linked to a contact.
|-
|-
| nom
| nom
Line 65:
Line 66:
| varchar(160)
| varchar(160)
| NO
| NO
−|
+| UNI
|
|
|
|
Line 77:
Line 78:
|
|
|
|
+|-
+| tag
+| varchar(128)
+| YES
+|
+| NULL
+|
+| ???
|-
|-
| statut
| statut
Line 86:
Line 95:
| status of send
| status of send
|-
|-
−| url
+| source_url
| varchar(160)
| varchar(160)
| YES
| YES
Line 93:
Line 102:
|
|
| url
| url
+|-
+| source_id
+| integer
+| YES
+|
+| NULL
+|
+| id
+|-
+| source_type
+| varchar(16)
+| YES
+|
+| NULL
+|
+| type of source element
|-
|-
| date_envoi
| date_envoi
Line 101:
Line 126:
|
|
| date of send
| date of send
−|}
+|}
+== 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
+|-
+| uk_mailing_cibles
+| UNIQUE
+| fk_mailing,email
+|-
+| idx_mailing_cibles_email
+| MULTIPLE
+| email
+|}