Tables Relationships Utility Tables Constraints Anomalies Columns Donate

Table backend_dev.public.rep_report Sprawozdawczość - sprawozdanie | 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('rep_report_id_seq'::regclass) |  |  | id sprawozdania
since_period | timestamp | 29,6 |  |  |  |  |  | Okres sprawozdawczy od;Data początkowa okresu sprawozdawczego; format daty to DD/MM/RRRR
until_period | timestamp | 29,6 |  |  |  |  |  | Okres sprawozdawczy do;Data końcowa okresu sprawozdawczego; format daty to DD/MM/RRRR
number | varchar | 255 |  |  |  |  |  | Numer sprawozdania
report_type | int4 | 10 |  |  |  |  |  | typ sprawozdania - miesięczne (0), okresowe (1), roczne(2), końcowe(3)
document_content_id | int4 | 10 |  |  |  |  |
document_content.id | fk23f41f16d96dedd7
| id pliku
Analyzed at Wed Nov 26 19:06 CET 2008

Indexes:

Column(s) | Type | Sort | Constraint Name
--- | --- | --- | ---
id | Primary key | Asc | rep_report_pkey
document_content_id | Must be unique | Asc | rep_report_document_content_id_key

Close relationships within one two degrees of separation: