Source Downloads

Database v1

This is a sample MySQL database schema to serve as an example for discussion.  It contains the basic structure for

  • Company Registration Module (tables prefixed rg_)
  • Exchange Module (tables prefixed ex_)
The company registration module is where organizations would register their company.  It would also house fundamental data for the company(balance sheet, income statement). The source of the fundamental data is likely the annual form 990 tax forms that all non-profits are required to file and make public.   The form 990 transaction feeds all other financial tables (income statement, balance sheet, key people, compensation etc.)

The exchange module represents a central place for registered organizations to create campaign transactions to raise funds. However, it also has tables for fundraising through annual membership dues since non-profit fundraising entails more than just campaigns (often: Campaigns, member dues, tax exempt sales & services).