28,936
edits
Changes
→Structure
Line 2:
Line 2:
Contient les statuts de contact de chaque contact commercial. Par exemple "ne pas contacter", "contact en cours", "à contacter au plus tôt", ...+Utilisée pour pour afficher des icônes de statut pour les listes de clients.
−This table contains the contact status of each commercial contact. i.e. "do not contact", "contact pending", "to contact asap",...+Used to display quick icon status in the clients lists.+
+
{{ListOfTables}}
{{ListOfTables}}
−= Contenu =
+= Content/Contenu/Contenido =
−{{flag en}} This table contains the commercial contact status of each third party of type Prospect. i.e. "do not contact", "contact pending", "to contact asap",...
−{{flag fr}} Contient les statuts de contact de chaque tiers de type Prospet . Par exemple "ne pas contacter", "contact en cours", "à contacter au plus tôt", ...
−{{flag sp}} Contiene los estados de contacto de cada tercero de tipo Cliente potencial. Por ejemplo "no contactar", "contacto en curso", "a contactar",...
= Structure =
= Structure =
+== 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>Type</b>
+ |style="background-color: #e9e9ef"| <b>Null</b>
+ |style="background-color: #e9e9ef"| <b>Key</b>
+ |style="background-color: #e9e9ef"| <b>Default</b>
+ |style="background-color: #e9e9ef"| <b>Extra</b>
+ |style="background-color: #e9e9ef"| <b>Description</b>
+|-
+| id
+| int(11)
+| NO
+| PRI
+|
+|
+| technical index
+|-
+| code
+| varchar(12)
+| NO
+| UNI
+|
+|
+| code of status
+|-
+| libelle
+| varchar(30)
+| YES
+|
+| NULL
+|
+| label of status
+|-
+| active
+| tinyint(4)
+| NO
+|
+| 1
+|
+| is the status active?
+|}
+== 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
+| id
+|-
+| code
+| UNIQUE
+| code
+|}