From Dolibarr Wiki

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

Content/Contenu/Contenido

Contains the proyects.

Contient des projets.

Contiene los proyectos.

Structure

Table

Field	Type	Null	Key	Default	Extra	Description
rowid	int(11)	NO	PRI		auto_increment	technical index
fk_soc	int(11)	YES	MUL	NULL		ID of society (llx_societe->rowid)
datec	date	YES		NULL		date creation project
tms	timestamp	NO		Current date		Date of last modification. See page Field Tms.
dateo	date	YES		NULL		date start project
datee	date	YES		NULL		date end project
ref	varchar(30)	YES	UNI	NULL		project reference
entity	int(11)	NO	UNI	1		multi company id
title	varchar(255)	YES		NULL		project title
fk_user_resp	int(11)	YES		NULL		ID of user responsable of project (llx_user->rowid)
fk_user_creat	int(11)	NO		NULL		ID of creator user (llx_user->rowid)
public	int(11)	NO				is project public?
fk_statut	smallint(6)	NO		0		status
note_private	text	YES		NULL		private comentary notes
note_public	text	YES		NULL		public comentary notes
model_pdf	varchar(50)	YES		NULL		Model PDF to print

 

Keys

Key	Type	Fields
PRIMARY	PRIMARY	rowid
uk_projet_ref	UNIQUE	ref,entity
idx_projet_fk_soc	MULTIPLE	fk_soc