Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | INT UNSIGNED | 10 | √ | null |
|
|
Unique Grant id |
|||
| contact_id | INT UNSIGNED | 10 | null |
|
|
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 |
|
|
FK to Financial Type. |
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
Close relationships within degrees of separation
