Difference between revisions of "Table llx fichinter"

Latest revision as of 12:42, 10 August 2012

The documentation related to other tables is available on the page: Table SQL
La documentation relative aux autres tables est disponible sur la page: Table SQL
La documentación relativa a otras tablas se encuentra disponible en la página: Table SQL
Eine Dokumentation zu weiteren Tabellen ist auf dieser Seite verfügbar: Table SQL
与其他表相关的文档请参阅：Table SQL

Return to developer
documentation index

Retour index
Documentation développeur

Volver al índice
Documentación desarrolladores

返回
开发文档

Content/Contenu/Contenido

Contains the interventions of the interventions module. The interventions details are in Table_llx_fichinterdet

Cette table contient les enregistrements des interventions du module interventions. Les détails de les interventions sont dans la Table_llx_fichinterdet

Contiene los registros de intervenciones del módulo intervenciones. Los detalles de las intervenciones se encuentran en la Table_llx_fichinterdet

Structure

Table

Field	Type	Null	Key	Default	Extra	Description
rowid	int(11)	NO	PRI		auto_increment	technical index
fk_soc	int(11)	YES	MUL			ID of related society (llx_societe->rowid)
fk_projet	int(11)	YES		0		ID of related proyect (llx_projet->rowid)
fk_contract	int(11)	YES		0		ID of related contract (llx_contrat->rowid)
ref	varchar(30)	NO	UNI			reference
entity	int(11)	NO	UNI	1		multi company id
tms	timestamp	NO		Current date		Date of last modification. See page Field Tms.
date_c	datetime	YES		NULL		creation date
date_valid	datetime	YES		NULL		validation date
datei	date	YES		NULL		livration date
fk_user_author	int(11)	YES		NULL		ID creator user (llx_user->rowid)
fk_user_valid	int(11)	YES		NULL		ID validator user (llx_user->rowid)
fk_statut	smallint(6)	YES		0
duree	real	YES		NULL		intervention duration
description	text	YES		NULL		comentary
note_private	text	YES		NULL		comentary
note_public	text	YES		NULL		public comentary
model_pdf	varchar(50)	YES		NULL		Model PDF to print

Keys

Key	Type	Fields
PRIMARY	PRIMARY	rowid
uk_fichinter_ref	UNIQUE	ref,entity
idx_fichinter_fk_soc	UNIQUE	fk_soc

@@ Line 15: / Line 15: @@
 = 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>Type</b>
@@ Line 26: / Line 27: @@
 | rowid
 | int(11)
-| &nbsp;
+| NO
 | PRI
-| NULL
+|
 | auto_increment
 | technical index
@@ Line 35: / Line 36: @@
 | int(11)
 | YES
-|
+| MUL
 |
 |
@@ Line 58: / Line 59: @@
 | ref
 | varchar(30)
-| no
+| NO
-|
+| UNI
 |
 |
@@ Line 66: / Line 67: @@
 | entity
 | int(11)
-| &nbsp;
+| NO
-|
+| UNI
 | 1
 |
 | multi company id
-|-
+{{FieldTms}}
-| tms
-| timestamp
-| NO
-|
-| CURRENT_TIMESTAMP
-|
-| last update date
 |-
 | date_c
@@ Line 129: / Line 123: @@
 |-
 | duree
-| double
+| real
 | YES
 |
-|
+| NULL
 |
 | intervention duration
@@ Line 167: / Line 161: @@
 |
 | Model PDF to print
-|}
+|}&nbsp;
+== 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_fichinter_ref
+| UNIQUE
+| ref,entity
+|-
+| idx_fichinter_fk_soc
+| UNIQUE
+| fk_soc
+|}&nbsp;