SchemaSpy - Table frontend.public.type_of_applicant

Typ wnioskodawcy - sekcja B.2

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

serial

10

√

nextval('type_of_applicant_id_seq'::regclass)

applicant.id_type_of_applicant	applicant_type_of_applicant
operation_type_of_applicant.id_type_of_applicant	operation_type_of_applicant_type_of_applicant
suboperation_type_of_applicant.id_type_of_applicant	suboperation_type_of_applicant_type_of_applicant

Identyfikator

name

varchar

384

√

null

Nazwa wnioskodawcy

active

bool

1

√

true

Aktywny - nieaktywny

Analyzed at Wed Nov 26 19:04 CET 2008

Indexes:

Column(s)	Type	Sort	Constraint Name	Anomalies
id	Primary key	Asc	type_of_applicant_pkey
name	Must be unique	Asc	unq_type_of_applicant_name	This unique column is also nullable