Skip to content

Instantly share code, notes, and snippets.

@cmrn

cmrn/plans.md

Last active August 29, 2015 13:57
Show Gist options
  • Save cmrn/9384393 to your computer and use it in GitHub Desktop.
Save cmrn/9384393 to your computer and use it in GitHub Desktop.
Download ZIP
MHVDBv2 Plans
Raw
plans.md

MHVDBv2

(needs a better name)

Database Design

  • Entities
    • ID (auto)
    • Name (required)
    • Email Address (required for members)
    • Phone number etc (member info)
    • Is a member? (to distinguish members from other things, e.g. ACTPG)
  • Payments
    • ID (auto)
    • Date (required)
    • Entity ID (required)
    • Amount (required, can be negative for outgoings)
    • Source (Bank deposit, Stripe, Bitcoin, etc)
    • Payment or Contribution? (to differentiate "I bought $50 of acrylic from MHV, here's the money" from "Here's $50 membership")
    • Notes/Memo field

Views

  • Sign me up!
  • Update my details (via one-off link sent to email, or OAuth)
  • Payment page (choose amount, choose method, give money)
  • Admin
    • Create a payment
    • View members
    • View other entities
    • View payments (filter by entity and date range)

Technology

I dunno, maybe django or something with a SQLite database. Suggestions welcome!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment