ref,int(11),NO,PRI,,auto_increment
name,text,YES,,,
description,text,YES,,,
deadline,datetime,YES,,,
email,varchar(200),YES,,,
contact,varchar(100),YES,,,
finaluse,text,YES,,,
resource_types,varchar(50),YES,,,
noresources,int(11),YES,,,
shape,varchar(50),YES,,,
created,datetime,YES,,,
user,int(11),YES,,,
assigned_to,int(11),YES,,,
status,int(11),NO,,0,
collection,int(11),YES,MUL,,
custom_fields_json,longtext,YES,,,