API tools faq
paste
9r3nXPaRTa

#Vuln #SQLi | https://www.aeroline.com.my By GrenXPaRTa

9r3nXPaRTa
Jun 5th, 2017
282
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 32.34 KB | None | 0 0
raw download clone embed print report
  1. .:: GrenXPaRTa Was Here ::.
  2.  
  3. MySQL Version :: 5.1.73-log~ Source distribution
  4. Primary Database :: aeroline
  5. Database User :: aeroline@localhost
  6.  
  7. 01. AddPoint :: Database :: (aeroline)
  8. 001. AP_ticket
  9. 002. AP_traveldate
  10. 003. AP_vip
  11. 004. AP_seat
  12. 005. AP_user
  13. 006. AP_trip
  14. 007. AP_time
  15. 008. AP_redemption
  16. 009. AP_point
  17. 010. AP_receipt
  18. 011. AP_keyin
  19. 012. AP_cancel
  20.  
  21. 02. BookHotel :: Database :: (aeroline)
  22. 013. bh_id
  23. 014. bh_refno
  24. 015. bh_cin
  25. 016. bh_cout
  26. 017. bh_hotel
  27. 018. bh_room
  28. 019. bh_noroom
  29. 020. bh_fare
  30. 021. bh_name2
  31. 022. bh_name1
  32. 023. bh_contact
  33. 024. bh_addr1
  34. 025. bh_addr2
  35. 026. bh_addr3
  36. 027. bh_addr4
  37. 028. bh_type
  38. 029. bh_status
  39. 030. bh_receipt
  40. 031. bh_date
  41. 032. bh_user
  42. 033. bh_pay
  43. 034. bh_changeto
  44. 035. bh_changefrom
  45. 036. bh_deposit
  46. 037. bh_counter
  47. 038. bh_chgdate
  48. 039. bh_paytype
  49. 040. bh_request
  50. 041. bh_print
  51. 042. bh_deduct
  52. 043. bh_smoke
  53. 044. bh_bed
  54. 045. bh_canceldate
  55. 046. bh_cancelby
  56. 047. bh_member
  57. 048. bh_addbed
  58. 049. bh_adminchg
  59. 050. bh_email
  60. 051. bh_created
  61. 052. bh_tax
  62. 053. bh_passport
  63. 054. bh_creditcard
  64. 055. bh_roomratedetail
  65.  
  66. 03. CallBook :: Database :: (aeroline)
  67. 056. cb_refno
  68. 057. cb_name
  69. 058. cb_contact
  70. 059. cb_adult
  71. 060. cb_child
  72. 061. cb_travel
  73. 062. cb_departtrip
  74. 063. cb_returntrip
  75. 064. cb_departdate
  76. 065. cb_returndate
  77. 066. cb_time
  78. 067. cb_return
  79. 068. cb_verify
  80. 069. cb_keyin
  81. 070. cb_user
  82. 071. cb_radult
  83. 072. cb_rchild
  84. 073. cb_status
  85. 074. cb_email
  86. 075. cb_loyalty
  87. 076. cb_creditcard
  88. 077. cb_expiry
  89. 078. cb_creditno
  90. 079. cb_pin
  91. 080. cb_paymenttype
  92. 081. cb_amtcharge
  93. 082. cb_change
  94. 083. cb_chgtkt
  95. 084. cb_bustype
  96. 085. cb_vegetarine
  97. 086. cb_departbus
  98. 087. cb_returnbus
  99. 088. cb_printform
  100. 089. cb_vprintform
  101. 090. cb_appcode
  102. 091. cb_remark
  103. 092. cb_author
  104. 093. cb_hhauthor
  105. 094. cb_mmauthor
  106. 095. cb_amauthor
  107. 096. cb_lastdigit
  108. 097. cb_bankcard
  109. 098. cb_rbustype
  110. 099. cb_counter
  111. 100. cb_expirybook
  112. 101. cb_hotelpackage
  113. 102. cb_returnpoint
  114. 103. cb_departpoint
  115. 104. cb_member
  116. 105. cb_hotelreserv
  117. 106. cb_discountcode
  118. 107. cb_dispromotion
  119. 108. cb_noadminchg
  120. 109. cb_chgdepart
  121. 110. cb_chgreturn
  122. 111. cb_dveget
  123. 112. cb_rveget
  124. 113. cb_chgseat
  125. 114. cb_depart_sdfood
  126. 115. cb_chgmeal
  127. 116. cb_comm
  128. 117. cb_etpin1
  129. 118. cb_etpin2
  130. 119. cb_eticket
  131. 120. cb_pickup
  132. 121. cb_salestype
  133. 122. cb_dropoff
  134.  
  135. 04. CancelOrder :: Database :: (aeroline)
  136. 123. co_refno
  137. 124. co_date
  138. 125. co_by
  139. 126. co_remark
  140. 127. co_user
  141. 128. co_type
  142. 129. co_time
  143.  
  144. 05. CancelTicket :: Database :: (aeroline)
  145. 130. can_changetkt
  146. 131. can_canceltkt
  147. 132. can_keyin
  148. 133. can_traveldate
  149. 134. can_vip
  150. 135. can_seat
  151. 136. can_user
  152. 137. can_trip
  153. 138. can_time
  154.  
  155. 06. ChangeBus :: Database :: (aeroline)
  156. 139. ch_id
  157. 140. ch_date
  158. 141. ch_trip
  159. 142. ch_pbus
  160. 143. ch_bus
  161. 144. ch_seat
  162. 145. ch_remark
  163. 146. ch_user
  164. 147. ch_created
  165.  
  166. 07. ChangeBus_list :: Database :: (aeroline)
  167. 148. chl_id
  168. 149. chl_refno
  169. 150. chl_date
  170. 151. chl_trip
  171. 152. chl_bus
  172. 153. chl_pseat
  173. 154. chl_cseat
  174.  
  175. 08. ChangeTicket :: Database :: (aeroline)
  176. 155. ct_id
  177. 156. ct_refno
  178. 157. ct_ticket
  179. 158. ct_keyin
  180. 159. ct_user
  181.  
  182. 09. Default_Seat :: Database :: (aeroline)
  183. 160. def_id
  184. 161. def_from
  185. 162. def_to
  186. 163. def_seat
  187. 164. def_user
  188.  
  189. 10. HotelPackage_list :: Database :: (aeroline)
  190. 165. hpl_refno
  191. 166. hpl_packno
  192. 167. hpl_ptype
  193. 168. hpl_fnight
  194. 169. hpl_addnight
  195. 170. hpl_addpax
  196. 171. hpl_surroom
  197. 172. hpl_surbus
  198. 173. hpl_bfare
  199. 174. hpl_comm
  200. 175. hpl_total
  201.  
  202. 11. LogFile :: Database :: (aeroline)
  203. 176. lf_id
  204. 177. lf_desc
  205. 178. lf_created
  206.  
  207. 12. PRE_CardDetail :: Database :: (aeroline)
  208. 179. pre_cdID
  209. 180. pre_cdName
  210. 181. pre_cdIC
  211. 182. pre_cdPassport
  212. 183. pre_cdGender
  213. 184. pre_cdEmail
  214. 185. pre_cdOffice
  215. 186. pre_cdHome
  216. 187. pre_cdMobile
  217. 188. pre_cdAddr
  218. 189. pre_cdOccup
  219. 190. pre_cdDob
  220. 191. pre_cdNasionality
  221. 192. pre_cdNo
  222. 193. pre_cdType
  223. 194. pre_cdLevel
  224. 195. pre_cdMaster
  225. 196. pre_cdFees
  226. 197. pre_cdPay
  227. 198. pre_cdCharges
  228. 199. pre_cdStatus
  229. 200. pre_cdUser
  230. 201. pre_cdCreated
  231. 202. pre_cdBy
  232. 203. pre_cdPwd
  233. 204. pre_cdVDate
  234. 205. pre_cdVRemark
  235. 206. pre_cdVUser
  236. 207. pre_cdVRef
  237. 208. pre_cdBDate
  238. 209. pre_cdBRemark
  239. 210. pre_cdBRefund
  240. 211. pre_cdBUser
  241. 212. pre_cdRef
  242. 213. pre_cdCreditcard
  243. 214. pre_cdOther
  244. 215. pre_cdIssue
  245. 216. pre_cdAck
  246. 217. pre_cdCreditCardName
  247. 218. pre_cdBFees
  248. 219. pre_cdBPay
  249. 220. pre_cdBCharges
  250. 221. pre_cdRcard
  251. 222. pre_cdRemail
  252. 223. pre_cdrenewpwd
  253.  
  254. 13. PRE_CardFees :: Database :: (aeroline)
  255. 224. pre_feesID
  256. 225. pre_feesFrom
  257. 226. pre_feesTo
  258. 227. pre_feesBy
  259. 228. pre_feesType
  260. 229. pre_feesLevel
  261. 230. pre_feesCost
  262. 231. pre_feesUser
  263. 232. pre_feesFtype
  264.  
  265. 14. PRE_CardNo :: Database :: (aeroline)
  266. 233. pre_cardID
  267. 234. pre_cardIssuedate
  268. 235. pre_cardAuth
  269. 236. pre_cardAuthname
  270. 237. pre_cardRange1
  271. 238. pre_cardRange2
  272. 239. pre_used
  273.  
  274. 15. PRE_CardSummaryDaily :: Database :: (aeroline)
  275. 240. pre_cardsummarydaily_id
  276. 241. pre_cardsummarydaily_cardno
  277. 242. pre_cardsummarydaily_date
  278. 243. pre_cardsummarydaily_topup_rm
  279. 244. pre_cardsummarydaily_topup_sg
  280. 245. pre_cardsummarydaily_tranx_rm
  281. 246. pre_cardsummarydaily_tranx_sg
  282. 247. pre_cardsummarydaily_balance
  283. 248. pre_cardsummarydaily_execute_date
  284.  
  285. 16. PRE_PaidValue :: Database :: (aeroline)
  286. 249. pre_pvID
  287. 250. pre_pvFrom
  288. 251. pre_pvTo
  289. 252. pre_pvBy
  290. 253. pre_pvType
  291. 254. pre_pvTopup
  292. 255. pre_pvValue
  293. 256. pre_pvUser
  294. 257. pre_pvVoucher
  295.  
  296. 17. PRE_Topup :: Database :: (aeroline)
  297. 258. pre_tpID
  298. 259. pre_tpCard
  299. 260. pre_tpCurrency
  300. 261. pre_tpTopup
  301. 262. pre_tpValue
  302. 263. pre_tpPay
  303. 264. pre_tpCharges
  304. 265. pre_tpStatus
  305. 266. pre_tpUser
  306. 267. pre_tpCreated
  307. 268. pre_tpBy
  308. 269. pre_tpVDate
  309. 270. pre_tpVRemark
  310. 271. pre_tpVUser
  311. 272. pre_tpVRef
  312. 273. pre_tpRef
  313. 274. pre_tpCreditcard
  314. 275. pre_tpCreditCardName
  315. 276. pre_tpCRef
  316. 277. pre_tpDateTime
  317. 278. pre_tpRate
  318. 279. pre_tpConvertTopup
  319. 280. pre_tpConvertValue
  320.  
  321. 18. PRE_Topup_Review :: Database :: (aeroline)
  322. 281. pre_tpID
  323. 282. pre_tpCard
  324. 283. pre_tpCurrency
  325. 284. pre_tpTopup
  326. 285. pre_tpValue
  327. 286. pre_tpPay
  328. 287. pre_tpCharges
  329. 288. pre_tpStatus
  330. 289. pre_tpUser
  331. 290. pre_tpCreated
  332. 291. pre_tpBy
  333. 292. pre_tpVDate
  334. 293. pre_tpVRemark
  335. 294. pre_tpVUser
  336. 295. pre_tpVRef
  337. 296. pre_tpRef
  338. 297. pre_tpCreditcard
  339. 298. pre_tpCreditCardName
  340. 299. pre_tpCRef
  341. 300. pre_tpDateTime
  342. 301. pre_tpreviewedby
  343. 302. pre_tpreviewed_status
  344. 303. pre_tpcredited
  345.  
  346. 19. PRE_Trans :: Database :: (aeroline)
  347. 304. pre_trRefno
  348. 305. pre_trDate
  349. 306. pre_trCounter
  350. 307. pre_trAmt
  351. 308. pre_trCard
  352. 309. pre_trDateTime
  353. 310. pre_trRate
  354. 311. pre_trConvertAmt
  355.  
  356. 20. Price :: Database :: (aeroline)
  357. 312. pri_id
  358. 313. pri_from
  359. 314. pri_to
  360. 315. pri_travel
  361. 316. pri_currency
  362. 317. pri_aprice
  363. 318. pri_user
  364. 319. pri_cprice
  365. 320. pri_bustype
  366.  
  367. 21. PrintTicketServer :: Database :: (aeroline)
  368. 321. pts_refno
  369. 322. pts_status
  370. 323. pts_created
  371. 324. pts_counter
  372. 325. pts_type
  373. 326. pts_newtkt
  374.  
  375. 22. RenewCard :: Database :: (aeroline)
  376. 327. ren_id
  377. 328. ren_user
  378. 329. ren_vip
  379. 330. ren_date
  380. 331. ren_currency
  381. 332. ren_fee
  382. 333. ren_newvip
  383.  
  384. 23. ReplaceCard :: Database :: (aeroline)
  385. 334. rep_id
  386. 335. rep_user
  387. 336. rep_vip
  388. 337. rep_date
  389. 338. rep_fee
  390. 339. rep_newvip
  391. 340. rep_currency
  392.  
  393. 24. Reward :: Database :: (aeroline)
  394. 341. RW_id
  395. 342. RW_desc
  396. 343. RW_point
  397.  
  398. 25. SpoiltTicket :: Database :: (aeroline)
  399. 344. st_id
  400. 345. st_oldtkt
  401. 346. st_newtkt
  402. 347. st_date
  403. 348. st_user
  404. 349. st_reason
  405.  
  406. 26. StopTrip :: Database :: (aeroline)
  407. 350. st_id
  408. 351. st_trip
  409. 352. st_date
  410.  
  411. 27. TagFares :: Database :: (aeroline)
  412. 353. tf_id
  413. 354. tf_from
  414. 355. tf_to
  415. 356. tf_counter
  416. 357. tf_price
  417. 358. tf_user
  418.  
  419. 28. TagRange :: Database :: (aeroline)
  420. 359. tg_id
  421. 360. tg_date
  422. 361. tg_user
  423. 362. tg_tkt1
  424. 363. tg_tkt2
  425. 364. tg_counter
  426. 365. tg_use
  427.  
  428. 29. TechnicalSupport :: Database :: (aeroline)
  429. 366. te_refno
  430. 367. te_date
  431. 368. te_name
  432. 369. te_menu
  433. 370. te_remark
  434. 371. te_comment
  435. 372. te_verify
  436. 373. te_user
  437. 374. te_counter
  438.  
  439. 30. TicketRange :: Database :: (aeroline)
  440. 375. tr_id
  441. 376. tr_date
  442. 377. tr_user
  443. 378. tr_tkt1
  444. 379. tr_tkt2
  445. 380. tr_counter
  446. 381. tr_use
  447.  
  448. 31. TicketSale :: Database :: (aeroline)
  449. 382. ts_id
  450. 383. ts_refno
  451. 384. ts_counter
  452. 385. ts_ticket
  453. 386. ts_seattype
  454. 387. ts_seatno
  455. 388. ts_price
  456. 389. ts_travel
  457. 390. ts_trip
  458. 391. ts_tripdate
  459. 392. ts_triptime
  460. 393. ts_returnid
  461. 394. ts_verify
  462. 395. ts_keyin
  463. 396. ts_user
  464. 397. ts_dest
  465. 398. ts_figure
  466. 399. ts_surtype
  467. 400. ts_bus
  468. 401. ts_verifyuser
  469. 402. ts_verifydate
  470. 403. ts_chgto
  471. 404. ts_status
  472. 405. ts_chgtkt
  473. 406. ts_chgtktdate
  474. 407. ts_surdiffbus
  475. 408. ts_chgtktfees
  476. 409. ts_surcreditcard
  477. 410. ts_spoilt
  478. 411. ts_hotelpackage
  479. 412. ts_keyintime
  480. 413. ts_dropoffpoint
  481. 414. ts_voucher
  482. 415. ts_reprint
  483. 416. ts_chgbus
  484. 417. ts_seqtkt
  485. 418. ts_veget
  486. 419. ts_chgadult
  487. 420. ts_paytype
  488. 421. ts_discount
  489. 422. ts_comm
  490. 423. ts_verifycounter
  491. 424. ts_verifynumber
  492.  
  493. 32. TripCounter :: Database :: (aeroline)
  494. 425. tc_id
  495. 426. tc_counter
  496. 427. tc_trip
  497. 428. tc_from
  498. 429. tc_to
  499. 430. tc_depart
  500. 431. tc_return
  501. 432. tc_future
  502. 433. tc_buyfrom
  503. 434. tc_buyto
  504. 435. tc_aerocardbuyfrom
  505. 436. tc_aerocardbuyto
  506. 437. tc_email_notify
  507. 438. tc_email_senddate
  508.  
  509. 33. TripScheduler :: Database :: (aeroline)
  510. 439. tsc_id
  511. 440. tsc_dest
  512. 441. tsc_d1
  513. 442. tsc_d2
  514. 443. tsc_d3
  515. 444. tsc_d4
  516. 445. tsc_d5
  517. 446. tsc_d6
  518. 447. tsc_d7
  519. 448. tsc_bus
  520. 449. tsc_deck
  521. 450. tsc_status
  522. 451. tsc_rem
  523.  
  524. 34. TripTime :: Database :: (aeroline)
  525. 452. tim_id
  526. 453. tim_time
  527.  
  528. 35. VegetFees :: Database :: (aeroline)
  529. 454. vf_id
  530. 455. vf_from
  531. 456. vf_to
  532. 457. vf_counter
  533. 458. vf_price
  534. 459. vf_user
  535.  
  536. 36. WaitList :: Database :: (aeroline)
  537. 460. wl_id
  538. 461. wl_member
  539. 462. wl_tripdate
  540. 463. wl_trip
  541. 464. wl_status
  542. 465. wl_created
  543. 466. wl_adult
  544. 467. wl_kid
  545. 468. wl_future
  546. 469. wl_counter
  547.  
  548. 37. access_level :: Database :: (aeroline)
  549. 470. a_refno
  550. 471. a1
  551. 472. a2
  552. 473. a3
  553. 474. a4
  554. 475. a5
  555. 476. a6
  556. 477. a7
  557. 478. a8
  558. 479. a9
  559. 480. a10
  560. 481. a11
  561. 482. a12
  562. 483. a13
  563. 484. a14
  564. 485. a15
  565. 486. a16
  566. 487. a17
  567. 488. a18
  568. 489. a19
  569. 490. a20
  570. 491. a21
  571. 492. a22
  572. 493. a23
  573. 494. a24
  574. 495. a25
  575. 496. a26
  576. 497. a27
  577. 498. a28
  578. 499. a29
  579. 500. a30
  580. 501. a31
  581. 502. a32
  582. 503. a33
  583. 504. a34
  584. 505. a35
  585. 506. a36
  586. 507. a37
  587. 508. a38
  588. 509. a39
  589. 510. a40
  590. 511. a41
  591. 512. a42
  592. 513. a43
  593. 514. a44
  594. 515. a45
  595. 516. a46
  596. 517. a47
  597. 518. a47s
  598. 519. a48
  599. 520. a49
  600. 521. a50
  601. 522. a501
  602. 523. a51
  603.  
  604. 38. aerocard_redeem :: Database :: (aeroline)
  605. 524. ar_id
  606. 525. ar_email
  607. 526. ar_cardno
  608. 527. ar_key
  609. 528. ar_status
  610. 529. ar_submitted_date
  611. 530. ar_question1
  612. 531. ar_question2
  613. 532. ar_question2_text
  614. 533. ar_question3_food
  615. 534. ar_question3_location
  616. 535. ar_question3_safety
  617. 536. ar_question3_journey
  618. 537. ar_question3_service
  619. 538. ar_question3_cost
  620. 539. ar_question4_food
  621. 540. ar_question4_location
  622. 541. ar_question4_safety
  623. 542. ar_question4_journey
  624. 543. ar_question4_service
  625. 544. ar_question4_cost
  626. 545. ar_question5
  627. 546. ar_sent
  628.  
  629. 39. allocate_seat :: Database :: (aeroline)
  630. 547. as_id
  631. 548. as_group
  632. 549. as_bustype
  633. 550. as_kl
  634. 551. as_cc
  635. 552. as_sin
  636. 553. as_user
  637.  
  638. 40. analyst :: Database :: (aeroline)
  639. 554. analyst_id
  640. 555. analyst_page
  641. 556. analyst_ref_page
  642. 557. analyst_speed
  643. 558. analyst_user
  644. 559. analyst_counter
  645. 560. analyst_date
  646. 561. analyst_ip
  647. 562. analyst_broswer
  648. 563. analyst_orderid
  649. 564. analyst_mac
  650.  
  651. 41. bank :: Database :: (aeroline)
  652. 565. b_id
  653. 566. b_name
  654.  
  655. 42. bus :: Database :: (aeroline)
  656. 567. bus_id
  657. 568. bus_no
  658. 569. bus_type
  659. 570. bus_user
  660. 571. bus_seat
  661.  
  662. 43. cash_voucher :: Database :: (aeroline)
  663. 572. cv_id
  664. 573. cv_nofrom
  665. 574. cv_noto
  666. 575. cv_dest
  667. 576. cv_fromdate
  668. 577. cv_todate
  669. 578. cv_vouchertype
  670. 579. cv_issue
  671. 580. cv_keyin
  672. 581. cv_user
  673.  
  674. 44. caterer :: Database :: (aeroline)
  675. 582. cat_id
  676. 583. cat_name
  677. 584. cat_addr
  678. 585. cat_contact
  679. 586. cat_user
  680. 587. cat_country
  681. 588. cat_password
  682. 589. cat_email
  683. 590. cat_fax
  684. 591. cat_active
  685. 592. cat_veget
  686. 593. cat_cut
  687.  
  688. 45. caterer_scheduler :: Database :: (aeroline)
  689. 594. cas_id
  690. 595. cas_caterer
  691. 596. cas_trip
  692. 597. cas_from
  693. 598. cas_to
  694. 599. cas_user
  695. 600. cas_keyin
  696.  
  697. 46. conversion_rate :: Database :: (aeroline)
  698. 601. con_id
  699. 602. con_from
  700. 603. con_to
  701. 604. con_rate
  702. 605. sud_user
  703.  
  704. 47. counter_prepaid_log :: Database :: (aeroline)
  705. 606. counter_prepaid_log_id
  706. 607. counter_prepaid_log_counteruser
  707. 608. counter_prepaid_log_cardno
  708. 609. counter_prepaid_log_password
  709. 610. counter_prepaid_log_date
  710. 611. counter_prepaid_log_ip
  711. 612. counter_prepaid_log_useragent
  712. 613. counter_prepaid_log_referral
  713. 614. counter_prepaid_log_success
  714.  
  715. 48. dailyrpt_caterer :: Database :: (aeroline)
  716. 615. c_id
  717. 616. c_caterer_name
  718. 617. c_trip_time
  719. 618. c_time_arrive
  720. 619. c_no_received
  721. 620. c_standby_food_issued
  722. 621. c_reason_of_lateness
  723. 622. c_userid
  724. 623. c_created
  725. 624. c_counter
  726.  
  727. 49. dailyrpt_cco_attendance :: Database :: (aeroline)
  728. 625. cco_id
  729. 626. cco_name
  730. 627. cco_timein
  731. 628. cco_lateby
  732. 629. cco_lunchout
  733. 630. cco_lunchin
  734. 631. cco_timeout
  735. 632. cco_userid
  736. 633. cco_created
  737. 634. cco_remark
  738. 635. cco_counter
  739.  
  740. 50. dailyrpt_sales_collection :: Database :: (aeroline)
  741. 636. sc_id
  742. 637. sc_shift
  743. 638. sc_closing_time
  744. 639. sc_bank_in_amount
  745. 640. sc_bank_tin_time
  746. 641. sc_fax_bank_in_slip
  747. 642. sc_explain
  748. 643. sc_shortage
  749. 644. sc_created
  750. 645. sc_userid
  751. 646. sc_remark
  752. 647. sc_counter
  753.  
  754. 51. dailyrpt_stocks :: Database :: (aeroline)
  755. 648. s_id
  756. 649. s_shift
  757. 650. s_items
  758. 651. s_opening_stock
  759. 652. s_issued
  760. 653. s_closing_stock
  761. 654. s_verify_by
  762. 655. s_created
  763. 656. s_userid
  764. 657. s_counter
  765.  
  766. 52. dailyrpt_trips_report :: Database :: (aeroline)
  767. 658. t_id
  768. 659. t_destination
  769. 660. t_trip_time
  770. 661. t_no_of_passenger_turn_up
  771. 662. t_bus_id
  772. 663. t_check_by_cco
  773. 664. t_cabin_crew_name
  774. 665. t_cabin_crew_arrive_time
  775. 666. t_bus_captain
  776. 667. t_bus_time_arrive
  777. 668. t_bus_time_depart
  778. 669. t_bus_late_by
  779. 670. t_bus_reason_of_lateness
  780. 671. t_created
  781. 672. t_userid
  782. 673. t_counter
  783.  
  784. 53. deduct_rate :: Database :: (aeroline)
  785. 674. dr_id
  786. 675. dr_from
  787. 676. dr_to
  788. 677. dr_hotel
  789. 678. dr_room
  790. 679. dr_night
  791. 680. dr_currency
  792. 681. dr_price
  793. 682. dr_fcur
  794. 683. dr_fprice
  795. 684. dr_keyin
  796. 685. dr_user
  797.  
  798. 54. dest :: Database :: (aeroline)
  799. 686. dest_id
  800. 687. dest_name
  801. 688. dest_reg1
  802. 689. dest_reg2
  803.  
  804. 55. dest_access :: Database :: (aeroline)
  805. 690. da_id
  806. 691. da_type
  807. 692. da_counter
  808. 693. da_dest
  809. 694. da_user
  810.  
  811. 56. driver :: Database :: (aeroline)
  812. 695. d_id
  813. 696. d_name
  814. 697. d_active
  815. 698. d_atsno
  816.  
  817. 57. drtripcode :: Database :: (aeroline)
  818. 699. dtc_id
  819. 700. dtc_code
  820. 701. dtc_amt
  821.  
  822. 58. duty_driver :: Database :: (aeroline)
  823. 702. dd_id
  824. 703. dd_from
  825. 704. dd_to
  826. 705. dd_trip
  827. 706. dd_driver
  828. 707. dd_user
  829.  
  830. 59. duty_steward :: Database :: (aeroline)
  831. 708. ds_id
  832. 709. ds_from
  833. 710. ds_to
  834. 711. ds_trip
  835. 712. ds_steward
  836. 713. ds_user
  837.  
  838. 60. e_cardtrans :: Database :: (aeroline)
  839. 714. ec_id
  840. 715. ec_refno
  841. 716. ec_amt
  842. 717. ec_cardno
  843. 718. ec_securitycode
  844. 719. ec_created
  845. 720. ec_type
  846. 721. ec_status
  847. 722. ec_newcode
  848. 723. ec_ip
  849. 724. ec_counter
  850.  
  851. 61. email :: Database :: (aeroline)
  852. 725. e_id
  853. 726. e_name
  854. 727. e_email
  855. 728. e_active
  856. 729. e_sendtype
  857.  
  858. 62. expenses :: Database :: (aeroline)
  859. 730. e_id
  860. 731. e_CH
  861. 732. e_name
  862. 733. e_cost
  863. 734. e_trip
  864. 735. e_CC
  865. 736. e_SG
  866. 737. e_PJ
  867. 738. e_CP
  868. 739. e_HFA
  869. 740. e_BUA
  870. 741. e_HFB
  871. 742. e_BUB
  872. 743. e_PNA
  873. 744. e_date
  874. 745. e_SWA
  875. 746. e_SWB
  876. 747. e_CHB
  877. 748. e_QBA
  878. 749. e_MNA
  879. 750. e_MNB
  880. 751. e_PNB
  881. 752. e_QBB
  882. 753. e_HFC
  883. 754. e_JBA
  884.  
  885. 63. expenses_list :: Database :: (aeroline)
  886. 755. el_id
  887. 756. el_refno
  888. 757. el_expense
  889. 758. el_keyin
  890. 759. el_user
  891. 760. el_counter
  892. 761. el_traveldate
  893. 762. el_bill
  894. 763. el_amount
  895. 764. el_trip
  896. 765. el_refund
  897. 766. el_hotel
  898. 767. el_remark
  899. 768. el_authorized
  900.  
  901. 64. expenses_other :: Database :: (aeroline)
  902. 769. eo_id
  903. 770. eo_date
  904. 771. eo_counter
  905. 772. eo_loginuser
  906. 773. eo_remark
  907. 774. eo_amount
  908. 775. eo_user
  909. 776. eo_verify
  910. 777. eo_created
  911.  
  912. 65. exptmp :: Database :: (aeroline)
  913. 778. id
  914. 779. refno
  915. 780. mmyy
  916.  
  917. 66. faq :: Database :: (aeroline)
  918. 781. faq_id
  919. 782. faq_categoryid
  920. 783. faq_title
  921. 784. faq_desc
  922. 785. faq_sort
  923. 786. faq_status
  924. 787. faq_createdate
  925. 788. faq_createby
  926. 789. faq_modifydate
  927. 790. faq_modifyby
  928.  
  929. 67. feedback :: Database :: (aeroline)
  930. 791. fb_id
  931. 792. fb_member
  932. 793. fb_link
  933. 794. fb_s1_a
  934. 795. fb_s1_b
  935. 796. fb_s1_c
  936. 797. fb_s1_d
  937. 798. fb_s1_e
  938. 799. fb_s1_f
  939. 800. fb_driver1
  940. 801. fb_driver2
  941. 802. fb_s2_a
  942. 803. fb_s2_b
  943. 804. fb_s2_c
  944. 805. fb_s2_d
  945. 806. fb_s2_e
  946. 807. fb_s2_f
  947. 808. fb_s2_g
  948. 809. fb_stewards
  949. 810. fb_s3_a
  950. 811. fb_s3_b
  951. 812. fb_s3_c
  952. 813. fb_s3_d
  953. 814. fb_s3_e
  954. 815. fb_s3_f
  955. 816. fb_s3_g
  956. 817. fb_s4_a
  957. 818. fb_s4_b
  958. 819. fb_s4_c
  959. 820. fb_s4_d
  960. 821. fb_s4_e
  961. 822. fb_s5_a
  962. 823. fb_s5_b
  963. 824. fb_s5_c
  964. 825. fb_s5_d
  965. 826. fb_s5_e
  966. 827. fb_s5_f
  967. 828. fb_s6_a
  968. 829. fb_s6_a1
  969. 830. fb_s6_b
  970. 831. fb_s6_c
  971. 832. fb_s6_d
  972. 833. fb_s6_d1
  973. 834. fb_s6_e
  974. 835. fb_s6_f
  975. 836. fb_s6_g
  976. 837. fb_s6_g1
  977. 838. fb_s6_i1
  978. 839. fb_s6_i2
  979. 840. fb_s6_i3
  980. 841. fb_s6_i4
  981. 842. fb_s6_i5
  982. 843. fb_s6_i6
  983. 844. fb_s6_i7
  984. 845. fb_s6_i8
  985. 846. fb_s6_j
  986. 847. fb_s6_j1
  987. 848. fb_s6_k
  988. 849. fb_s6_l1
  989. 850. fb_s6_l2
  990. 851. fb_s6_l3
  991. 852. fb_s6_m1
  992. 853. fb_s6_m2
  993. 854. fb_s6_m3
  994. 855. fb_s6_m4
  995. 856. fb_cc1
  996. 857. fb_cc2
  997. 858. fb_cc3
  998. 859. fb_cc4
  999. 860. fb_s7_a
  1000. 861. fb_s7_b
  1001. 862. fb_s7_c
  1002. 863. fb_s7_d
  1003. 864. fb_s7_comment
  1004. 865. fb_keyin
  1005. 866. fb_cco1
  1006. 867. fb_cco2
  1007. 868. fb_cco3
  1008. 869. fb_form
  1009. 870. fb_steward2
  1010. 871. fb_cc5
  1011. 872. fb_standby_dr
  1012. 873. fb_standby_cc
  1013. 874. fb_seatno
  1014.  
  1015. 68. festival_gift :: Database :: (aeroline)
  1016. 875. fg_member
  1017. 876. fg_type
  1018. 877. fg_created
  1019. 878. fg_counter
  1020.  
  1021. 69. festivalanalyst :: Database :: (aeroline)
  1022. 879. festivalanalyst_id
  1023. 880. festivalanalyst_ip
  1024. 881. festivalanalyst_date
  1025. 882. festivalanalyst_refer
  1026. 883. festivalanalyst_useragent
  1027.  
  1028. 70. groupseat :: Database :: (aeroline)
  1029. 884. gs_id
  1030. 885. gs_name
  1031.  
  1032. 71. highlight :: Database :: (aeroline)
  1033. 886. hl_id
  1034. 887. hl_from
  1035. 888. hl_to
  1036. 889. hl_counter
  1037. 890. hl_word
  1038. 891. hl_width
  1039. 892. hl_height
  1040. 893. hl_images
  1041. 894. hl_url
  1042.  
  1043. 72. hitcount :: Database :: (aeroline)
  1044. 895. host
  1045. 896. hit
  1046. 897. time
  1047.  
  1048. 73. holiday :: Database :: (aeroline)
  1049. 898. h_id
  1050. 899. h_country
  1051. 900. h_fromdate
  1052. 901. h_todate
  1053. 902. h_name
  1054.  
  1055. 74. hotel :: Database :: (aeroline)
  1056. 903. hot_id
  1057. 904. hot_name
  1058. 905. hot_addr
  1059. 906. hot_contact
  1060. 907. hot_person
  1061. 908. hot_user
  1062. 909. hot_country
  1063. 910. hot_pay
  1064. 911. hot_star
  1065. 912. hot_desc
  1066. 913. hot_rtdesc
  1067. 914. hot_departpoint
  1068. 915. hot_userid
  1069. 916. hot_password
  1070. 917. hot_email
  1071. 918. hot_remail
  1072. 919. hot_fax
  1073. 920. hot_active
  1074. 921. hot_state
  1075. 922. hot_remark
  1076.  
  1077. 75. hotel_commrate :: Database :: (aeroline)
  1078. 923. hc_id
  1079. 924. hc_from
  1080. 925. hc_to
  1081. 926. hc_hotel
  1082. 927. hc_room
  1083. 928. hc_currency
  1084. 929. hc_company
  1085. 930. hc_counter
  1086. 931. hc_fcur
  1087. 932. hc_fcompany
  1088. 933. hc_fcounter
  1089. 934. hc_keyin
  1090. 935. hc_user
  1091. 936. hc_depostype
  1092. 937. hc_commtype
  1093.  
  1094. 76. hotel_package :: Database :: (aeroline)
  1095. 938. hp_id
  1096. 939. hp_hotel
  1097. 940. hp_type
  1098. 941. hp_currency
  1099. 942. hp_first
  1100. 943. hp_anight
  1101. 944. hp_apax
  1102. 945. hp_surroom
  1103. 946. hp_surbus
  1104. 947. hp_bfare
  1105. 948. hp_comm
  1106. 949. hp_counter
  1107. 950. hp_countercom
  1108.  
  1109. 77. hotelface :: Database :: (aeroline)
  1110. 951. hf_id
  1111. 952. hf_from
  1112. 953. hf_to
  1113. 954. hf_hotel
  1114. 955. hf_room
  1115. 956. hf_currency
  1116. 957. hf_price
  1117. 958. hf_user
  1118. 959. hf_deposit
  1119. 960. hf_comm
  1120. 961. hf_save
  1121. 962. hf_keyin
  1122. 963. hf_fprice
  1123. 964. hf_fsave
  1124. 965. hf_fcur
  1125. 966. hf_tax
  1126. 967. hf_inclusive
  1127. 968. hf_created
  1128.  
  1129. 78. hotelroom :: Database :: (aeroline)
  1130. 969. id
  1131. 970. hr_hotel
  1132. 971. hr_id
  1133. 972. hr_type
  1134. 973. hr_user
  1135. 974. hr_desc
  1136.  
  1137. 79. hoteluser :: Database :: (aeroline)
  1138. 975. id
  1139. 976. hu_id
  1140. 977. hu_name
  1141. 978. hu_password
  1142. 979. hu_hotel
  1143. 980. hu_level
  1144. 981. hu_created
  1145. 982. hu_updated
  1146.  
  1147. 80. lockseat :: Database :: (aeroline)
  1148. 983. ls_id
  1149. 984. ls_counter
  1150. 985. ls_trip
  1151. 986. ls_seat
  1152. 987. ls_date
  1153. 988. ls_busno
  1154. 989. ls_user
  1155. 990. ls_by
  1156. 991. ls_keyin
  1157. 992. ls_lock
  1158.  
  1159. 81. log :: Database :: (aeroline)
  1160. 993. log_id
  1161. 994. log_name
  1162. 995. log_created
  1163. 996. log_counter
  1164. 997. log_user
  1165. 998. log_type
  1166. 999. log_client_ip
  1167.  
  1168. 82. login_member :: Database :: (aeroline)
  1169. 100. lm_refno
  1170. 100. lm_name
  1171. 100. lm_email
  1172. 100. lm_pwd
  1173. 100. lm_applydate
  1174. 100. lm_telno
  1175. 100. lm_nationality
  1176. 100. lm_code
  1177. 100. lm_other
  1178. 100. lm_form
  1179. 101. lm_mobileno
  1180. 101. lm_officeno
  1181. 101. lm_idd
  1182. 101. lm_dob
  1183. 101. lm_created
  1184. 101. lm_type
  1185. 101. lm_ic
  1186. 101. lm_passport
  1187. 101. lm_gender
  1188. 101. lm_addr
  1189. 102. lm_occup
  1190.  
  1191. 83. login_member_log :: Database :: (aeroline)
  1192. 102. lm_refno
  1193. 102. lm_name
  1194. 102. lm_email
  1195. 102. lm_pwd
  1196. 102. lm_applydate
  1197. 102. lm_telno
  1198. 102. lm_nationality
  1199. 102. lm_code
  1200. 102. lm_other
  1201. 103. lm_form
  1202. 103. lm_mobileno
  1203. 103. lm_officeno
  1204. 103. lm_idd
  1205. 103. lm_dob
  1206. 103. lm_created
  1207. 103. lm_type
  1208. 103. lm_ic
  1209. 103. lm_passport
  1210. 103. lm_gender
  1211. 104. lm_addr
  1212. 104. lm_occup
  1213. 104. user
  1214. 104. created
  1215. 104. ip
  1216.  
  1217. 84. lucky_draw :: Database :: (aeroline)
  1218. 104. ld_refno
  1219. 104. ld_gift
  1220. 104. ld_qty
  1221. 104. ld_keyin
  1222. 104. ld_user
  1223. 105. ld_counter
  1224.  
  1225. 85. luggage_tag :: Database :: (aeroline)
  1226. 105. lt_id
  1227. 105. lt_refno
  1228. 105. lt_tag
  1229. 105. lt_pay
  1230. 105. lt_amt
  1231. 105. lt_charges
  1232. 105. lt_counter
  1233. 105. lt_keyin
  1234. 105. lt_user
  1235.  
  1236. 86. mac_network :: Database :: (aeroline)
  1237. 106. mn_id
  1238. 106. mn_address
  1239. 106. mn_status
  1240. 106. mn_desc
  1241. 106. mn_createdate
  1242. 106. mn_createby
  1243. 106. mn_modifydate
  1244. 106. mn_modifyby
  1245.  
  1246. 87. member :: Database :: (aeroline)
  1247. 106. mem_vip
  1248. 106. mem_title
  1249. 107. mem_name
  1250. 107. mem_nic
  1251. 107. mem_oic
  1252. 107. mem_passport
  1253. 107. mem_brithday
  1254. 107. mem_sex
  1255. 107. mem_ms
  1256. 107. mem_nationality
  1257. 107. mem_residence
  1258. 107. mem_addr
  1259. 108. mem_tel
  1260. 108. mem_hp
  1261. 108. mem_email
  1262. 108. mem_travel
  1263. 108. mem_profession
  1264. 108. mem_company
  1265. 108. mem_otel
  1266. 108. mem_fax
  1267. 108. mem_time
  1268. 108. mem_password
  1269. 109. mem_counter
  1270. 109. mem_fee
  1271. 109. mem_currency
  1272. 109. mem_applydate
  1273. 109. mem_valid
  1274. 109. mem_approval
  1275. 109. mem_other
  1276. 109. mem_user
  1277.  
  1278. 88. myuser :: Database :: (aeroline)
  1279. 109. u_name
  1280. 109. u_password
  1281. 110. u_level
  1282. 110. u_counter
  1283. 110. u_email
  1284. 110. u_date
  1285. 110. u_adminlevel
  1286. 110. u_from
  1287. 110. u_to
  1288. 110. u_resend
  1289. 110. u_empid
  1290. 110. u_active
  1291.  
  1292. 89. nextid :: Database :: (aeroline)
  1293. 111. n_id
  1294. 111. n_vip
  1295. 111. n_gift
  1296. 111. n_svip
  1297. 111. CC
  1298. 111. n_ts
  1299. 111. n_change
  1300. 111. n_pin
  1301. 111. n_hotel
  1302. 111. n_receipt
  1303. 112. SG
  1304. 112. PJ
  1305. 112. CH
  1306. 112. hp_ch
  1307. 112. ITsupport
  1308. 112. filter_time
  1309. 112. n_ex
  1310. 112. PB
  1311. 112. PB_member
  1312. 112. CP
  1313. 113. wp_CH
  1314. 113. wp_SG
  1315. 113. wp_CP
  1316. 113. wp_PJ
  1317. 113. wp_CC
  1318. 113. PS
  1319. 113. n_seqtkt
  1320. 113. other_expenses
  1321. 113. HFA
  1322. 113. BUA
  1323. 114. HFB
  1324. 114. wp_HFA
  1325. 114. wp_HFB
  1326. 114. wp_BUA
  1327. 114. BUB
  1328. 114. wp_BUB
  1329. 114. PNA
  1330. 114. wp_PNA
  1331. 114. cimb
  1332. 114. SWA
  1333. 115. wp_SWA
  1334. 115. SWB
  1335. 115. wp_SWB
  1336. 115. prepaid
  1337. 115. luggage_tag
  1338. 115. CIMB_TIME
  1339. 115. CHB
  1340. 115. wp_CHB
  1341. 115. QBA
  1342. 115. wp_QBA
  1343. 116. delivery_id
  1344. 116. MNA
  1345. 116. wp_MNA
  1346. 116. MNB
  1347. 116. wp_MNB
  1348. 116. PNB
  1349. 116. wp_PNB
  1350. 116. QBB
  1351. 116. wp_QBB
  1352. 116. HFC
  1353. 117. wp_HFC
  1354. 117. JBA
  1355. 117. wp_JBA
  1356. 117. wp_JB
  1357. 117. tablet
  1358.  
  1359. 90. online_payment_transaction :: Database :: (aeroline)
  1360. 117. opt_id
  1361. 117. opt_OrderID
  1362. 117. opt_date
  1363. 117. opt_time
  1364. 117. opt_ResponseCode
  1365. 118. opt_ReasonCode
  1366. 118. opt_ReasonCodeDesc
  1367. 118. opt_PaddedCardNo
  1368. 118. opt_AuthCode
  1369. 118. opt_ReferenceNo
  1370. 118. opt_txnstatus
  1371. 118. opt_amount
  1372. 118. opt_cardname
  1373. 118. opt_bankref
  1374. 118. opt_txnmsg
  1375. 119. opt_datetime
  1376. 119. opt_fraund
  1377. 119. opt_bank
  1378.  
  1379. 91. pap_trans :: Database :: (aeroline)
  1380. 119. pt_id
  1381. 119. pt_cardno
  1382. 119. pt_refno
  1383. 119. pt_qty
  1384. 119. pt_status
  1385. 119. pt_remark
  1386. 119. pt_created
  1387. 120. pt_user
  1388. 120. pt_parent
  1389. 120. pt_expirydate
  1390.  
  1391. 92. pickup :: Database :: (aeroline)
  1392. 120. pic_id
  1393. 120. pic_from
  1394. 120. pic_to
  1395. 120. pic_travel
  1396. 120. pic_pick
  1397. 120. pic_drop
  1398. 120. pic_user
  1399. 121. pic_created
  1400. 121. pic_trip
  1401.  
  1402. 93. place :: Database :: (aeroline)
  1403. 121. p_id
  1404. 121. p_name
  1405.  
  1406. 94. prepaid_pap :: Database :: (aeroline)
  1407. 121. pp_id
  1408. 121. pp_tpRefno
  1409. 121. pp_tpdate
  1410. 121. pp_tpamount
  1411. 121. pp_from
  1412. 121. pp_to
  1413. 122. pp_issued_by
  1414. 122. pp_issued_date
  1415. 122. pp_member_name
  1416. 122. pp_member_add
  1417. 122. pp_member_phone
  1418. 122. pp_cardNo
  1419. 122. pp_bypostMenthod
  1420.  
  1421. 95. promotion :: Database :: (aeroline)
  1422. 122. pro_code
  1423. 122. pro_id
  1424. 122. pro_from
  1425. 123. pro_to
  1426. 123. pro_day
  1427. 123. pro_trip
  1428. 123. pro_adminchg
  1429. 123. pro_created
  1430. 123. pro_mon
  1431. 123. pro_tue
  1432. 123. pro_wed
  1433. 123. pro_thu
  1434. 123. pro_fri
  1435. 124. pro_sat
  1436. 124. pro_sun
  1437. 124. pro_adv
  1438. 124. pro_sc
  1439. 124. pro_online
  1440. 124. pro_PB
  1441. 124. pro_PS
  1442.  
  1443. 96. promotion_agent :: Database :: (aeroline)
  1444. 124. pra_id
  1445. 124. pra_refno
  1446. 124. pra_from
  1447. 125. pra_to
  1448. 125. pra_rm_double_KLSIN
  1449. 125. pra_rm_double_PJSIN
  1450. 125. pra_rm_double_SINKL
  1451. 125. pra_rm_double_SINPJ
  1452. 125. pra_rm_single_KLSIN
  1453. 125. pra_rm_single_PJSIN
  1454. 125. pra_rm_single_SINKL
  1455. 125. pra_rm_single_SINPJ
  1456. 125. pra_sd_double_KLSIN
  1457. 126. pra_sd_double_PJSIN
  1458. 126. pra_sd_double_SINKL
  1459. 126. pra_sd_double_SINPJ
  1460. 126. pra_sd_single_KLSIN
  1461. 126. pra_sd_single_PJSIN
  1462. 126. pra_sd_single_SINKL
  1463. 126. pra_sd_single_SINPJ
  1464. 126. pra_adminchg
  1465. 126. pra_created
  1466. 126. pra_rm_double_TVSIN
  1467. 127. pra_rm_single_TVSIN
  1468. 127. pra_sd_double_TVSIN
  1469. 127. pra_sd_single_TVSIN
  1470. 127. pra_rm_double_BUSIN
  1471. 127. pra_rm_single_BUSIN
  1472. 127. pra_sd_double_BUSIN
  1473. 127. pra_sd_single_BUSIN
  1474. 127. pra_rm_double_SINBU
  1475. 127. pra_rm_single_SINBU
  1476. 127. pra_sd_double_SINBU
  1477. 128. pra_sd_single_SINBU
  1478. 128. pra_rm_double_BUPNG
  1479. 128. pra_rm_single_BUPNG
  1480. 128. pra_sd_double_BUPNG
  1481. 128. pra_sd_single_BUPNG
  1482. 128. pra_rm_double_PNGBU
  1483. 128. pra_rm_single_PNGBU
  1484. 128. pra_sd_double_PNGBU
  1485. 128. pra_sd_single_PNGBU
  1486. 128. pra_rm_double_SWYSIN
  1487. 129. pra_rm_single_SWYSIN
  1488. 129. pra_sd_double_SWYSIN
  1489. 129. pra_sd_single_SWYSIN
  1490. 129. pra_rm_double_SINSWY
  1491. 129. pra_rm_single_SINSWY
  1492. 129. pra_sd_double_SINSWY
  1493. 129. pra_sd_single_SINSWY
  1494. 129. pra_rm_double_KLPNG
  1495. 129. pra_rm_single_KLPNG
  1496. 129. pra_sd_double_KLPNG
  1497. 130. pra_sd_single_KLPNG
  1498. 130. pra_rm_double_PNGKL
  1499. 130. pra_rm_single_PNGKL
  1500. 130. pra_sd_double_PNGKL
  1501. 130. pra_sd_single_PNGKL
  1502. 130. pra_rm_double_SWYPNG
  1503. 130. pra_rm_single_SWYPNG
  1504. 130. pra_sd_double_SWYPNG
  1505. 130. pra_sd_single_SWYPNG
  1506. 130. pra_rm_double_PNGSWY
  1507. 131. pra_rm_single_PNGSWY
  1508. 131. pra_sd_double_PNGSWY
  1509. 131. pra_sd_single_PNGSWY
  1510. 131. pra_rm_double_MNSSIN
  1511. 131. pra_rm_single_MNSSIN
  1512. 131. pra_sd_double_MNSSIN
  1513. 131. pra_sd_single_MNSSIN
  1514. 131. pra_rm_double_SINMNS
  1515. 131. pra_rm_single_SINMNS
  1516. 131. pra_sd_double_SINMNS
  1517. 132. pra_sd_single_SINMNS
  1518. 132. pra_rm_double_KLJB
  1519. 132. pra_rm_single_KLJB
  1520. 132. pra_sd_double_KLJB
  1521. 132. pra_sd_single_KLJB
  1522. 132. pra_rm_double_JBKL
  1523. 132. pra_rm_single_JBKL
  1524. 132. pra_sd_double_JBKL
  1525. 132. pra_sd_single_JBKL
  1526. 132. pra_rm_double_BUSWSIN
  1527. 133. pra_rm_single_BUSWSIN
  1528. 133. pra_sd_double_BUSWSIN
  1529. 133. pra_sd_single_BUSWSIN
  1530. 133. pra_rm_double_SINBUSW
  1531. 133. pra_rm_single_SINBUSW
  1532. 133. pra_sd_double_SINBUSW
  1533. 133. pra_sd_single_SINBUSW
  1534. 133. pra_rm_double_BSSIN
  1535. 133. pra_rm_single_BSSIN
  1536. 133. pra_sd_double_BSSIN
  1537. 134. pra_sd_single_BSSIN
  1538. 134. pra_rm_double_SINBS
  1539. 134. pra_rm_single_SINBS
  1540. 134. pra_sd_double_SINBS
  1541. 134. pra_sd_single_SINBS
  1542.  
  1543. 97. promotion_code :: Database :: (aeroline)
  1544. 134. pc_code
  1545. 134. pc_desc
  1546. 134. pc_created
  1547.  
  1548. 98. promotion_member :: Database :: (aeroline)
  1549. 134. pm_refno
  1550. 134. pm_counter
  1551. 135. pm_public
  1552. 135. pm_type
  1553. 135. pm_specialID
  1554. 135. pm_assign
  1555. 135. pm_addr
  1556. 135. pm_companyno
  1557. 135. pm_person
  1558. 135. pm_email
  1559.  
  1560. 99. promotion_setting :: Database :: (aeroline)
  1561. 135. pst_id
  1562. 135. pst_type
  1563. 136. pst_value
  1564.  
  1565. 10. promtemp :: Database :: (aeroline)
  1566. 136. pt_id
  1567. 136. pt_from
  1568. 136. pt_to
  1569. 136. pt_trip
  1570. 136. pt_cur
  1571. 136. pt_price
  1572.  
  1573. 10. refno_code :: Database :: (aeroline)
  1574. 136. ref_id
  1575. 136. ref_type
  1576. 136. ref_counter
  1577. 137. ref_code
  1578. 137. ref_user
  1579.  
  1580. 10. region :: Database :: (aeroline)
  1581. 137. reg_id
  1582. 137. reg_name
  1583.  
  1584. 10. room_provide :: Database :: (aeroline)
  1585. 137. rp_id
  1586. 137. rp_hotel
  1587. 137. rp_room
  1588. 137. rp_add
  1589. 137. rp_release
  1590. 137. rp_from
  1591. 138. rp_to
  1592. 138. rp_keyin
  1593. 138. rp_user
  1594.  
  1595. 10. sales_configure :: Database :: (aeroline)
  1596. 138. counter
  1597. 138. parameter
  1598.  
  1599. 10. seat :: Database :: (aeroline)
  1600. 138. se_id
  1601. 138. se_date
  1602. 138. se_trip
  1603. 138. se_seat
  1604. 138. se_user
  1605. 139. se_keyin
  1606. 139. se_type
  1607. 139. se_by
  1608. 139. se_busno
  1609. 139. se_to
  1610. 139. se_rdate
  1611.  
  1612. 10. service_counter :: Database :: (aeroline)
  1613. 139. sc_id
  1614. 139. sc_name
  1615. 139. sc_place
  1616. 139. sc_tktcode
  1617. 140. sc_currency
  1618. 140. sc_country
  1619. 140. sc_tel
  1620. 140. sc_fax
  1621. 140. sc_addr
  1622. 140. sc_active
  1623. 140. sc_type
  1624. 140. sc_region
  1625. 140. sc_maindest
  1626. 140. sc_tagcode
  1627. 141. sc_kios
  1628. 141. sc_queue
  1629. 141. sc_company
  1630.  
  1631. 10. stats :: Database :: (aeroline)
  1632. 141. time_str
  1633. 141. remote_host
  1634. 141. request
  1635. 141. referer
  1636. 141. user_agent
  1637.  
  1638. 10. stewards :: Database :: (aeroline)
  1639. 141. s_id
  1640. 141. s_name
  1641. 142. s_active
  1642. 142. s_atsno
  1643.  
  1644. 10. surcharges :: Database :: (aeroline)
  1645. 142. sur_id
  1646. 142. sur_from
  1647. 142. sur_to
  1648. 142. sur_figure
  1649. 142. sur_user
  1650. 142. sur_counter
  1651. 142. sur_prepaid
  1652.  
  1653. 11. surcharges_change :: Database :: (aeroline)
  1654. 142. suc_id
  1655. 143. suc_counter
  1656. 143. suc_change
  1657. 143. suc_fc
  1658. 143. suc_fsc
  1659. 143. suc_fc2
  1660. 143. suc_fsc2
  1661. 143. suc_user
  1662.  
  1663. 11. surcharges_coachrefund :: Database :: (aeroline)
  1664. 143. scr_id
  1665. 143. scr_cur
  1666. 143. scr_org
  1667. 144. scr_my
  1668. 144. scr_sg
  1669. 144. scr_user
  1670.  
  1671. 11. surcharges_delivery :: Database :: (aeroline)
  1672. 144. sud_id
  1673. 144. sud_from
  1674. 144. sud_to
  1675. 144. sud_currency
  1676. 144. sud_place
  1677. 144. sud_surcharges
  1678. 144. sud_user
  1679.  
  1680. 11. surcharges_topup :: Database :: (aeroline)
  1681. 145. stu_id
  1682. 145. stu_cur
  1683. 145. stu_org
  1684. 145. stu_my
  1685. 145. stu_sg
  1686. 145. stu_user
  1687.  
  1688. 11. surcharges_upcoming :: Database :: (aeroline)
  1689. 145. sup_id
  1690. 145. sup_country
  1691. 145. sup_from
  1692. 145. sup_to
  1693. 146. sup_charges
  1694. 146. sup_user
  1695.  
  1696. 11. survey_form :: Database :: (aeroline)
  1697. 146. id
  1698. 146. name
  1699. 146. email
  1700. 146. q1
  1701. 146. q1_other
  1702. 146. q2
  1703. 146. q3
  1704. 146. q4
  1705. 147. q5
  1706. 147. q6
  1707. 147. q6_1
  1708. 147. q6_2
  1709. 147. q6_3
  1710. 147. q7
  1711. 147. q8
  1712. 147. q9
  1713. 147. q9_2
  1714. 147. q10
  1715. 148. by
  1716. 148. created
  1717. 148. c1
  1718. 148. c2
  1719. 148. type
  1720. 148. q11
  1721. 148. q12
  1722. 148. q13
  1723. 148. q14
  1724.  
  1725. 11. tablename :: Database :: (aeroline)
  1726. 148. tablename_id
  1727. 149. tablename_date
  1728. 149. AddPoint
  1729. 149. BookHotel
  1730. 149. CallBook
  1731. 149. CancelOrder
  1732. 149. CancelTicket
  1733. 149. ChangeBus
  1734. 149. ChangeBus_list
  1735. 149. ChangeTicket
  1736. 149. Default_Seat
  1737. 150. HotelPackage_list
  1738. 150. LogFile
  1739. 150. PRE_CardDetail
  1740. 150. PRE_CardFees
  1741. 150. PRE_CardNo
  1742. 150. PRE_CardSummaryDaily
  1743. 150. PRE_PaidValue
  1744. 150. PRE_Topup
  1745. 150. PRE_Trans
  1746. 150. Price
  1747. 151. PrintTicketServer
  1748. 151. RenewCard
  1749. 151. ReplaceCard
  1750. 151. Reward
  1751. 151. SpoiltTicket
  1752. 151. StopTrip
  1753. 151. TagFares
  1754. 151. TagRange
  1755. 151. TechnicalSupport
  1756. 151. TicketRange
  1757. 152. TicketSale
  1758. 152. TripCounter
  1759. 152. TripScheduler
  1760. 152. TripTime
  1761. 152. VegetFees
  1762. 152. WaitList
  1763. 152. access_level
  1764. 152. allocate_seat
  1765. 152. bank
  1766. 152. bus
  1767. 153. cash_voucher
  1768. 153. caterer
  1769. 153. caterer_scheduler
  1770. 153. conversion_rate
  1771. 153. deduct_rate
  1772. 153. dest
  1773. 153. dest_access
  1774. 153. driver
  1775. 153. drtripcode
  1776. 153. duty_driver
  1777. 154. duty_steward
  1778. 154. email
  1779. 154. expenses
  1780. 154. expenses_list
  1781. 154. expenses_other
  1782. 154. exptmp
  1783. 154. feedback
  1784. 154. festival_gift
  1785. 154. groupseat
  1786. 154. highlight
  1787. 155. hitcount
  1788. 155. holiday
  1789. 155. hotel
  1790. 155. hotel_commrate
  1791. 155. hotel_package
  1792. 155. hotelface
  1793. 155. hotelroom
  1794. 155. hoteluser
  1795. 155. lockseat
  1796. 155. log
  1797. 156. login_member
  1798. 156. lucky_draw
  1799. 156. luggage_tag
  1800. 156. member
  1801. 156. myuser
  1802. 156. nextid
  1803. 156. online_payment_transaction
  1804. 156. pickup
  1805. 156. place
  1806. 156. promotion
  1807. 157. promotion_agent
  1808. 157. promotion_code
  1809. 157. promotion_member
  1810. 157. promotion_setting
  1811. 157. promtemp
  1812. 157. refno_code
  1813. 157. region
  1814. 157. room_provide
  1815. 157. sales_configure
  1816. 157. seat
  1817. 158. service_counter
  1818. 158. stats
  1819. 158. stewards
  1820. 158. surcharges
  1821. 158. surcharges_change
  1822. 158. surcharges_coachrefund
  1823. 158. surcharges_delivery
  1824. 158. surcharges_topup
  1825. 158. surcharges_upcoming
  1826. 158. tablename
  1827. 159. ticket_delivery
  1828. 159. variable_price
  1829. 159. verify_info
  1830. 159. waybill
  1831. 159. festivalanalyst
  1832. 159. festival_gift_2010
  1833. 159. PRE_Topup_Review
  1834. 159. counter_prepaid_log
  1835. 159. prepaid_pap
  1836. 159. analyst
  1837. 160. mac_network
  1838. 160. aerocard_redeem
  1839. 160. TicketSale_archive
  1840. 160. faq
  1841.  
  1842. 11. ticket_delivery :: Database :: (aeroline)
  1843. 160. td_refno
  1844. 160. td_place
  1845. 160. td_amt
  1846. 160. td_addr
  1847.  
  1848. 11. variable_price :: Database :: (aeroline)
  1849. 160. vp_id
  1850. 160. vp_from
  1851. 161. vp_to
  1852. 161. vp_mon
  1853. 161. vp_tue
  1854. 161. vp_wed
  1855. 161. vp_thu
  1856. 161. vp_fri
  1857. 161. vp_sat
  1858. 161. vp_sun
  1859. 161. vp_KLSIN
  1860. 161. vp_SINKL
  1861. 162. vp_PJSIN
  1862. 162. vp_SINPJ
  1863. 162. vp_BUSIN
  1864. 162. vp_SINBU
  1865. 162. vp_BUPNG
  1866. 162. vp_PNGBU
  1867. 162. vp_waive
  1868. 162. vp_agent
  1869. 162. vp_online
  1870. 162. vp_foragent
  1871. 163. vp_forcorporate
  1872. 163. vp_SWYSIN
  1873. 163. vp_SINSWY
  1874. 163. vp_KLPNG
  1875. 163. vp_PNGKL
  1876. 163. vp_PNGSWY
  1877. 163. vp_SWYPNG
  1878. 163. vp_MNSSIN
  1879. 163. vp_SINMNS
  1880. 163. vp_KLJB
  1881. 164. vp_JBKL
  1882. 164. vp_BUSWSIN
  1883. 164. vp_SINBUSW
  1884. 164. vp_BSSIN
  1885. 164. vp_SINBS
  1886.  
  1887. 11. verify_info :: Database :: (aeroline)
  1888. 164. vi_refno
  1889. 164. vi_name
  1890. 164. vi_ic
  1891. 164. vi_tel
  1892. 164. vi_addr
  1893. 165. vi_owner
  1894. 165. vi_print
  1895. 165. vi_created
  1896.  
  1897. 12. waybill :: Database :: (aeroline)
  1898. 165. wb_id
  1899. 165. wb_date
  1900. 165. wb_trip
  1901. 165. wb_driver1
  1902. 165. wb_driver2
  1903. 165. wb_stewards
  1904. 165. wb_bus
  1905. 166. wb_keyin
  1906. 166. wb_user
  1907. 166. wb_refno
  1908. 166. wb_cco1
  1909. 166. wb_cco2
  1910. 166. wb_cco3
  1911. 166. wb_arrive
  1912. 166. wb_menu
  1913. 166. wb_sbfood
  1914. 166. wb_psg
  1915. 167. wb_noturnup_sbfd
  1916. 167. wb_counter
  1917. 167. wb_steward2
  1918. 167. wb_standby_dr
  1919. 167. wb_standby_cc'>
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!