~singpolyma/jmp-schemas

ref: 589f2e6bed96c7d358b9daabb8ccddd57afb8b64 jmp-schemas/sqitch.plan -rw-r--r-- 1.5 KiB
For every $15 deposited, add one invite code
unused_invites view

View to get all invites not yet used up.
invites table

Table to store invite codes and their status.  Stores who make the code and
when, who used the code (if anyone has used it yet) and when, and the code
itself. Codes are single-use so once used_by_id is set the code cannot be used again.
plan_log uses a tsrange instead of two timestamps now

This is honestly just more correct, but also allows for easy checking of
non-overlapping ranges, which we now do.
tag for deploy of jmp-pay to production
Create table for cdr storage

Some of this data is not needed for billing (such as disposition, or full tel of
the other side vs a prefix) however it will be very useful if we expose call
logs to the user.  If this is a privacy concern we can allow users to request
deletion of CDRs from past billing periods in the future.
View for the most current plan for each customer

This includes a plan even if it is expired, with the expires_at present for
checking if desired.  This is because an expired user may still want to may a
payment or similar, and checking their plan is how we know what currency to
charge them in.
Table to log plans active on different accounts
Allow sub-cent transactions for minute billing
Create the transactions table