~singpolyma/jmp-schemas

jmp-schemas/deploy/call_rates.sql -rw-r--r-- 283 bytes
395bb797Stephen Paul Weber Tag for notify on top up an expired account a month ago
                                                                                
1
2
3
4
5
6
7
8
9
10
11
12
13
14
-- Deploy jmp:call_rates to pg
-- requires: cdr

BEGIN;

CREATE TABLE call_rates (
	prefix    TEXT           NOT NULL,
	direction call_direction NOT NULL,
	plan_name TEXT           NOT NULL,
	rate      NUMERIC        NOT NULL,
	PRIMARY KEY (prefix, direction, plan_name)
);

COMMIT;