Untitled

mail@pastecode.io avatar
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