Untitled

mail@pastecode.io avatar
unknown
sql
a year ago
1.4 kB
5
Indexable
Never
satellites=> \d+ satellite_hotelamenity
                                                   Table "public.satellite_hotelamenity"
       Column       |  Type   |                              Modifiers                              | Storage  | Stats target | Description
--------------------+---------+---------------------------------------------------------------------+----------+--------------+-------------
 id                 | integer | not null default nextval('satellite_hotelamenity_id_seq'::regclass) | plain    |              |
 amenity_group_slug | text    | not null                                                            | extended |              |
 amenity_group_name | text    | not null                                                            | extended |              |
 amenity_names      | text[]  | not null                                                            | extended |              |
 hotel_id           | text    | not null                                                            | extended |              |
Indexes:
    "satellite_hotelamenity_pkey" PRIMARY KEY, btree (id)
    "satellite_hotelamenity_hotel_id_3ccf72b3" btree (hotel_id)
    "satellite_hotelamenity_hotel_id_3ccf72b3_like" btree (hotel_id text_pattern_ops)
Foreign-key constraints:
    "satellite_hotelameni_hotel_id_3ccf72b3_fk_satellite" FOREIGN KEY (hotel_id) REFERENCES satellite_hotel(otahotel_id) DEFERRABLE INITIALLY DEFERRED