nenajdena zmluva?
Opened this issue · 1 comments
https://www.aktuality.sk/clanok/628847/nova-sefka-vszp-si-lacno-kupila-byt-od-rezortu-vnutra/
na CRZ maju tu zmluvu
u nas ale ked dam hladat Ľubica Hlinková tak mi ju nenajde. Preco?
v prod datach nie je, ale v source datach je:
set search_path="source_ekosystem_CRZ_20180928050407";
select * from contracts where id=1663181;
-[ RECORD 1 ]---------------------------+---------------------------------------------------------------
id | 1663181
contract_identifier | SHNM_ZM_SHNM-OSNM4-3-127-2014-KZ_2014
contracting_authority_name | PhDr. Ľubica Hlinková, MPH
contracting_authority_formatted_address |
contracting_authority_cin_raw |
supplier_name | Ministerstvo vnútra Slovenskej republiky
supplier_formatted_address | Pribinova 2, 812 72 Bratislava
supplier_cin_raw | 00151866
subject | Zmluva o prevode vlastníctva bytu s dohodou o predkupnom práve
subject_description |
signed_on | 2014-12-15
effective_from | 2014-12-19
effective_to |
effective_note |
contract_price_amount | 11288.0
contract_price_total_amount | 11288.0
note |
department_id | 114723
published_at | 2014-12-18 12:43:04
changed_at | 2014-12-18 12:39:33
change_note |
status_id | 2
type_id | 1
kind_id | 1
internal_id | 0
internal_note |
confirmation_status_id | 2
confirmation_file_name |
confirmed_on |
source_id | 1
description |
reference |
created_at | 2016-07-08 17:55:40.623741
updated_at | 2018-07-23 13:58:54.852569
contracting_authority_cin |
supplier_cin | 151866
Da sa vidno ze contracting_authority_formatted_address je prazdna a preto nevytvorime entitu ... mozno by sme mali mat koncept neznamej adresy, ktoru by sme nezobrazovali na mape?