Tables Relationships Utility Tables Constraints Anomalies Columns Donate

Table frontend.public.subject_description Opis podmiotu - sekcja B.7 | 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('subject_description_id_seq'::regclass) |
subject.id_info_before_next_to_last_period | subject_subject_description_before_next_to_last
subject.id_info_last_period | subject_subject_descrition_last
subject.id_info_next_to_last_period | subject_subject_description_next_to_last
|  | Identyfikator
employment | numeric | 15,2 | √ |  | null |  |  | Zatrudnienie
women_employment | numeric | 15,2 | √ |  | null |  |  | Zatrudnienie kobiet
income_net | numeric | 15,2 | √ |  | null |  |  | Przychody netto
amount_of_assets_keur | numeric | 15,2 | √ |  | null |  |  | Suma aktywów (w tysiącach euro)
independent_subject | bool | 1 | √ |  | null |  |  | Podmiot niezależny
partner_subject | bool | 1 | √ |  | null |  |  | Podmiot partnerski
related_subject | bool | 1 | √ |  | null |  |  | Podmiot związany
subject_25_public | bool | 1 | √ |  | null |  |  | Podmiot 25 publiczny
subject_25_investors | bool | 1 | √ |  | null |  |  | Podmiot 25 inwestorów
subject_physical_relationship | bool | 1 | √ |  | null |  |  | Podmiot związek fizyczny
active | bool | 1 | √ |  | null |  |  | Aktywny - nieaktywny
Analyzed at Wed Nov 26 19:04 CET 2008

Indexes:

Column(s) | Type | Sort | Constraint Name
--- | --- | --- | ---
id | Primary key | Asc | subject_description_pkey

Close relationships within one two degrees of separation: