= Nangu.tv TVoD CDR =

Portax process Nangu.tv generated CDR and reports on regular basis. Processed data is stored in PostgreSQL database and made available to authorized users.

'''cibs''' user is allowed to connect to the '''vod''' database running at '''pgsql://172.25.7.12''' from internal RIOMedia network.

== Available tables ==

{{{
vod=# \dt
                        List of relations
 Schema |                  Name                   | Type  | Owner 
--------+-----------------------------------------+-------+-------
 public | billing-offers                          | table | vod
 public | billing-tariffs                         | table | vod
 public | billing-tariffs-offers-prices           | table | vod
 public | billing-tariffs-setup-prices            | table | vod
 public | cdr-offer                               | table | vod
 public | cdr-tvod                                | table | vod
 public | provisioning-subscribers-subscriptions  | table | vod
 public | provisioning-subscriptions-stb-accounts | table | vod
(8 rows)
}}}

== Permissions ==

{{{
vod=# \z
                          Access privileges for database "vod"
 Schema |                  Name                   | Type  |      Access privileges      
--------+-----------------------------------------+-------+-----------------------------
 public | billing-offers                          | table | {vod=arwdxt/vod,cibs=r/vod}
 public | billing-tariffs                         | table | {vod=arwdxt/vod,cibs=r/vod}
 public | billing-tariffs-offers-prices           | table | {vod=arwdxt/vod,cibs=r/vod}
 public | billing-tariffs-setup-prices            | table | {vod=arwdxt/vod,cibs=r/vod}
 public | cdr-offer                               | table | {vod=arwdxt/vod,cibs=r/vod}
 public | cdr-tvod                                | table | {vod=arwdxt/vod,cibs=r/vod}
 public | provisioning-subscribers-subscriptions  | table | {vod=arwdxt/vod,cibs=r/vod}
 public | provisioning-subscriptions-stb-accounts | table | {vod=arwdxt/vod,cibs=r/vod}
(8 rows)
}}}

== Table content ==

Comprehensive field description is available in Nangu.tv's documentation at attachment:nangu-platform-interfaces.pdf

 billing-offers::

 billing-tariffs::

 billing-tariffs-offers-prices::

 billing-tariffs-setup-prices::

 cdr-offer, cdr-tvod::

{{{
vod=> \d "cdr-offer"
                 Table "public.cdr-offer"
       Column       |           Type           | Modifiers 
--------------------+--------------------------+-----------
 isp_id             | integer                  | 
 id                 | integer                  | 
 generated          | timestamp with time zone | 
 type               | character varying        | 
 subtype            | character varying        | 
 subscriber_id      | integer                  | 
 subscriber_code    | character varying        | 
 subscription_id    | integer                  | 
 subscription_code  | character varying        | 
 tvod_category_id   | integer                  | 
 tvod_category_code | character varying        | 
 tariff_id          | integer                  | 
 tariff_code        | character varying        | 
 offer_id           | integer                  | 
 offer_code         | character varying        | 
 price_value        | double precision         | 
 price_code         | character varying        | 
 timestamp_start    | timestamp with time zone | 
 timestamp_end      | timestamp with time zone | 
 units              | integer                  | 
 movie_name         | character varying        | 
 movie_prefix_code  | character varying        | 
}}}

 provisioning-subscribers::

{{{
vod=> \d "provisioning-subscribers";
        Table "public.provisioning-subscribers"
     Column      |           Type           | Modifiers 
-----------------+--------------------------+-----------
 isp_code        | integer                  | 
 subscriber_code | character varying        | 
 create_date     | timestamp with time zone | 
 first_name      | character varying        | 
 middle_name     | character varying        | 
 last_name       | character varying        | 
 street          | character varying        | 
 city            | character varying        | 
 county          | character varying        | 
 country_iso2    | character varying        | 
 zip_code        | character varying        | 
 customer_number | character varying        | 
 username        | character varying        | 
 email           | character varying        | 
 sex             | character varying        | 
 note            | text                     | 
}}}

 provisioning-subscribers-subscriptions::

{{{
vod=> \d "provisioning-subscribers-subscriptions";
          Table "public.provisioning-subscribers-subscriptions"
              Column               |           Type           | Modifiers 
-----------------------------------+--------------------------+-----------
 isp_code                          | integer                  | 
 subscriber_code                   | character varying        | 
 subscription_code                 | character varying        | 
 create_date                       | timestamp with time zone | 
 provisioning_address_street       | character varying        | 
 provisioning_address_city         | character varying        | 
 provisioning_address_county       | character varying        | 
 provisioning_address_country_iso2 | character varying        | 
 provisioning_address_zip_code     | character varying        | 
 shipping_address_street           | character varying        | 
 shipping_address_city             | character varying        | 
 shipping_address_county           | character varying        | 
 shipping_address_country_iso2     | character varying        | 
 shipping_address_zip_code         | character varying        | 
 locality_code                     | character varying        | 
 parental_search                   | character varying        | 
 parental_detail                   | character varying        | 
 parental_pin                      | character varying        | 
 master_pin                        | character varying        | 
 charge_limit                      | character varying        | 
 tvod_ordered                      | boolean                  | 
 tariff_code                       | character varying        | 
 currency_code                     | character varying        | 
 alt_currency_code                 | character varying        | 
 subscription_state                | character varying        | 
 enable_date                       | character varying        | 
 note                              | character varying        | 
}}}

 provisioning-subscriptions-stb-accounts::

{{{
vod=> \d "provisioning-subscriptions-stb-accounts";
           Table "public.provisioning-subscriptions-stb-accounts"
                Column                |           Type           | Modifiers 
--------------------------------------+--------------------------+-----------
 isp_code                             | integer                  | 
 subscription_code                    | character varying        | 
 subscription_stb_account_code        | character varying        | 
 subscription_stb_account_create_date | timestamp with time zone | 
 puk                                  | character varying        | 
 allowed_ips                          | character varying        | 
 ip_address                           | character varying        | 
 stb_mac                              | macaddr                  | 
 stb_serial                           | character varying        | 
 stb_create_date                      | timestamp with time zone | 
 stb_note                             | text                     | 
 stb_model_code                       | character varying        | 
 stb_model_description                | text                     | 
}}}