Field,Type,Null,Key,Default,Extra
id,"int unsigned",NO,PRI,NULL,auto_increment
name,varchar(100),NO,,NULL,
description,mediumtext,YES,,NULL,
idClient,int,YES,MUL,NULL,
projectCode,varchar(25),YES,,NULL,
contractCode,varchar(25),YES,,NULL,
color,varchar(7),YES,,NULL,
idProject,"int unsigned",YES,MUL,NULL,
idle,"int unsigned",YES,,0,
idUser,"int unsigned",YES,MUL,NULL,
done,"int unsigned",YES,,0,
idleDate,date,YES,,NULL,
doneDate,date,YES,,NULL,
idContact,"int unsigned",YES,MUL,NULL,
sortOrder,varchar(600),YES,MUL,NULL,
idProjectType,"int unsigned",YES,,NULL,
codeType,varchar(10),YES,,OPE,
idRecipient,"int unsigned",YES,MUL,NULL,
paymentDelay,int,YES,,NULL,
longitude,"decimal(15,12)",YES,,NULL,
latitude,"decimal(15,12)",YES,,NULL,
idStatus,"int unsigned",YES,MUL,NULL,
idHealth,"int unsigned",YES,,NULL,
fixPlanning,"int unsigned",YES,,0,
clientCode,varchar(25),YES,,NULL,
idOverallProgress,"int unsigned",YES,,NULL,
cancelled,"int unsigned",YES,,0,
idQuality,"int unsigned",YES,,NULL,
idTrend,"int unsigned",YES,,NULL,
idSponsor,"int unsigned",YES,,NULL,
creationDate,date,YES,,NULL,
objectives,mediumtext,YES,,NULL,
idResource,"int unsigned",YES,,NULL,
isUnderConstruction,"int unsigned",YES,,0,
lastUpdateDateTime,datetime,YES,,NULL,
idOrganization,"int unsigned",YES,MUL,NULL,
organizationInherited,"int unsigned",YES,,NULL,
organizationElementary,"int unsigned",YES,,NULL,
idCategory,"int unsigned",YES,,NULL,
handled,int,YES,,0,
handledDate,date,YES,,NULL,
excludeFromGlobalPlanning,"int unsigned",YES,,0,
fixPerimeter,"int unsigned",YES,,0,
isLeaveMngProject,"int unsigned",YES,,0,