SchemaSpy - Table frontend.public.type_of_project

Typ projektu - sekcja A.5

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

operation_type_of_project.id_type_of_project	operation_type_of_project_type_of_project
project.id_type	project_type_of_project
suboperation_type_of_project.id_type_of_project	suboperation_type_of_project_type_of_project

Identyfikator

name

varchar

384

√

null

Nazwa projektu

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_project_pkey
name	Must be unique	Asc	unq_type_of_project_name	This unique column is also nullable