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                     |