Tables Relationships Utility Tables Constraints Anomalies Columns Donate

Table frontend.public.subject Podmiot - 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_id_seq'::regclass) |
applicant.id_subject | applicant_subject
subject_partner.id_subject | subject_partner_subject
|  | Identyfikator
applicable | bool | 1 | √ |  | null |  |  |
pkd_code_2004 | varchar | 32 | √ |  | null |  |  | Kod pkd 2004
subject_partners | bool | 1 | √ |  | null |  |  | Podmiot partnerski
registration_date | date | 13 | √ |  | null |  |  | Data rejestracji
supplement | varchar | 2048 | √ |  | null |  |  | Uzupełnienie
id_info_last_period | int4 | 10 | √ |  | null |  |
subject_description.id | subject_subject_descrition_last
| Identyfikator okres ostatni
id_info_next_to_last_period | int4 | 10 | √ |  | null |  |
subject_description.id | subject_subject_description_next_to_last
| Identyfikator okres przedostatni
id_info_before_next_to_last_period | int4 | 10 | √ |  | null |  |
subject_description.id | subject_subject_description_before_next_to_last
| Identyfikator okres przed przedostatni
pkd_code_2007 | varchar | 32 | √ |  | null |  |  | Kod pkd 2007
company_type | int4 | 10 |  |  | 0 |  |  | Typ przedsiębiorstwa
Analyzed at Wed Nov 26 19:04 CET 2008

Indexes:

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

Close relationships within one two degrees of separation: