.. index:: Grant_Deadline_Data_Template ============================ Grant_Deadline_Data_Template ============================ .. default-role:: doc :Description: Obsolete. Can drop from MySQL once we are on Solutions frozen version #2 or higher Columns ======= **ID** ``int(11) NOT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **Selected** ``bit(1) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **award_number** ``varchar(255) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **project_number** ``varchar(255) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **award_name** ``varchar(255) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **project_organization** ``varchar(255) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **award_start_date** ``datetime DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **true_sponsor_end_date** ``datetime DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **award_end_date** ``datetime DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **principal_investigator** ``varchar(255) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **project_manager** ``varchar(255) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **project_funding_amount** ``double DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **last_change** ``timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()`` :Options: ``display="true", null="true", search="false", type=""``