Table "public.master_branch_descr"
     Column     | Type | Modifiers 
----------------+------+-----------
 brn_code       | text | not null
 brn_descr      | text | 
 country_code   | text | 
 country_descr  | text | 
 cluster_code   | text | 
 cluster_descr  | text | 
 brand_code     | text | 
 brand_descr    | text | 
 chain_code     | text | 
 chain_descr    | text | 
 sbu_code       | text | 
 sbu_descr      | text | 
 group_code     | text | 
 group_descr    | text | 
 region_code    | text | 
 region_descr   | text | 
 division_code  | text | 
 division_descr | text | 
Indexes: master_branch_descr_pkey primary key btree (brn_code),
         master_branch_descr_uidx1 unique btree (brn_code),
         master_branch_descr_uidx2 unique btree (brn_code, brn_descr),
         master_branch_descr_idx1 btree (brn_code, brn_descr, country_code, country_descr),
         master_branch_descr_idx10 btree (chain_code, brn_code),
         master_branch_descr_idx11 btree (chain_descr, brn_code),
         master_branch_descr_idx12 btree (sbu_code, brn_code),
         master_branch_descr_idx13 btree (sbu_descr, brn_code),
         master_branch_descr_idx14 btree (group_code, brn_code),
         master_branch_descr_idx15 btree (group_descr, brn_code),
         master_branch_descr_idx16 btree (region_code, brn_code),
         master_branch_descr_idx17 btree (region_descr, brn_code),
         master_branch_descr_idx18 btree (division_code, brn_code),
         master_branch_descr_idx19 btree (division_descr, brn_code),
         master_branch_descr_idx2 btree (brn_code, brn_descr, cluster_code, cluster_descr),
         master_branch_descr_idx3 btree (brn_descr, brn_code),
         master_branch_descr_idx4 btree (country_code, brn_code),
         master_branch_descr_idx5 btree (country_descr, brn_code),
         master_branch_descr_idx6 btree (cluster_code, brn_code),
         master_branch_descr_idx7 btree (cluster_descr, brn_code),
         master_branch_descr_idx8 btree (brand_code, brn_code),
         master_branch_descr_idx9 btree (brand_descr, brn_code)

 count 
-------
   666
(1 row)

