satellites=> \d+ satellite_hotel
Table "public.satellite_hotel"
Column | Type | Modifiers | Storage | Stats target | Description
----------------------+-----------------------+-----------+----------+--------------+-------------
otahotel_id | text | not null | extended | |
name | text | | extended | |
address | text | | extended | |
latitude | double precision | | plain | |
longitude | double precision | | plain | |
center_distance | double precision | | plain | |
star_rating | smallint | | plain | |
kind | character varying(64) | | extended | |
low_rate | numeric(10,0) | | main | |
ostrovok_rating | numeric(4,2) | | main | |
ostrovok_num_reviews | integer | | plain | |
serp_filters | text[] | not null | extended | |
region_id | bigint | | plain | |
postal_code | text | | extended | |
Indexes:
"satellite_hotel_pkey" PRIMARY KEY, btree (otahotel_id)
"satellite_hotel_otahotel_id_e245954d_like" btree (otahotel_id text_pattern_ops)
"satellite_hotel_region_id_fb8339ca" btree (region_id)
Foreign-key constraints:
"satellite_hotel_region_id_fb8339ca_fk_satellite_region_id" FOREIGN KEY (region_id) REFERENCES satellite_region(id) DEFERRABLE INITIALLY DEFERRED
Referenced by:
TABLE "core_hotelpagesetting" CONSTRAINT "core_hotelpagesettin_otahotel_id_id_9b9c496b_fk_satellite" FOREIGN KEY (otahotel_id_id) REFERENCES satellite_hotel(otahotel_id) DEFERRABLE INITIALLY DEFERRED
TABLE "satellite_hotelamenity" CONSTRAINT "satellite_hotelameni_hotel_id_3ccf72b3_fk_satellite" FOREIGN KEY (hotel_id) REFERENCES satellite_hotel(otahotel_id) DEFERRABLE INITIALLY DEFERRED
TABLE "satellite_hoteldescription" CONSTRAINT "satellite_hoteldescr_hotel_id_0cbf17b1_fk_satellite" FOREIGN KEY (hotel_id) REFERENCES satellite_hotel(otahotel_id) DEFERRABLE INITIALLY DEFERRED
TABLE "satellite_hotelimage" CONSTRAINT "satellite_hotelimage_hotel_id_071b0155_fk_satellite" FOREIGN KEY (hotel_id) REFERENCES satellite_hotel(otahotel_id) DEFERRABLE INITIALLY DEFERRED
TABLE "satellite_hotelroomgroup" CONSTRAINT "satellite_hotelroomg_hotel_id_6ad23013_fk_satellite" FOREIGN KEY (hotel_id) REFERENCES satellite_hotel(otahotel_id) DEFERRABLE INITIALLY DEFERRED