Tables Relationships Utility Tables Constraints Anomalies Columns Donate

Table frontend.public.applicant Wnioskodawca - sekcja 0, sekcja B | Generated by SchemaSpy

Related columns Constraint names Comments Legend |
Legend: |
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments
--- | --- | --- | --- | --- | --- | --- | --- | ---
id | serial | 10 |  | √ | nextval('applicant_id_seq'::regclass) |
applicant_nip.id_applicant | applicant_fk
applicant_person_agreement.id_applicant | applicant_person_agreement_applicant
applicant_person_contact.id_applicant | applicant_person_contact_applicant
application_form_info.id_applicant | applicant_fk
assistance_de_minimis.id_applicant | assistance_de_minimis_applicant
|  | Identyfikator
id_form | int4 | 10 | √ |  | null |  |
application_form.id | application_form_fk
| Identyfikator wniosku
id_subject | int4 | 10 | √ |  | null |  |
subject.id | applicant_subject
| Identyfikator podmiotu
id_type_of_applicant | int4 | 10 | √ |  | null |  |
type_of_applicant.id | applicant_type_of_applicant
| Identyfikator typu adresu
id_type_of_record | int4 | 10 | √ |  | null |  |
type_of_record.id | id_type_of_record_fk
| Identyfikator typu ewidencji
name | varchar | 500 | √ |  | null |  |  | Nazwa - sekcja B.1
pesel | varchar | 16 | √ |  | null |  |  | Numer pesel - sekcja B.6
pesel_no_concern | bool | 1 | √ |  | null |  |  | Pesel - nie dotyczy
id_registration_address | int4 | 10 | √ |  | null |  |
address.id | id_registration_address_fk
| Identyfikator adresu zameldowania
id_correspondence_address | int4 | 10 | √ |  | null |  |
address.id | id_correspondence_address_fk
| Identyfikator adresu (korespondencyjnego) - sekcja B.4
phone | varchar | 30 | √ |  | null |  |  | Telefon
fax_no | varchar | 30 | √ |  | null |  |  | Numer faksu
email | varchar | 64 | √ |  | null |  |  | Email
website_url | varchar | 64 | √ |  | null |  |  | Adres url - sekcja B.4
has_subject | bool | 1 | √ |  | null |  |  | pomocCharakterystyka podmiotu prowadzącego działalność gospodarczą - B.7
other_legal_form | varchar | 500 | √ |  | null |  |  | Inna forma prawna - sekcja B.1
assistance_de_minimis | bool | 1 | √ |  | null |  |  | Pomoc de minimis - sekcja B.11
assistance_de_minimis_amount | numeric | 15,2 | √ |  | null |  |  | Pomoc - de minimis - suma
assistance_new_workplaces | bool | 1 | √ |  | null |  |  | Pomoc - nowe miejsca pracy - sekcja B.12
assistance_new_workplaces_amount | numeric | 15,2 | √ |  | null |  |  | Pomoc - nowe miejsca pracy - kwota
assistance_new_workplaces_description | varchar | 2048 | √ |  | null |  |  | Pomoc - nowe miejsca pracy - opis - sekcja B.12
form_another_project | bool | 1 | √ |  | null |  |  | Dofinansowanie innego projektu - sekcja B.13
id_form_another_project | int4 | 10 | √ |  | null |  |
application_form.id | applicant_form_another_project
| Identyfikator
id_legal_form | int4 | 10 |  |  | 0 |  |
legal_form.id | id_legal_form_fk
| Identyfikator formy prawnej
number_krs | varchar | 100 | √ |  | null |  |  | Numer krs - sekcja B.4
number_edg | varchar | 100 | √ |  | null |  |  | Numer edg - sekcja B.4
regon | varchar | 50 | √ |  | null |  |  | Numer regon - sekcja B.4, B.9
experience | varchar | 3072 | √ |  | null |  |  | Doświadczenie - sekcja B.10
krs_edg_concern | bool | 1 | √ |  | null |  |  | Dotyczy krs edg - sekcja B.4
Analyzed at Wed Nov 26 19:04 CET 2008

Indexes:

Column(s) | Type | Sort | Constraint Name | Anomalies
--- | --- | --- | --- | ---
id | Primary key | Asc | applicant_pkey |
id_form | Must be unique | Asc | applicant_id_form_unique | This unique column is also nullable

Close relationships within one two degrees of separation: