Untitled

mail@pastecode.io avatar
unknown
sql
a year ago
2.0 kB
4
Indexable
Never
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