Table llx contrat: Difference between revisions

Jump to navigation Jump to search

Table llx contrat (view source)

Revision as of 08:36, 12 May 2009

465 bytes removed ,  17 years ago
→‎Structure
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)  
|
|
|
|
|
|}
Retrieved from "https://wiki.dolibarr.org/index.php/Special:MobileDiff/11424"

Navigation menu