[kotek@paf73 ~]$ psql -d 4a Welcome to psql, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help on internal slash commands \g or terminate with semicolon to execute query \q to quit 4a=# \d wojewodztwa Table "wojewodztwa" Column | Type | Modifiers --------+-----------------------+----------- id | numeric(2,0) | not null nazwa | character varying(20) | Primary key: pk_wojewodztwa Triggers: RI_ConstraintTrigger_1264686, RI_ConstraintTrigger_1264688 4a=# \d kody_pocztowe Table "kody_pocztowe" Column | Type | Modifiers -------------+-----------------------+----------- kod | numeric(5,0) | not null miejscowosc | character varying(32) | not null wojewodztwo | numeric(2,0) | not null gmina | character varying(30) | Primary key: pk_kody_pocztowe Triggers: RI_ConstraintTrigger_1264684, RI_ConstraintTrigger_1264699, RI_ConstraintTrigger_1264701, RI_ConstraintTrigger_1264717, RI_ConstraintTrigger_1264719 4a=# \d wlasciciele Table "wlasciciele" Column | Type | Modifiers ---------------+------------------------+-------------------------------------------------------- id | integer | not null default nextval('"wlasciciele_id_seq"'::text) imie | character varying(40) | not null nazwisko | character varying(40) | not null pesel | numeric(11,0) | kod_literowy | character(5) | ulica | character varying(40) | not null nr_domu | character varying(8) | not null nr_mieszkania | character varying(6) | kod_pocztowy | numeric(5,0) | not null tel | numeric(9,0) | email | character varying(40) | inne | character varying(200) | Primary key: pk_wlasciciele Unique keys: wlasciciele_kod_literowy_key, wlasciciele_pesel_key Triggers: RI_ConstraintTrigger_1264697, RI_ConstraintTrigger_1264729, RI_ConstraintTrigger_1264731 4a=# \d lekarze Table "lekarze" Column | Type | Modifiers --------------+------------------------+---------------------------------------------------- id | integer | not null default nextval('"lekarze_id_seq"'::text) imie | character varying(40) | not null nazwisko | character varying(40) | not null tel | numeric(9,0) | kod_literowy | character(4) | licencja | character varying(12) | not null inne | character varying(200) | Primary key: pk_lekarze Unique keys: lekarze_kod_literowy_key, lekarze_licencja_key Triggers: RI_ConstraintTrigger_1264735, RI_ConstraintTrigger_1264737 4a=# \d osrodki Table "osrodki" Column | Type | Modifiers ---------------+------------------------+---------------------------------------------------- id | integer | not null default nextval('"osrodki_id_seq"'::text) kod_literowy | character(4) | nazwa | character varying(50) | not null ulica | character varying(40) | not null nr_domu | character varying(8) | not null nr_mieszkania | character varying(6) | kod_pocztowy | numeric(5,0) | not null tel | numeric(9,0) | opis | character varying(200) | Primary key: pk_osrodki Triggers: RI_ConstraintTrigger_1264715, RI_ConstraintTrigger_1264741, RI_ConstraintTrigger_1264743, RI_ConstraintTrigger_1264747, RI_ConstraintTrigger_1264749 4a=# \d zwierzaki Table "zwierzaki" Column | Type | Modifiers -------------------+--------------------------+--------------------------------- --------------------- id | integer | not null default nextval('"zwier zaki_id_seq"'::text) imie | character varying(40) | not null chip_id | character varying(20) | not null tatuaz | character varying(20) | paszport | character varying(20) | rodzaj | character varying(30) | rok_urodzenia | numeric(4,0) | plec | boolean | wielkosc | character varying(20) | kolor | character varying(20) | rasa | character varying(20) | zwiazek_hodowcow | boolean | data_szczepienia | timestamp with time zone | not null data_znakowania | timestamp with time zone | not null data_wysylki | timestamp with time zone | not null data_rejestracji | timestamp with time zone | not null sposob_zgloszenia | character varying(20) | ostatni_podatek | timestamp with time zone | zyje | boolean | id_wlasciciela | integer | id_lekarza | integer | id_osrodka | integer | id_kontrahenta | integer | Primary key: pk_zwierzaki Unique keys: zwierzaki_chip_id_key Triggers: RI_ConstraintTrigger_1264727, RI_ConstraintTrigger_1264733, RI_ConstraintTrigger_1264739, RI_ConstraintTrigger_1264745 4a=# \q