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