Tables Relationships Utility Tables Constraints Anomalies Columns Donate

Table backend_dev.public.ctrl_control Kontrola | 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('ctrl_control_id_seq'::regclass) |
control_year.id_control | fk9f45addfe0e684a4
ctrl_control_document.id_control | fkdd2ab911e0e684a4
ctrl_fraud.id_control | fke2bf1390e0e684a4
ctrl_other_document.id_control | fkeafe9dbee0e684a4
|  | Identyfikator
type | int4 | 10 |  |  |  |  |  | Typ: 0 - planowa- kontrola projektów, 1 - planowa- kontrola pre-umów, 2 - planowa - kontrola pomocy technicznej, 3 - planowa - kontrola funkcjonalna na drugim poziomie, 4 - doraźna - kontrola projektów, 5 - doraźna - kontrola pre-umów, 6 - doraźna - kontrola pomocy technicznej, 7 - doraźna - kontrola funkcjonalna na drugim poziomie, 8 - zlecona przez KE
name | varchar | 200 | √ |  | null |  |  | Nazwa
status | int4 | 10 |  |  |  |  |  | Status: 0 - kontrola niewykonana, 1 - kontrola wykonana
status_change_date | timestamp | 29,6 | √ |  | null |  |  | Data zmiany statusu
priority_axis_id | int4 | 10 | √ |  | null |  |  | Identyfikator osi priorytetowej
operation_id | int4 | 10 | √ |  | null |  |  | Identyfikator działania
sub_operation_id | int4 | 10 | √ |  | null |  |  | Identyfikator poddziałania
project_cost | numeric | 17,4 | √ |  | null |  |  | Całkowity koszt projektu
project_cost_currency | int4 | 10 | √ |  | null |  |  | Jednostka waluty całkowitego kosztu projektu
financing_value | numeric | 17,4 | √ |  | null |  |  | Wysokość dofinansowania z RPO WZ
financing_value_currency | int4 | 10 | √ |  | null |  |  | Jednostka waluty wysokości dofinansowania z RPO WZ
start_date | timestamp | 29,6 |  |  |  |  |  | Data rozpoczęcia
end_date | timestamp | 29,6 |  |  |  |  |  | Data końcowa
protocol_sign_date | timestamp | 29,6 | √ |  | null |  |  | Data podpisania protokołu pokontrolnego
control_team | varchar | 500 | √ |  | null |  |  | Zespół kontrolny
remarks | varchar | 2000 | √ |  | null |  |  | Uwagi
control_proceedings_document_id | int4 | 10 | √ |  | null |  |
ctrl_document.id | fk8c2e338968560cc3
| Identyfikator dokumentu protokołu pokontrolnego
id_proposal | int8 | 19 | √ |  | null |  |
proposal.id | fk8c2e33894d642b0e
| Identyfikator wniosku
control_program_document_id | int4 | 10 | √ |  | null |  |
ctrl_document.id | fk8c2e3389c8b41048
| Identyfikator dokumentu programu kontroli
number | varchar | 3 | √ |  | null |  |  |
next_number | int4 | 10 | √ |  | null |  |  |
ksi_number | varchar | 200 | √ |  | null |  |  |
Analyzed at Wed Nov 26 19:06 CET 2008

Indexes:

Column(s) | Type | Sort | Constraint Name | Anomalies
--- | --- | --- | --- | ---
id | Primary key | Asc | ctrl_control_pkey |
next_number + id_proposal | Must be unique | Asc/Asc | next_number_and_proposal_id_unique | These unique columns are also nullable

Close relationships within one two degrees of separation: