Table d45civi_b72v5.civicrm_grant Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id int unsigned 10  √  Unique Grant id
contact_id int unsigned 10
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 Type of grant. Implicit FK to civicrm_option_value in grant_type option_group.
amount_total decimal 20,2 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 3 character string, value from config setting or input via user.
rationale text 65535  √  null Grant rationale.
status_id int unsigned 10 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 at Wed Nov 11 17:12 EST 2015

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

Close relationships  within of separation: