Changeset 1127

Timestamp:

11/21/06 13:24:59 (7 years ago)

Author:

ijm1

Message:

updated schema views to handle extract functionalily to do with plans and cap rollovers.

File:

• ccsd/trunk/dbschema/ccs_billing.schema (modified) (1 diff)

ccsd/trunk/dbschema/ccs_billing.schema

@@ -119 +119 @@
     customer_account a ON c.contact_id=a.contact_id HAVING c.type='customer';
 
+-- List of plans overviews, including rate data.
+CREATE VIEW plans AS SELECT p.*, r.plan_name AS rad_plan_name,r.upstream_kbps,
+        r.downstream_kbps FROM billing_plan p, radius_plan r WHERE r.plan_id=p.radius_plan;
+
+-- Gets information needed for rollover. use with "WHERE cap_period='weekly'
+-- to get rollovers that are done weekly
+CREATE VIEW rollover AS SELECT a.plan_name, a.description, a.price,
+        a.included_mb, a.cap_period, b.contact_id FROM billing_plan a, 
+        customer_state b WHERE b.plan_id=a.plan_id;
+        
 -- vim: ft=sql