List of relations
 Schema |              Name              |   Type   | Owner 
--------+--------------------------------+----------+-------
 public | address                        | table    | root
 public | address_address_id_seq         | sequence | root
 public | alembic_version                | table    | root
 public | conveyancer                    | table    | root
 public | conveyancer_conveyancer_id_seq | sequence | root
 public | owner                          | table    | root
 public | title                          | table    | root

                                         Table "public.address"
        Column        |       Type        |                          Modifiers                           
----------------------+-------------------+--------------------------------------------------------------
 address_id           | integer           | not null default nextval('address_address_id_seq'::regclass)
 house_name_or_number | character varying | not null
 street_name          | character varying | not null
 city                 | character varying | not null
 county               | character varying | not null
 country              | character varying | not null
 postcode             | character varying | not null
Indexes:
    "address_pkey" PRIMARY KEY, btree (address_id)
Referenced by:
    TABLE "owner" CONSTRAINT "owner_address_id_fkey" FOREIGN KEY (address_id) REFERENCES address(address_id)
    TABLE "title" CONSTRAINT "title_address_id_fkey" FOREIGN KEY (address_id) REFERENCES address(address_id) ON UPDATE CASCADE ON DELETE CASCADE

                                        Table "public.conveyancer"
     Column     |       Type        |                              Modifiers                               
----------------+-------------------+----------------------------------------------------------------------
 conveyancer_id | integer           | not null default nextval('conveyancer_conveyancer_id_seq'::regclass)
 x500_name      | character varying | not null
 company_name   | character varying | not null
Indexes:
    "conveyancer_pkey" PRIMARY KEY, btree (conveyancer_id)
    "conveyancer_x500_name_key" UNIQUE CONSTRAINT, btree (x500_name)

            Table "public.owner"
   Column   |       Type        | Modifiers 
------------+-------------------+-----------
 identity   | integer           | not null
 forename   | character varying | not null
 surname    | character varying | not null
 email      | character varying | not null
 phone      | character varying | not null
 owner_type | character varying | not null
 address_id | integer           | not null
Indexes:
    "owner_pkey" PRIMARY KEY, btree (identity)
    "ix_owner_email" UNIQUE, btree (email)
Foreign-key constraints:
    "owner_address_id_fkey" FOREIGN KEY (address_id) REFERENCES address(address_id)
Referenced by:
    TABLE "title" CONSTRAINT "title_identity_fkey" FOREIGN KEY (identity) REFERENCES owner(identity)

                        Table "public.title"
    Column    |            Type             |       Modifiers        
--------------+-----------------------------+------------------------
 title_number | character varying           | not null
 created_at   | timestamp without time zone | not null default now()
 updated_at   | timestamp without time zone | 
 lock         | timestamp without time zone | 
 identity     | integer                     | not null
 address_id   | integer                     | not null
Indexes:
    "title_pkey" PRIMARY KEY, btree (title_number)
Foreign-key constraints:
    "title_address_id_fkey" FOREIGN KEY (address_id) REFERENCES address(address_id) ON UPDATE CASCADE ON DELETE CASCADE
    "title_identity_fkey" FOREIGN KEY (identity) REFERENCES owner(identity)