Table llx contrat: Difference between revisions

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search
VisualWikitext
No edit summary
Line 10: Line 10:


= 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"
 
|style="background-color: #e9e9ef"| <b>Field</b>
<pre>
|style="background-color: #e9e9ef"| <b>Type</b>
-- ============================================================================
|style="background-color: #e9e9ef"| <b>Null</b>
-- Copyright (C) 2002-2004 Rodolphe Quiedeville <rodolphe@quiedeville.org>
  |style="background-color: #e9e9ef"| <b>Key</b>
-- Copyright (C) 2004      Laurent Destailleur <eldy@users.sourceforge.net>
|style="background-color: #e9e9ef"| <b>Default</b>
--
|style="background-color: #e9e9ef"| <b>Extra</b>
-- This program is free software; you can redistribute it and/or modify
|style="background-color: #e9e9ef"| <b>Description</b>
-- it under the terms of the GNU General Public License as published by
|-  
-- the Free Software Foundation; either version 2 of the License, or
| rowid
-- (at your option) any later version.
| int(11)  
--
| &nbsp;
-- This program is distributed in the hope that it will be useful,
| PRI
-- but WITHOUT ANY WARRANTY; without even the implied warranty of
| NULL
-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
| auto_increment
-- GNU General Public License for more details.
| technical index
--
|-
-- You should have received a copy of the GNU General Public License
| tms
-- along with this program; if not, write to the Free Software
| timestamp
-- Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
|
--
|
-- $Id: llx_contrat.sql,v 1.5 2004/10/09 10:47:16 opensides Exp $
|
-- $Source: /cvsroot/dolibarr/dolibarr/mysql/tables/llx_contrat.sql,v $
|
--
|
-- ============================================================================
|-
 
| enservice
create table llx_contrat
| smallint
(
|
  rowid          integer AUTO_INCREMENT PRIMARY KEY,
|
  tms            timestamp,
| 0
  enservice      smallint DEFAULT 0,
|
  mise_en_service datetime,
|
  fin_validite    datetime,
|-
  date_cloture   datetime,
| mise_en_service
  fk_soc         integer NOT NULL,
| datetime
   fk_product     integer NOT NULL,
|
   fk_facture     integer NOT NULL default 0,
|
  fk_facturedet   integer NOT NULL default 0,
|
  fk_user_author  integer NOT NULL default 0,
|
  fk_user_mise_en_service integer,
|
  fk_user_cloture integer
|-
)type=innodb;
| fin_validate
</pre>
| datetime  
|
|
|
|
|
|-
| date_cloture
| datetime  
|
|
|
|
|
|-
| fk_soc
| int(11)
|
|
|    
|
| ID of society
|-
| fk_product
| int(11)
|
|
|    
|
| ID of product
|-
| fk_facture  
| int(11)
|
|
| 0
|
| ID of facture
|-
| fk_facturedet
| int(11)
|
|
| 0
|
|
|-
| fk_user_author
| int(11)
|
|
| 0  
|
|
|-
| fk_user_mis_en_service
| int(11)
|
|
|
|
|
|-
| fk_user_cloture
| int(11)  
|
|
|
|
|
|}

Revision as of 08:36, 12 May 2009


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

Return to developer
documentation index

File Doc dev.png

Retour index
Documentation développeur

File Doc dev.png

Volver al índice
Documentación desarrolladores

File Doc dev.png

返回
开发文档

File Doc dev.png


Contenu

Structure

Field Type Null Key Default Extra Description
rowid int(11)   PRI NULL auto_increment technical index
tms timestamp
enservice smallint 0
mise_en_service datetime
fin_validate datetime
date_cloture datetime
fk_soc int(11) ID of society
fk_product int(11) ID of product
fk_facture int(11) 0 ID of facture
fk_facturedet int(11) 0
fk_user_author int(11) 0
fk_user_mis_en_service int(11)
fk_user_cloture int(11)
Retrieved from "https://wiki.dolibarr.org/index.php?title=Table_llx_contrat&oldid=11424"