DM\KlienciBundle\Entity\Client:
type: entity
repositoryClass: DM\KlienciBundle\Repository\ClientRepository
table: rb_clients
id:
id:
type: integer
generator: { strategy: AUTO }
indexes:
telefon_komorkowy1_index:
columns: [ telefon_komorkowy1 ]
telefon_komorkowy2_index:
columns: [ telefon_komorkowy2 ]
telefon_stacjonarny_index:
columns: [ telefon_stacjonarny ]
pesel_index:
columns: [ pesel ]
data_importu_index:
columns: [ data_importu ]
blocked_index:
columns: [ blocked ]
bik_index:
columns: [ bik ]
komornik_index:
columns: [ komornik ]
dochod_index:
columns: [ dochod ]
kwota_wnioskowana_index:
columns: [ kwota_wnioskowana ]
email_index:
columns: [ email ]
komornik_bik_kod_pocztowy_index:
columns: [ komornik, bik, kod_pocztowy ]
ubezpieczenie_samochod_koniec_polisy_index:
columns: [ ubezpieczenie_samochod_koniec_polisy ]
fields:
#dane techniczne
data_importu:
type: datetime
nullable: false
blocked:
type: boolean
nullable: true
datetime_create:
type: datetime
nullable: true
datetime_modify:
type: datetime
nullable: true
old_ids:
type: string
length: 255
nullable: true
send_notification_get_data_date:
type: datetime
nullable: true
contact_agreement:
type: boolean
options:
default: true
contact_agreement_change_datetime:
type: datetime
nullable: true
agreement_expire_at:
type: date
nullable: true
#dane podstawowe
imie:
type: string
length: 100
nullable: false
imie_drugie:
type: string
length: 50
nullable: true
nazwisko:
type: string
length: 100
nullable: false
telefon_komorkowy1:
type: string
length: 20
nullable: true
telefon_komorkowy1_siec:
type: string
length: 20
nullable: true
telefon_komorkowy1_umowa:
type: string
length: 20
nullable: true
telefon_komorkowy1_koniec_umowy:
type: date
nullable: true
telefon_komorkowy2:
type: string
length: 20
nullable: true
telefon_stacjonarny:
type: string
length: 20
nullable: true
fax:
type: string
length: 20
nullable: true
pesel:
type: string
length: 15
nullable: true
email:
type: string
length: 150
nullable: true
plec:
type: string
length: 10
nullable: true
nazwisko_panienskie_matki:
type: string
length: 100
nullable: true
imie_matki:
type: string
length: 50
nullable: true
imie_ojca:
type: string
length: 50
nullable: true
urodzenie_data:
type: string
length: 20
nullable: true
urodzenie_data_auto:
type: date
nullable: true
urodzenie_data_year:
type: smallint
nullable: true
urodzenie_data_month:
type: smallint
nullable: true
urodzenie_data_day:
type: smallint
nullable: true
urodzenie_miejsce:
type: string
length: 100
nullable: true
urodzenie_kraj:
type: string
length: 50
nullable: true
stan_cywilny:
type: string
length: 30
nullable: true
komornik:
type: string
length: 20
nullable: true
bik:
type: string
length: 20
nullable: true
oddluzanie:
type: string
length: 20
nullable: true
# dane dodatkowe
wojewodztwo:
type: string
length: 30
nullable: true
miejscowosc:
type: string
length: 100
nullable: true
poczta:
type: string
length: 100
nullable: true
kod_pocztowy:
type: string
length: 10
nullable: true
ulica:
type: string
length: 150
nullable: true
nr_domu_mieszkania:
type: string
length: 20
nullable: true
kraj:
type: string
length: 40
nullable: true
obywatelstwo:
type: string
length: 40
nullable: true
obywatel_rezydent_podatkowy_usa:
type: string
length: 5
nullable: true
rozlicza_podatki_obywatel_polski:
type: string
length: 5
nullable: true
usa_nip:
type: string
length: 15
nullable: true
# dane szczegolowe
dowod_osobisty_seria_numer:
type: string
lenght: 20
nullable: true
dowod_osobisty_data_waznosci:
type: string
length: 20
nullable: true
dowod_osobisty_data_wydania:
type: string
length: 20
nullable: true
dowod_osobisty_bezterminowy:
type: string
length: 5
nullable: true
dowod_osobisty_wystawca:
type: string
length: 150
nullable: true
dokument_tozsamosci_rodzaj:
type: string
length: 20
nullable: true
paszport_seria_numer:
type: string
lenght: 20
nullable: true
paszport_data_waznosci:
type: string
length: 20
nullable: true
# zatrudnienie
dochod:
type: integer
nullable: true
dochod_zrodlo:
type: string
length: 150
nullable: true
dochod_od_kiedy:
type: string
length: 20
nullable: true
kwota_wnioskowana:
type: integer
nullable: true
kwota_limitu:
type: integer
nullable: true
rodzaj_ksiegowosci:
type: string
length: 100
nullable: true
leadID:
type: string
length: 20
nullable: true
owner:
type: string
length: 100
nullable: true
zgoda_kontakt_telefoniczny:
type: string
length: 10
nullable: true
#firma
czy_klient_biznesowy:
type: string
length: 5
nullable: true
firma_nazwa:
type: string
length: 150
nullable: true
firma_nazwa_skrocona:
type: string
length: 150
nullable: true
firma_telefon:
type: string
length: 20
nullable: true
firma_nip:
type: string
length: 15
nullable: true
firma_regon:
type: string
length: 15
nullable: true
firma_pkd:
type: string
length: 250
nullable: true
firma_krs:
type: string
length: 20
nullable: true
firma_data_rozpoczecia:
type: date
nullable: true
firma_forma_prawna:
type: string
length: 50
nullable: true
firma_rodzaj_ksiegowosci:
type: string
length: 50
nullable: true
firma_email:
type: string
length: 100
nullable: true
firma_sektor:
type: string
length: 100
nullable: true
firma_liczba_pracownikow:
type: string
length: 50
nullable: true
firma_branza:
type: string
length: 50
nullable: true
firma_forma_prawna:
type: string
length: 30
nullable: true
firma_sprzedaz_koniec_roku_biezacego:
type: string
length: 40
nullable: true
firma_limit_w_rachunku_mbank:
type: string
length: 20
nullable: true
korespondencyjny_inny:
type: string
length: 5
nullable: true
korespondencyjny_wojewodztwo:
type: string
length: 30
nullable: true
korespondencyjny_miejscowosc:
type: string
length: 100
nullable: true
korespondencyjny_poczta:
type: string
length: 100
nullable: true
korespondencyjny_kod_pocztowy:
type: string
length: 10
nullable: true
korespondencyjny_ulica:
type: string
length: 150
nullable: true
korespondencyjny_nr_domu_mieszkania:
type: string
length: 20
nullable: true
korespondencyjny_kraj:
type: string
length: 40
nullable: true
adres_zamieszkania_wojewodztwo:
type: string
length: 20
nullable: true
adres_zamieszkania_miejscowosc:
type: string
length: 100
nullable: true
adres_zamieszkania_poczta:
type: string
length: 100
nullable: true
adres_zamieszkania_kod_pocztowy:
type: string
length: 10
nullable: true
adres_zamieszkania_ulica:
type: string
length: 150
nullable: true
adres_zamieszkania_nr_domu_mieszkania:
type: string
length: 20
nullable: true
adres_zamieszkania_inny:
type: string
length: 10
nullable: true
adres_doreczenia_wojewodztwo:
type: string
length: 20
nullable: true
adres_doreczenia_miejscowosc:
type: string
length: 100
nullable: true
adres_doreczenia_poczta:
type: string
length: 100
nullable: true
adres_doreczenia_kod_pocztowy:
type: string
length: 10
nullable: true
adres_doreczenia_ulica:
type: string
length: 150
nullable: true
adres_doreczenia_nr_domu_mieszkania:
type: string
length: 20
nullable: true
doreczenia_inny:
type: string
length: 10
nullable: true
uznania_roczne_szacunkowa_wielkosc:
type: integer
nullable: true
srodki_inne_pochodzenie:
type: string
length: 150
nullable: true
zatrudnienie_forma:
type: string
length: 50
nullable: true
zatrudnienie_dzialalnosc:
type: string
length: 100
nullable: true
praca_forma_wyplaty:
type: string
length: 50
nullable: true
praca_stanowisko:
type: string
length: 100
nullable: true
praca_pracodawca:
type: string
length: 150
nullable: true
pracodawca_nip:
type: string
length: 15
nullable: true
status_bezrobotnego:
type: string
length: 50
nullable: true
zatrudnienie_inne:
type: string
length: 50
nullable: true
kramer:
type: boolean
nullable: false
options:
default: 0
ubezpieczenie_samochod_koniec_polisy:
type: date
nullable: true
distributor:
type: string
length: 255
nullable: true
utm_source:
type: string
length: 255
nullable: true
lokata_data_konca:
type: date
nullable: true
oneToOne:
ClientPart2:
targetEntity: DM\KlienciBundle\Entity\ClientPart2
mappedBy: Client
cascade: [persist, merge, remove]
ClientPart3:
targetEntity: DM\KlienciBundle\Entity\ClientPart3
mappedBy: Client
cascade: [persist, merge, remove]
ClientPart4:
targetEntity: DM\KlienciBundle\Entity\ClientPart4
mappedBy: Client
cascade: [persist, merge, remove]
ClientPart5:
targetEntity: DM\KlienciBundle\Entity\ClientPart5
mappedBy: Client
cascade: [persist, merge, remove]
ClientPart6:
targetEntity: DM\KlienciBundle\Entity\ClientPart6
mappedBy: Client
cascade: [persist, merge, remove]
oneToMany:
klienci_kategorie:
targetEntity: DM\KlienciBundle\Entity\KlienciKategorie
mappedBy: client
cascade: [persist, merge, remove]
history:
targetEntity: DM\KlienciBundle\Entity\History
mappedBy: client
cascade: [persist, merge, remove]
sms_storages:
targetEntity: DM\SmsBundle\Entity\SmsStorage
mappedBy: client
cascade: [ "remove" ]
agreements:
targetEntity: DM\KlienciBundle\Entity\ClientAgreement
mappedBy: client
cascade: [persist, merge, remove]
continue_service_logs:
targetEntity: DM\ContinueServiceBundle\Entity\ContinueServiceLog
mappedBy: client
cascade: [remove]
multistepform_transactions:
targetEntity: DM\MultiStepFormBundle\Entity\Transaction
mappedBy: client
cascade: [remove]
client_instytution_stats:
targetEntity: DM\KlienciBundle\Entity\ClientInstytutionStat
mappedBy: client
cascade: [remove]
Komentarze wyłączone