peter_trialdb=> \d account
                                      Table "public.account"
   Column   |         Type          |                          Modifiers 
------------+-----------------------+--------------------------------------------------------------
 account_id | integer               | not null default nextval('account_account_id_seq'::regclass)
 username   | character varying(15) | not null
 passwd     | character varying(15) | not null
 person_id  | integer               | not null
 active     | boolean               | not null default true
 locked     | boolean               | not null default false
Indexes:
    "account_pkey" PRIMARY KEY, btree (account_id)
Foreign-key constraints:
    "account_person_id_fkey" FOREIGN KEY (person_id) REFERENCES person(person_id) ON DELETE CASCADE