SchemaSpy - Table backend_dev.public.proposals_folder

Teczka projektu

Generated by
SchemaSpy

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('proposals_folder_id_seq'::regclass)

applicant_person_agreement.proposals_folder_id	fk5579693d6c37c9d7
contract.proposals_folder_id	fkde3511126c37c9d7
folders_attachment.proposals_folder_id	fk2282dfdd6c37c9d7
folders_note.proposals_folder_id	fkedb14a2c6c37c9d7
ksi_import_history.id_proposals_folder	fk1cb235f8eec96b99
official_message.proposals_folder_id	fk5b7526b36c37c9d7
pay_payment_form_official.proposals_folder_id	fk4d3961366c37c9d7
proposal.proposals_folder_id	fkc4d26af26c37c9d7

Identyfikator

name

varchar

255

√

null

Nazwa

contract_id

int4

10

√

null

contract.id

fk516d9aac249c812d

Identyfikator umowy

proposal_id

int8

19

proposal.id

fk516d9aac673bd700

Identyfikator wniosku (proposal)

Analyzed at Wed Nov 26 19:06 CET 2008

Indexes:

Column(s)	Type	Sort	Constraint Name
id	Primary key	Asc	proposals_folder_pkey
proposal_id	Must be unique	Asc	proposals_folder_proposal_id_key