SchemaSpy - Table frontend.public.commune

Gmina

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

address.id_commune	address_commune
project_location.id_commune	commune_id_fk

Identyfikator

code

varchar

13

√

null

Kod

name

varchar

64

√

null

Nazwa

active

bool

1

√

true

Aktywny - nieaktywny

id_district

int4

10

√

null

district.id

commune_district

Identyfikator powiata

Analyzed at Wed Nov 26 19:04 CET 2008

Indexes:

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