Table llx don

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 list of donations

Contient la liste des dons

Contiene la lista subvenciones

Structure

Table

Field	Type	Null	Key	Default	Extra	Description
rowid	int(11)	NO	PRI	NULL	auto_increment	technical index
ref	varchar(30)	YES		NULL		don reference
entity	int(11)	NO		1		multi company id
tms	timestamp	NO		Current date		Date of last modification. See page Field Tms.
fk_statut	smallint(6)	NO		0		State of donation (prometed, validated)
datec	datetime	YES		NULL		creation date
datedon	datetime	YES		NULL		donation date
amount	real	YES		0		amount of donation
fk_payment	int(11)	YES		NULL		ID mode of payment
prenom	varchar(50)	YES		NULL		donator first name
nom	varchar(50)	YES		NULL		donator name
societe	varchar(50)	YES		NULL		donator
adresse	text	YES		NULL		donator adress
cp	varchar(30)	YES		NULL		Postal Code of donator
ville	varchar(50)	YES		NULL		city of donator
pays	varchar(50)	YES		NULL		country of donator
email	varchar(255)	YES		NULL		donator e-mail
public	smallint(6)			1		is the donation public?
fk_don_projet	int(11)	YES		NULL		ID of proyect (llx_projet->rowid)
fk_user_author	int(11)					ID creator user (llx_user->rowid)
fk_user_valid	int(11)	YES		NULL		ID validator user (llx_user->rowid)
note	text	YES		NULL		comentary
note_public	text	YES		NULL		public comentary
model_pdf	varchar(50)	YES		NULL		model PDF to print
import_key	varchar(14)	YES		NULL		Code used to save the import id. See page Field Import key.

 

Keys

Key	Type	Fields
PRIMARY	PRIMARY	rowid