Untitled

mail@pastecode.io avatar
unknown
sql
a year ago
1.4 kB
4
Indexable
satellites=> \d+ satellite_hotelimage
                                                           Table "public.satellite_hotelimage"
       Column       |          Type          |                             Modifiers                             | Storage  | Stats target | Description
--------------------+------------------------+-------------------------------------------------------------------+----------+--------------+-------------
 id                 | integer                | not null default nextval('satellite_hotelimage_id_seq'::regclass) | plain    |              |
 image_template_url | character varying(200) | not null                                                          | extended |              |
 category           | text                   |                                                                   | extended |              |
 hotel_id           | text                   | not null                                                          | extended |              |
Indexes:
    "satellite_hotelimage_pkey" PRIMARY KEY, btree (id)
    "satellite_hotelimage_hotel_id_071b0155" btree (hotel_id)
    "satellite_hotelimage_hotel_id_071b0155_like" btree (hotel_id text_pattern_ops)
Foreign-key constraints:
    "satellite_hotelimage_hotel_id_071b0155_fk_satellite" FOREIGN KEY (hotel_id) REFERENCES satellite_hotel(otahotel_id) DEFERRABLE INITIALLY DEFERRED