civicrm_grant


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 null

Unique Grant id

contact_id INT UNSIGNED 10 null
civicrm_contact.id FK_civicrm_grant_contact_id C

Contact ID of contact record given grant belongs to.

application_received_date DATE 10 null

Date on which grant application was received by donor.

decision_date DATE 10 null

Date on which grant decision was made.

money_transfer_date DATE 10 null

Date on which grant money transfer was made.

grant_due_date DATE 10 null

Date on which grant report is due.

grant_report_received TINYINT 3 null

Yes/No field stating whether grant report was received by donor.

grant_type_id INT UNSIGNED 10 null

Type of grant. Implicit FK to civicrm_option_value in grant_type option_group.

amount_total DECIMAL 20,2 null

Requested grant amount, in default currency.

amount_requested DECIMAL 20,2 null

Requested grant amount, in original currency (optional).

amount_granted DECIMAL 20,2 null

Granted amount, in default currency.

currency VARCHAR 3 null

3 character string, value from config setting or input via user.

rationale TEXT 65535 null

Grant rationale.

status_id INT UNSIGNED 10 null

Id of Grant status.

financial_type_id INT UNSIGNED 10 null
civicrm_financial_type.id FK_civicrm_grant_financial_type_id N

FK to Financial Type.

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_civicrm_grant_contact_id Performance Asc contact_id
FK_civicrm_grant_financial_type_id Performance Asc financial_type_id
index_grant_type_id Performance Asc grant_type_id
index_status_id Performance Asc status_id

Relationships