vb_util_zk_recht

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

zr_identif

varchar

255

√

null

ingangsdatum_recht

varchar

√

null

aandeel

varchar

√

null

ar_teller

int4

√

null

ar_noemer

int4

√

null

subject_identif

varchar

255

√

null

koz_identif

numeric

√

null

indic_betrokken_in_splitsing

varchar

255

√

null

omschr_aard_verkregen_recht

varchar

200

√

null

fk_3avr_aand

varchar

√

null

aard_verkregen_recht.aand

Implied Constraint

aantekeningen

text

2147483647

√

null

Relationships

Close relationships within degrees of separation

View Definition

SELECT zakrecht.identificatie AS zr_identif,
    zakrecht.begingeldigheid AS ingangsdatum_recht,
    ((COALESCE((tenaamstelling.aandeel_teller)::text, '0'::text) || '/'::text) || COALESCE((tenaamstelling.aandeel_noemer)::text, '0'::text)) AS aandeel,
    tenaamstelling.aandeel_teller AS ar_teller,
    tenaamstelling.aandeel_noemer AS ar_noemer,
    (((COALESCE(tenaamstelling.tennamevan, ''::character varying))::text || (COALESCE(vve.heeftverenigingvaneigenaren, ''::character varying))::text) || (COALESCE(tenaamstelling2.tennamevan, ''::character varying))::text) AS subject_identif,
    mandeligheid.identificatie AS mandeligheid_identif,
    vuzrok.rustop_zak_recht AS koz_identif,
    (zakrecht.isbetrokkenbij IS NOT NULL) AS indic_betrokken_in_splitsing,
    zakrecht.aard AS omschr_aard_verkregen_recht,
    zakrecht.aard AS fk_3avr_aand,
    array_to_string(( SELECT array_agg((((((((((((((((((((('id: '::text || (aantekening.identificatie)::text) || ', '::text) || 'aard: '::text) || (COALESCE(aantekening.aard, ''::character varying))::text) || ', '::text) || 'begin: '::text) || COALESCE((aantekening.begingeldigheid)::text, ''::text)) || ', '::text) || 'beschrijving: '::text) || (COALESCE(aantekening.omschrijving, ''::character varying))::text) || ', '::text) || 'eind: '::text) || COALESCE((aantekening.einddatum)::text, ''::text)) || ', '::text) || 'koz-id: '::text) || (COALESCE(aantekening.aantekeningkadastraalobject, ''::character varying))::text) || ', '::text) || 'subject-id: '::text) || (COALESCE(aantekening.betrokkenpersoon, ''::character varying))::text) || '; '::text)) AS array_agg
           FROM brk.recht aantekening
          WHERE ((aantekening.aantekeningkadastraalobject)::text = (vuzrok.rustop_zak_recht)::text)), ' & '::text) AS aantekeningen
   FROM ((((((brk.recht zakrecht
     LEFT JOIN brk.recht tenaamstelling ON (((zakrecht.identificatie)::text = (tenaamstelling.van)::text)))
     LEFT JOIN brk.recht vve ON (((zakrecht.isbetrokkenbij)::text = (vve.identificatie)::text)))
     LEFT JOIN brk.vb_util_zk_recht_op_koz vuzrok ON (((zakrecht.identificatie)::text = (vuzrok.identificatie)::text)))
     LEFT JOIN brk.recht mandeligheid ON (((zakrecht.isbestemdtot)::text = (mandeligheid.identificatie)::text)))
     LEFT JOIN brk.vb_util_zk_recht_op_koz vuzrok2 ON (((mandeligheid.heefthoofdzaak)::text = (vuzrok2.rustop_zak_recht)::text)))
     LEFT JOIN brk.recht tenaamstelling2 ON (((vuzrok2.identificatie)::text = (tenaamstelling2.van)::text)))
  WHERE (split_part((zakrecht.identificatie)::text, ':'::text, 1) = 'NL.IMKAD.ZakelijkRecht'::text); SELECT zr.kadaster_identif AS zr_identif,
    zr.ingangsdatum_recht,
    (((COALESCE((zr.ar_teller)::text, ('0'::character varying)::text) || ('/'::character varying)::text) || COALESCE((zr.ar_noemer)::text, ('0'::character varying)::text)))::character varying(20) AS aandeel,
    (zr.ar_teller)::integer AS ar_teller,
    (zr.ar_noemer)::integer AS ar_noemer,
    zr.fk_8pes_sc_identif AS subject_identif,
    zr.fk_7koz_kad_identif AS koz_identif,
    zr.indic_betrokken_in_splitsing,
    avr.omschr_aard_verkregenr_recht AS omschr_aard_verkregen_recht,
    zr.fk_3avr_aand,
    array_to_string(( SELECT array_agg((((((((((((((((((((('id: '::text || (COALESCE(zra.kadaster_identif_aantek_recht, ''::character varying))::text) || ', '::text) || 'aard: '::text) || (COALESCE(zra.aard_aantek_recht, ''::character varying))::text) || ', '::text) || 'begin: '::text) || (COALESCE(zra.begindatum_aantek_recht, ''::character varying))::text) || ', '::text) || 'beschrijving: '::text) || (COALESCE(zra.beschrijving_aantek_recht, ''::character varying))::text) || ', '::text) || 'eind: '::text) || (COALESCE(zra.eindd_aantek_recht, ''::character varying))::text) || ', '::text) || 'zkr-id: '::text) || (COALESCE(zra.fk_5zkr_kadaster_identif, ''::character varying))::text) || ', '::text) || 'subject-id: '::text) || (COALESCE(zra.fk_6pes_sc_identif, ''::character varying))::text) || '; '::text)) AS array_agg
           FROM zak_recht_aantek zra
          WHERE ((zra.fk_5zkr_kadaster_identif)::text = (zr.kadaster_identif)::text)), '&& '::text) AS aantekeningen
   FROM (zak_recht zr
     JOIN aard_verkregen_recht avr ON (((zr.fk_3avr_aand)::text = (avr.aand)::text)));

Description

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views