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