Untitled
unknown
sql
a year ago
2.0 kB
5
Indexable
satellites=> \d+ satellite_hotelroomgroup
Table "public.satellite_hotelroomgroup"
Column | Type | Modifiers | Storage | Stats target | Description
---------------------+--------------------------+-----------------------------------------------------------------------+----------+--------------+-------------
id | integer | not null default nextval('satellite_hotelroomgroup_id_seq'::regclass) | plain | |
room_group_id | integer | not null | plain | |
name | text | not null | extended | |
size_meters | integer | | plain | |
image_url_templates | character varying(200)[] | not null | extended | |
amenities | text[] | not null | extended | |
hotel_id | text | not null | extended | |
description | text | | extended | |
Indexes:
"satellite_hotelroomgroup_pkey" PRIMARY KEY, btree (id)
"satellite_hotelroomgroup_hotel_id_6ad23013" btree (hotel_id)
"satellite_hotelroomgroup_hotel_id_6ad23013_like" btree (hotel_id text_pattern_ops)
Foreign-key constraints:
"satellite_hotelroomg_hotel_id_6ad23013_fk_satellite" FOREIGN KEY (hotel_id) REFERENCES satellite_hotel(otahotel_id) DEFERRABLE INITIALLY DEFERRED