Grant_Deadline_Data_Template

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=""