SchemaSpy - Table frontend.public.intervention_category

Kategoria interwencji - sekcja A.4

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

operation_intervention_category.id_intervention_category	operation_intervention_category_intervention_category
project.id_intervention_category	project_intervention_category
suboperation_intervention_category.id_intervention_category	suboperation_intervention_category_intervention_category

Identyfikator

number

varchar

8

√

null

Numer

name

varchar

256

√

null

Nazwa kategorii interwencji

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	intervention_category_pkey
name	Must be unique	Asc	unq_intervention_category_name	This unique column is also nullable
number	Must be unique	Asc	unq_intervention_category_number	This unique column is also nullable