Advertisement
Guest User

Untitled

a guest
Dec 12th, 2019
127
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.31 KB | None | 0 0
  1. mysql> select * from australian_public_number_directory_information where number = '61286654543'\G
  2. *************************** 1. row ***************************
  3. number: 61286654543
  4. service_status_date: NULL
  5. service_status: D
  6. customer_name_1:
  7. customer_name_2:
  8. long_name:
  9. customer_title:
  10. finding_name_1:
  11. finding_name_2:
  12. finding_title:
  13. service_building_type:
  14. service_building_1st_number:
  15. service_building_1st_suffix:
  16. service_building_2nd_number:
  17. service_building_2nd_suffix:
  18. service_building_floor_type:
  19. service_building_floor_number:
  20. service_building_floor_number_suffix:
  21. service_building_property:
  22. service_building_location:
  23. service_street_house_number_1:
  24. service_street_house_number_1_suffix:
  25. service_street_house_number_2:
  26. service_street_house_number_2_suffix:
  27. service_street_name_1:
  28. service_street_type_1:
  29. service_street_suffix_1:
  30. service_street_name_2:
  31. service_street_type_2:
  32. service_street_suffix_2:
  33. service_address_locality: NULL
  34. service_address_post_code: NULL
  35. service_address_province_id: NULL
  36. service_address_country_id: NULL
  37. directory_building_type:
  38. directory_building_1st_number:
  39. directory_building_1st_suffix:
  40. directory_building_2nd_number:
  41. directory_building_2nd_suffix:
  42. directory_building_floor_type:
  43. directory_building_floor_number:
  44. directory_building_floor_number_suffix:
  45. directory_building_property:
  46. directory_building_location:
  47. directory_street_house_number_1:
  48. directory_street_house_number_1_suffix:
  49. directory_street_house_number_2:
  50. directory_street_house_number_2_suffix:
  51. directory_street_name_1:
  52. directory_street_type_1:
  53. directory_street_suffix_1:
  54. directory_street_name_2:
  55. directory_street_type_2:
  56. directory_street_suffix_2:
  57. directory_address_locality: NULL
  58. directory_address_post_code: NULL
  59. directory_address_province_id: NULL
  60. directory_address_country_id: NULL
  61. customer_contact_name_1:
  62. customer_contact_name_2:
  63. customer_contact_number:
  64. actor_type_id: 1
  65. type_of_service_id: Fixed
  66. latest_synchronize_time: NULL
  67. last_updated: 2017-07-25 17:22:02
  68. current_details_automatically_populated: 0
  69. valid: 0
  70. state_id: 2
  71. carriage_service_provider_code: NULL
  72. actor_id: NULL
  73. last_sent: NULL
  74. list_code_id: UL
  75. sync_state_id: 2
  76. sync_error:
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement