bcap=# \d cost                                                                                                
           Table "public.cost"                                                                                
       Column       |  Type   | Modifiers                                                                     
--------------------+---------+-----------                                                                    
 airline            | text    | not null                                                                      
 flightnum          | integer | not null                                                                      
 required_chutes    | text    |                                                                               
 preferred_chutes   | text    |                                                                               
 opening_before_std | integer | not null                                                                      
 closing_before_std | integer | not null                                                                      
 number_of_chutes   | integer | not null                                                                      
Indexes:                                                                                                      
    "pkcost" PRIMARY KEY, btree (airline, flightnum)                                                          
Foreign-key constraints:                                                                                      
    "fk_cost_airline" FOREIGN KEY (airline) REFERENCES airline(id)                                            
    "fk_cost_flight" FOREIGN KEY (flightnum) REFERENCES flight(flightnum)