Sirena Travel 2012-2023
The database consists of several tables.
Тестовые таблицы - Скачать Zip
To purchase, write to Telegram
@Flexx7779
The database consists of several tables.
Quote:PBOARDED_ХХХХХХХХ.txt
Size 43,7 Гб
Lines 159 942 274
"LEO_CENTER","AIRLINE","FLIGHT","SUFFIX","BOOKING_TIME","DEPARTURE_TIME","DEPARTURE_POINT","ARRIVAL_POINT","PREDPOINT","INV_RECLOC","GDS_RECLOC","AGENCY","CLASS","TICKET","PAX_TYPE","GENDER","BIRTHDATE","NAME","CITIZENSHIP","DOC_TYPE"," DOC_NUM","EMAIL","TELEPHONE","IS_EMD","PULT","CLIENT_ID","IS_CHARTER","RCODEA","LCODEA","DEPARTURE_POINT_RUS","DEPARTURE_POINT_LAT","ARRIVAL_POINT_RUS","ARRIVAL_POINT_LAT","PAX_TYPE_RUS","PAX_TYPE_LAT","CITIZENSHIP_RUS","CITIZENSHIP_LAT"
LEON2,PI,233,,2020-04-30 05:16:16.000,2020-05-06 15:00:00.000,YKS,VYI,MOW1H,DFD0B8,"71D1GC","08ЯКТ",Y,"5452410510997 С1",ААА,М,1988-03-14 00:00:00.000,ФЕДОР БАТАРИН,RU,PS,"9807086611",,"79243671037",,,,,ЯП,ПИ,ЯКТ,ЮКС,ВИК,ВЫИ,ААА,ААА,РФ,RU
LEON2,PI,233,,2020-04-30 05:16:16.000,2020-05-06 15:00:00.000,YKS,VYI,MOW1H,DFD0B8,"71D1GC","08ЯКТ",Y,"5452410510998 C1", ААА, М, 14 января 1988 г. 00:00:00.000,АЛЕКСЕЙ МАРКОВ,RU,PS,"9807085919",,,,,,,,,,,,ЯП,ПИ,ЯКТ,ЮКС,ВИК,ВЫЙ,ААА,ААА,РФ,RU
LEON2,PI,233,,2020-04-30 05:16:16.000,2020-05-06 15:00:00.000,YKS,VYI,MOW1H,DFD0B8,"71D1GC","08ЯКТ",Y,"5452410510999 C1",AAA,F,1979-12-17 00:00:00.000,НАДЕЖДА МАЛИНОВСКАЯ,RU,PS,"9814537405",,,,,,,,,ЯП,ПИ,ЯКТ,ЮКС,ВИК,ВЫЙ,ААА,ААА,РФ,RU
TICKET_CEB_SU_STAT_ХХХХХХХХ.txt
Size 14,2 Гб
Lines 43 454 670
"TKT_DATE","PNR_LOCAL","AGN","AGENCY_NAME","PPR","GDS1","PPR_CITY","PUL","PPR_GOS","AIRLINE","PNR_AIRLINE","GDS","PNR_GDS","VAL_AIRLINE","NUM","COUPON_NUM","MARKET_AIRLINE","OPER_AIRLINE","FLIGHT","FLIGHT_OPER","CLASS","BASE_CLASS","DEP_DATE","DEP_PORT","DEP" ,"ARR_PORT","ARR","FARE_BASIS","RPI_STATUS","ENDORSMENT","MONET_SUM","MONET_CURENCY","FOPS","ISSUE","REFUND","EXCH","ISSUE_EXCH","TAXES","IS_ZZ","ACCODE","ERSP","BLN_OWNER","SEANCE","PASS_CAT","INET","CLIENT_ID","URL","APP_TYPE","BRAND","INTERLINE","IS_MIXVEL"
29.10.2022 00:00:00.000,"00FV1J",ДСУ,АЭРОФЛОТ,"92499853",СУ,ДСУ,,РФ,СУ,"00L12G","1H",Л1ВЛЦР,СУ,"5552107103374",2,СУ,СУ,6950,,Q,Y,2022-11-04 20:40:00.000,ЗВР,ЕВН,СКЧ,СМШ,QNB,OK,P3620916998 NONREF/HEBO3BPATEH,200,ЕВР,КК,1,0,0,0,YQF3600|RI202|YRF468|KC1620|RI2202|AM1500,0,"555",,,,,,,,,,0,
2022-10-29 00:00:00.000,"00FV71",MOW,АЭРОФЛОТ,"92494732",СУ,JQI,,РФ,СУ,"00M1D7","1H",Л1ВНЛ6,СУ,"5552407712365",2,СУ,СУ,1141,,E,Y,2022-11-04 21:20:00.000,СОЧ,СОЧ,ШРМ,МОВ,ECLR/DP15,OK,PIVEK665401 CNLD15,7650,РУБ,КК,1,0,0,0,YQF4400|YRF540|RI3162|RI4162,0,"555",,,,,,,,,,0,
2022-10-29 00:00:00.000,"00FV9B",ДСУ,АЭРОФЛОТ,"92499853",СУ,ДСУ,,РФ,СУ,"00M092","1H",Л1ВХЦД,СУ,"5552108220961",1,СУ,СУ,6488,,G,Y,29.10.2022 02:50:00.000,МУН,МУН,ШРМ,МОВ,GNOR,OK,P4721743485 NONREF/HEBO3BPATEH,6300,РУБ,КК,1,0,0,0,RI4264|RI3317,0,"555",,,,,,,,,,0,
2022-10-29 00:00:00.000,"00ФВО3",ДСУ,АЭРОФЛОТ,"92499853",СУ,ДСУ,,РФ,СУ,"00L37L","1H",Л1ВП49,СУ,"5552106957249",1,СУ,СУ,6,,V,Y,29.10.2022 06:55:00.000,ШРМ,МОВ,ПЛК,СПТ,ВНОРИСЛ,ОК,P4519654939 NONREF/HEBO3BPATEH,2100,РУБ,КК,1,0,0,0,,0,"555",,,,,,,,,,,,,,,0,
2022-10-29 00:00:00.000,"00FVK0",DSU,AEROFLOT,"55213572",СУ,JQL,,РФ,СУ,"00LG46","1H",Л1ВСБ4,СУ,"5552108233709",4,СУ,СУ,1712,,N,Y,2022-11-09 21:45:00.000,ШРМ,МОВ,ХБР,ХБР,NVUR,OK,P760100442 NONREF/HEBO3BPATEH,26100,РУБ,НА,1,0,0,0,RI4790|RI3790,0,"555",,,,,,,,,,0,
RAIL_TICKET_INFO_ХХХХХХХ.txt
Size 2,9 Гб
Lines строка 9 656 406
"АГЕНТСТВО","AWK_BLN_ВЛАДЕЛЕЦ","ИДЕНТИФИКАТОР НДС_ПЕРЕВОЗЧИКА","CBA","КОД","СУММА КОМИССИИ","ВАЛЮТА","ДАТА_СДЕЛКИ","DEAL_UTC","НОМЕР_EMD","КУРСИВ_ТАРИФА","ТАРИФА","ТИП_ТАРИФА","IDA","СУММА_СТРАХОВКИ","ПОСЛЕДНЯЯ_AGN" ,"ПОСЛЕДНЯЯ_ДАТА","НОМЕР_ПОСЛЕДНЕГО_OPR","ПОСЛЕДНИЙ_OPR","ПОСЛЕДНИЙ_PPR","ПОСЛЕДНИЙ_ПУЛ","ПОСЛЕДНИЙ_ПУЛ","ПОСЛЕДНИЙ_UTC","НОМЕР","НОМЕР_ОПР","OPR","" НОМЕР ЗАКАЗА","ППР","ПУЛ","НОМЕР РЕГНИТА","СУММА_УСЛУГИ","ДАТА_ТАКТА","ИТОГО","СУММА_НДС","СУММА_НДС_СЛУЖБЫ_СЛУЖБЫ_СБОРА_НДС","СТАВКА_НДС_СЛУЖБЫ_СБОРА_НДС","СТАВКА_НДС_ПРОЦЕНТА","КАНАЛ","ПЕРЕВОЗЧИК"
"03ИКТ",ТКП,,ГРС,ЖДПБ,0,РУБ,2013-10-31 10:28:10.000,2013-10-31 01:28:10.000,"97A6185526282",РУБ,364130,ПОЛНЫЙ,260594624,0,,,0,,,,,"77634912 462284",9,ТКП03ИКТ0009,"77634912462284","00606023",ГРФЦ03,М2М390,0,2013-10-31 05:28:10.000,364130,55545,,,,,,,,,,
"03ИКТ",ТКП,,ГРС,ЖДПБ,0,РУБ,2013-10-31 13:39:54.000,2013-10-31 04:39:54.000,"97A6185527289",РУБ,171100,ПОЛНЫЙ,260602922,0,,,0,,,,,"777849124 75455",20,ТКП03ИКТ0020,"77784912475455","92303013",ГРФЦ21,М2МММ8,0,2013-10-31 08:39:54.000,171100,26100,,,,,,,,,,
"06УФА",ТКП,,ГРС,ЖДПБ,0,РУБ,2013-10-31 10:52:21.000,2013-10-31 04:52:21.000,"97A6185527387",РУБ,148410,ПОЛНЫЙ,260603941,0,,,0,,,,,"780349124 77032",14,ТКП06УФА0014,"78034912477032","92387584",УФГ803,М2МНХ4,0,2013-10-31 08:52:21.000,148410,22638,,,,,,,,,,
RAIL_TICK_SEGS_ХХХХХХХХ.txt
Size 1,6 Гб
Lines 9 656 406
"ARR_DATE","CBA","CLASS","COACH_NUM","COACH_TYPE","DEP_DATE","IDA","PORT_FROM","PORT_TO","REGNUM","TICKET","TKT_DATE","ПОЕЗД"
04.11.2013 21:51:00.000,ГРС,"2Л","6",К,2013-11-03 17:34:00.000,40,ВОРКУТА,КОНОША 1,М278ЖХ,260419963,2013-10-29 10:51:32.000,"041МА"
2013-11-04 21:51:00.000,ГРС,"2Л","6",К,2013-11-03 17:34:00.000,41,ВОРКУТА,КОНОША 1,М279КФ,260420472,29.10.2013 10:54:04.000,"041МА"
2013-11-04 21:51:00.000,ГРС,"2Л","6",К,2013-11-03 17:34:00.000,42,ВОРКУТА,КОНОША 1,М279ЦР,260420702,2013-10-29 10:55:37.000,"041МА"
2013-11-19 08:30:00.000,ГРС,"1Б","3",Л,2013-11-18 23:30:00.000,43,С-ПЕТЕР-ГЛ,МОСКВА ОКТ,М279Т0,260420763,2013-10-29 10:56:02.000,"003АА"
RAIL_TICK_PASS_ХХХХХХХХ.txt
Size 1,6 Гб
Lines 9 661 012
"CBA","IDA","NAME","PASS_DOC","PASS_LG_DOC","PASS_NAME","REGNUM","SEAT_TIER","SEAT","SURNAME","TICKET","TKT_DATE","CITIZENSHIP","GENDER","PHONE","BIRTH_DATE"
ГРС,1,ВЛАДИМИР,ПС4506244093,,ИОСАВА ВЛАДИМИР,М24ФФМ,НИЖНИЙ,"029",ИОСАВА,260378218,2013-10-28 17:37:44.000,,,,
ГРС,2,АНДРЕЙ,ПС4005151633,,РЕЗНИКОВ АНДРЕЙ,М24ХЦВ,,"019",РЕЗНИКОВ,260379123,2013-10-28 17:46:55.000,,,,
ГРС,3,АНДРЕЙ,ПС4005151633,,РЕЗНИКОВ АНДРЕЙ,М24ЦСТ,,"011",РЕЗНИКОВ,260379830,2013-10-28 17:54:47.000,,,,
ГРС,4,ГУСЕЙИН,ZAU03218024,,КАПСИ ХУСЕЙИН,M24W8T,НИЖНИЙ,"015",КАПСИ,260381297,2013-10-28 18:10:33.000,,,,
TICKET_INFO_ХХХХХХХ.txt
Size 511,0 Гб
Lines 540kk
"АГЕНТСТВО","АЭРОПОРТ","НАЗВАНИЕ_АЭРОПОРТА","АВТОПЕЧАТЬ","АВТОРИФ","ВЛАДЕЛЕЦ_AWK_BLN","БРОНИРОВАНИЕ_АГЕНТСТВА","ДАТА_БРОНИ" РОВАНИЯ","НОМЕР_БРОНИРОВАНИЕ","НОМЕР_БРОНИРОВАНИЕ","БРОНКИРОВАНИЕ_PPR","БРОНКИРОВАНИЕ_PUL","БРОНКИРОВАНИЕ_UTC","CBA","CF_COM _ACURR","CF_COM_ASUM","CF_COM_CURR","CF_COM_PROC","CF_COM_SUM","ГОРОД_ОТ","ГОРОД_ДО","НОМЕР_КЛИЕНТА","КОД","КОД_CUR","СОЕДИН ЕНИЕ","ДАТА_СДЕЛКИ","DEAL_UTC","ДАТА_РОЖДЕНИЯ","ЭКВИВ_ТАРИФ","ERSP","E_TICK","ТИП_ТАРИФА","ПЕРВАЯ_АЭРОПОРТНАЯ_ЛИНИЯ","ПЕРВАЯ _CITY","FIRST_PPR","FIRST_TICK","FIRST_TKT_DATE","FIRST_TKT_NUM","GRREG_NUM","IDA","INET","IT_CUR", "IT_FLAG", "IT_PAY", "IT_RV_CUR", "IT_RV_SUM", "IT_SUM", "KVIT", "LANG", «LAST_AGN», «LAST_AIRLINE», «LAST_DA» TE","LAST_OPR","LAST_OPR_ID","LAST_PPR","LAST_PUL","LAST_TICK","LAST_TKT_DAY","LAST_TKT_TIME","LAST_UTC","LINE","M2_CODE","NAME","NUM_SEG_BLN","N_SEATS","OPR","OPR_NUM","PASS_CATEG","PASS_DOC","PASS_FARE_BOX35", "PASS_FARE_CUR35", "PASS_FARE_SUM35", "PASS_ID", "PASS_LG_DOC", "PASS_NAME", "PNR_SWITCHES", "PPR", "PREV_REGNUM", "PRKEYS", "PTA", "PTA_SPONSOR", "PUL", "REGNUM", "SCONT_GRREG", "STAT_TYPE", "СУБКОД", "ФАМИЛИЯ", "ТАРИФ", "ТАРИФ_CUR","КОД_НАЛОГА1","СУММА_НАЛОГА1","ТИП_НАЛОГА1","КОД_НАЛОГА2","СУММА_НАЛОГА2","ТИП_НАЛОГА2","К ОД_НАЛОГА3","СУММА_НАЛОГА3","ТИП_НАЛОГА3","ИХ_РЕГНИТНЫЙ_НОМЕР","ДАТА_ТКТ","TLINE","ИТОГО","ДЕЙСТВИТЕЛЬНЫЙ","ТАРИФ_НДС","V AT_TAX","VAT_ZZ","VLD","VZ_TICK","WYN","ZAKAZ_NUM","ZAPRET","ZR_FLAG","EQ_FARE_CUR1","EQ_FARE_CUR2" ,"EQ_FARE_CUR3","FARE_CALC","RFIC","RFISC","EMD_REMARK","RFID","RATES","BSO_NUM","LAST_BSO_NUM","CLI ENT_ID","APP_TYPE","URL","BASE","AGENT_FREE_CODE","M2_TRAVEL_ID","CF_METHOD","CF_SELLING_OR_NET_SUM","PRKEYS2","PRKEYS3","TKTS","DID","PART_OPERATION","ZZ_CHILD","CHARTER","IS_MIXVEL","LAST_COUPONS","LG_FDR_IDT"
"02СХТ","262",УРАЛЬСКИЕ АЛ,1,0,ТКП,,,,,,,,ГРС,,,,,,,,,,,СХТ,СХТ,,ПБ,РУБ,,,,,,,,,,,,,,,,,,,,,,,,30389191,,,,,,,, ,1,,,,,,,,,,,,1,,,,,ТКП02СХТ0013,,ААА,ПС7600230058,,,,13,,САВОСЬКИНА/ЕЛЕНА Г-ЖА,,"00610411",,,0,,СХТ513,"433ЛЖМ",,,0,,,,,-1,,XT,16000,,,69000,,,29-01-2007 06:44:27.000,1,,,,,,"02СХТ ТКП АВИАЭКСПРЕСС ЧИТА РФ 00610411 0013",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,16000,,,69000,,,29-01-2007 06:44:27.000,1,,,,,,"02СХТ ТКП АВИАЭКСПРЕСС ЧИТА РФ 00610411 0013",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,16000,,,69000,,,29-01-2007 06:44:27.000,1,,,,,,,"02СХТ ТКП АВИАЭКСПРЕСС ЧИТА РФ 00610411 0013",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"08ХБР","499",АСР КРАСЭЙР,0,0,ТКП,,,,,,,,ГРС,,,,КСЛ,СПТ,,ПБ,РУБ,,,,,,,,,,,,,,,,,,,,,,,30389198,,,,,, ,,,1,,,,,,,,,,,,1,,,,,ТКП08ХБР0114,,МЛА,ПС0804475189,,,,13,,ДЕНИСОВА/ЕКАТЕРИНА АЛЕКСЕЕВНА Г-ЖА,,"00703964",,,0,,ХБРБ87,"433НП7",,,0,,,,,-1,,И,16000,,,76000,,,29.01.2007 06:44:29.000,1,,,,,,"08ХБР ТКП ЗАО""САС"" КОМСОМОЛЬСК НА А РФ00703964 0114",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"02СУР", "298",ОАО АВИАКОМПАНИЯ ЮТЭЙР,1,0,ТКП,,,,,,,,ГРС,,,,,,МОВ,КЛД,,ПБ,РУБ,,,,,,,,,,,,,,,,,,,,,30389203,,,, ,,,,,1,,,,,,,,,,,,1,,,,,ТКП02СУР0038,,ААА,ПС6704069255,,,,12,,ЛУИЗИ/ОЛЬГА Г-ЖА,,"00500916",,,0,,СУР201,"433НС2",,,0,,,,,-1,,XT,8000,,,69000,,,29.01.2007 06:44:34.000,1,,,,,,"02СУР ТКП СГМУП ""АВС"" СУРГУТ РФ 00500916 0038",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"02СУР", "298",ОАО АВИАКОМПАНИЯ ЮТЭЙР,1,0,ТКП,,,,,,,,ГРС,,,,,,МОВ,КЛД,,ПБ,РУБ,,,,,,,,,,,,,,,,,,,,ЮТ0006000000002493,303 89207,,,,,,,,,1,,,,,,,,,,,,,,,,1,,,,,ТКП02СУР0038,,ААА,ПС6704071880,,,,14,,БОСЕНКО/НИНА Г-ЖА,,"00500916",,,0,,СУР201,"433НС2",,,0,,,,,-1,,XT,8000,,,69000,,,29.01.2007 06:44:51.000,1,,,,,,"02СУР ТКП СГМУП ""АВС"" СУРГУТ РФ 00500916 0038",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
TICK_PHONES_ХХХХХХ.txt
Size 281,3 Гб
Lines 3 413 726 207
"CBA","LINE","PHONE_TEXT","REGNUM","TICK_INFO_IDA","TKT_DATE","TLINE"
ГРС,1,НЕТ,"44ТСГД",32998521,2007-02-24 09:56:59.000,1
ГРС,1,"3462 343772","44ТСВР",32998525,2007-02-24 09:57:02.000,1
ГРС,1, 622538,"44ТСГС",32998532,2007-02-24 09:57:06.000,1
ГРС,1,"9179388788","44ТСГР",32998538,24.02.2007 09:57:07.000,1
ГРС,1,"89145387607","43ТШВХ",32998541,2007-02-24 09:57:09.000,1
Тестовые таблицы - Скачать Zip
To purchase, write to Telegram
@Flexx7779
