Cacher is the code snippet organizer for pro developers

id,"code","open"
1,"B1","1"
2,"C1","0"
3,"B","1"
4,"A1","2"
5,"A1","1"
6,"B3","1"
7,"C5","1"
8,"D1","1"
9,"E7","1"
10,"F7","1"
11,"G5","1"
12,"H2","1"
13,"I6","1"
14,"J5","1"
15,"K1","1"
16,"A3","1"
17,"B5","1"
18,"C1","1"
19,"D7","1"
20,"E7","1"
21,"F5","1"
22,"G2","1"
23,"H6","1"
24,"A5","1"
25,"B1","1"
26,"C3","1"
27,"D5","1"
28,"E1","1"
29,"F7","1"
30,"G7","1"
31,"H5","1"
32,"I2","1"
33,"J6","1"
34,"K5","1"

id,number,"state"
2,1,"10"

id,"plane","code"
1,"Boeing 747-400","8430"
2,"Boeing 737-800","3383"
3,"Airbus A340-300","7120"
4,"British Aerospace Jetstream 41","1502"
5,"Embraer ERJ-145","1530"
6,"SAAB 340","2128"
7,"Piper Archer III","520"
8,"Tupolev 154","4103"
9,"Lockheed L1011","6900"
10,"Boeing 757-300","4010"
11,"Boeing 777-300","6441"
12,"Boeing 767-400ER","6475"
13,"Airbus A320","2605"
14,"Airbus A319","1805"
15,"Boeing 727","1504"
16,"Schwitzer 2-33","30"

id,"name","plane_number","asset"
1,"Lufthansa","10","1000"
2,"KLM","100","10"
3,"Air Canada","100139","199"
4,"Air France","10","10"
5,"Air India","100","100"

id,"name","city","capacity","size"
1,"Schiphol","Amsterdam","1000","Large"
2,"Venezia Marco Polo","Venezia","2000","Medium"
3,"London City Airport","London","2500","Medium"
4,"Rome Leonardo da Vinci","Rome","20000","Large"
5,"Dubai International Airport","Dubai","100","Small"
6,"Colombo's Bandaranaike International","Sri Lanka","800000","Large"