high_quality_list_day建表.sql 2.7 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576
  1. -- tsl_data.high_quality_list_day
  2. create table tsl_data.high_quality_list_day (
  3. id bigserial NOT NULL,
  4. month_id varchar(18) NULL,
  5. day_id varchar(6) NULL,
  6. contact_id varchar(150) NULL,
  7. busino_area_name varchar(90) NULL,
  8. busino_prov_name varchar(90) NULL,
  9. sheet_no varchar(90) NULL,
  10. busi_number varchar(120) NULL,
  11. cust_star_name varchar(30) NULL,
  12. sheet_type_name varchar(150) NULL,
  13. serv_type_name varchar(900) NULL,
  14. last_deal_content varchar(4136) NULL,
  15. accept_time varchar(150) NULL,
  16. archived_time varchar(150) NULL,
  17. data_type_name varchar(300) NULL,
  18. channel_name varchar(150) NULL,
  19. profes_dep varchar(300) NULL,
  20. big_type_name varchar(300) NULL,
  21. small_type_name varchar(300) NULL,
  22. is_dispatch_cloud varchar(30) NULL,
  23. accept_channel_name varchar(300) NULL,
  24. duty_reason_name varchar(900) NULL,
  25. duty_major_name varchar(300) NULL,
  26. is_online_complete varchar(15) NULL,
  27. is_call_complete varchar(15) NULL,
  28. is_cusser_complete varchar(15) NULL,
  29. is_distr_complete varchar(15) NULL,
  30. caller_number varchar(90) NULL,
  31. compl_area_name varchar(60) NULL,
  32. compl_prov_name varchar(60) NULL,
  33. submit_channel varchar(300) NULL,
  34. solved_result_desc varchar(4136) NULL,
  35. cust_level_name varchar(300) NULL,
  36. busi_type_name varchar(300) NULL,
  37. urgent_level_name varchar(300) NULL,
  38. important_type_name varchar(300) NULL,
  39. is_upgrade varchar(15) NULL,
  40. actual_total_len varchar(60) NULL,
  41. nature_actual_total_len varchar(60) NULL,
  42. cust_satis_desc varchar(300) NULL,
  43. auto_is_ok varchar(60) NULL,
  44. auto_cust_satis_desc varchar(300) NULL,
  45. nonauto_is_ok_name varchar(15) NULL,
  46. nonauto_cust_satis_desc varchar(150) NULL,
  47. prod_type_name varchar(300) NULL,
  48. proc_name varchar(600) NULL,
  49. merge_satis_desc varchar(60) NULL,
  50. serv_type_name_new varchar(1500) NULL,
  51. is_svip_keyman varchar(6) NULL,
  52. customer_label varchar(120) NULL,
  53. prov_name varchar(180) NULL,
  54. area_id varchar(30) NULL,
  55. area_name varchar(150) NULL,
  56. city_id varchar(60) NULL,
  57. city_name varchar(300) NULL,
  58. grid_id varchar(60) NULL,
  59. grid_name varchar(300) NULL,
  60. is_distri_area varchar(15) NULL,
  61. cp_satisfaction varchar(60) NULL,
  62. cp_is_ok varchar(60) NULL,
  63. cp_timely_contact varchar(60) NULL,
  64. cp_type varchar(300) NULL,
  65. novisit_tag varchar(30) NULL,
  66. serv_content varchar(4136) NULL,
  67. gis_area varchar(60) NULL,
  68. gis_area_name varchar(60) NULL,
  69. gis_city varchar(60) NULL,
  70. gis_city_name varchar(60) NULL,
  71. use_gis varchar(3) NULL,
  72. month_date varchar(18) NULL,
  73. day_date varchar(6) NULL,
  74. CONSTRAINT high_quality_list_day_pkey PRIMARY KEY (id)
  75. )