Tables Relationships Utility Tables Constraints Anomalies Columns Donate

Table backend_dev.public.deposit Rejestr depozytów | 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 | bigserial | 19 |  | √ | nextval('deposit_id_seq'::regclass) |  |  | Identyfikator depozytu
protection_type | varchar | 60 |  |  |  |  |  | Rodzaj zabezpieczeń
amount | numeric | 15,2 |  |  |  |  |  | Kwota depozytu
adding_date | timestamp | 29,6 |  |  |  |  |  | Data dodania depozytu
returned | bool | 1 |  |  |  |  |  | Czy depozyt jest zwrócony
return_date | timestamp | 29,6 | √ |  | null |  |  | Data zwrotu depozytu
expiration_date | timestamp | 29,6 | √ |  | null |  |  | Data ważności
proposal_id | int8 | 19 |  |  |  |  |
proposal.id | fk5ca7169e673bd700
| Identyfikator wniosku do którego należy depozyt
document_content_id | int4 | 10 | √ |  | null |  |
document_content.id | fk5ca7169ed96dedd7
| Identyfikator dokumentu depozytu
Analyzed at Wed Nov 26 19:06 CET 2008

Indexes:

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

Close relationships within one two degrees of separation: