Untitled

satellites=> \d+ satellite_region
                            Table "public.satellite_region"
  Column   |          Type          | Modifiers | Storage  | Stats target | Description
-----------+------------------------+-----------+----------+--------------+-------------
 id        | bigint                 | not null  | plain    |              |
 slug      | text                   |           | extended |              |
 kind      | character varying(255) |           | extended |              |
 latitude  | double precision       |           | plain    |              |
 longitude | double precision       |           | plain    |              |
 locative  | text                   |           | extended |              |
 genitive  | text                   |           | extended |              |
 parent_id | bigint                 |           | plain    |              |
 name      | text                   |           | extended |              |
Indexes:
    "satellite_region_pkey" PRIMARY KEY, btree (id)
    "satellite_region_parent_id_dd02bfb4" btree (parent_id)
Foreign-key constraints:
    "satellite_region_parent_id_dd02bfb4_fk_satellite_region_id" FOREIGN KEY (parent_id) REFERENCES satellite_region(id) DEFERRABLE INITIALLY DEFERRED
Referenced by:
    TABLE "satellite_hotel" CONSTRAINT "satellite_hotel_region_id_fb8339ca_fk_satellite_region_id" FOREIGN KEY (region_id) REFERENCES satellite_region(id) DEFERRABLE INITIALLY DEFERRED
    TABLE "satellite_region" CONSTRAINT "satellite_region_parent_id_dd02bfb4_fk_satellite_region_id" FOREIGN KEY (parent_id) REFERENCES satellite_region(id) DEFERRABLE INITIALLY DEFERRED
    TABLE "satellite_regionhotel" CONSTRAINT "satellite_regionhotel_region_id_089e4d75_fk_satellite_region_id" FOREIGN KEY (region_id) REFERENCES satellite_region(id) DEFERRABLE INITIALLY DEFERRED