Untitled
unknown
sql
a year ago
2.9 kB
6
Indexable
Never
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