API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Mar 1st, 2017
67
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.76 KB | None | 0 0
raw download clone embed print report
  1. -- Table: public.cdr_rpt
  2.  
  3. -- DROP TABLE public.cdr_rpt;
  4.  
  5. CREATE TABLE public.cdr_rpt
  6. (
  7. year integer NOT NULL,
  8. code numeric(12, 2) NOT NULL,
  9. category character varying(255) COLLATE pg_catalog."default" NOT NULL,
  10. posttle character varying(255) COLLATE pg_catalog."default" NOT NULL,
  11. cut character varying(255) COLLATE pg_catalog."default" NOT NULL,
  12. cat character varying(255) COLLATE pg_catalog."default" NOT NULL,
  13. currency character varying(255) COLLATE pg_catalog."default" NOT NULL,
  14. basicincn integer,
  15. basicinc10 numeric(19, 2),
  16. basicinc25 numeric(19, 2),
  17. basicincmedian numeric(19, 2),
  18. basicincmean numeric(19, 2),
  19. basicinc65 numeric(19, 2),
  20. basicinc75 numeric(19, 2),
  21. basicinc90 numeric(19, 2),
  22. basiccon integer,
  23. basiccomedian numeric(19, 2),
  24. basiccomean numeric(19, 2),
  25. prdcon integer,
  26. prdcomedian numeric(6, 3),
  27. prdcomean numeric(6, 3),
  28. prdcotcmedian numeric(6, 3),
  29. prdcotcmean numeric(6, 3),
  30. prdcotdmedian numeric(6, 3),
  31. prdcotdmean numeric(6, 3),
  32. targettcincn integer,
  33. targettcinc10 numeric(19, 2),
  34. targettcinc25 numeric(19, 2),
  35. targettcincmedian numeric(19, 2),
  36. targettcincmean numeric(19, 2),
  37. targettcinc65 numeric(19, 2),
  38. targettcinc75 numeric(19, 2),
  39. targettcinc90 numeric(19, 2),
  40. targettccon integer,
  41. targettccomedian numeric(19, 2),
  42. targettccomean numeric(19, 2),
  43. pctincn integer,
  44. pctinc10 numeric(6, 3),
  45. pctinc25 numeric(6, 3),
  46. pctincmedian numeric(6, 3),
  47. pctincmean numeric(6, 3),
  48. pctinc65 numeric(6, 3),
  49. pctinc75 numeric(6, 3),
  50. pctinc90 numeric(6, 3),
  51. pctcon integer,
  52. pctcomedian numeric(6, 3),
  53. pctcomean numeric(6, 3),
  54. tcincn integer,
  55. tcinc10 numeric(19, 2),
  56. tcinc25 numeric(19, 2),
  57. tcincmedian numeric(19, 2),
  58. tcincmean numeric(19, 2),
  59. tcinc65 numeric(19, 2),
  60. tcinc75 numeric(19, 2),
  61. tcinc90 numeric(19, 2),
  62. tccon integer,
  63. tccomedian numeric(19, 2),
  64. tccomean numeric(19, 2),
  65. ltargetvalincn integer,
  66. ltargetvalinc10 numeric(19, 2),
  67. ltargetvalinc25 numeric(19, 2),
  68. ltargetvalincmedian numeric(19, 2),
  69. ltargetvalincmean numeric(19, 2),
  70. ltargetvalinc65 numeric(19, 2),
  71. ltargetvalinc75 numeric(19, 2),
  72. ltargetvalinc90 numeric(19, 2),
  73. ltargetvalcon integer,
  74. ltargetvalcomedian numeric(19, 2),
  75. ltargetvalcomean numeric(19, 2),
  76. ltaddincn integer,
  77. ltaddinc10 numeric(19, 2),
  78. ltaddinc25 numeric(19, 2),
  79. ltaddincmedian numeric(19, 2),
  80. ltaddincmean numeric(19, 2),
  81. ltaddinc65 numeric(19, 2),
  82. ltaddinc75 numeric(19, 2),
  83. ltaddinc90 numeric(19, 2),
  84. ltaddcon integer,
  85. ltaddcomedian numeric(19, 2),
  86. ltaddcomean numeric(19, 2),
  87. lpctbasicincn integer,
  88. lpctbasicinc10 numeric(6, 3),
  89. lpctbasicinc25 numeric(6, 3),
  90. lpctbasicincmedian numeric(6, 3),
  91. lpctbasicincmean numeric(6, 3),
  92. lpctbasicinc65 numeric(6, 3),
  93. lpctbasicinc75 numeric(6, 3),
  94. lpctbasicinc90 numeric(6, 3),
  95. lpctbasiccon integer,
  96. lpctbasiccomedian numeric(6, 3),
  97. lpctbasiccomean numeric(6, 3),
  98. targettdincn integer,
  99. targettdinc10 numeric(19, 2),
  100. targettdinc25 numeric(19, 2),
  101. targettdincmedian numeric(19, 2),
  102. targettdincmean numeric(19, 2),
  103. targettdinc65 numeric(19, 2),
  104. targettdinc75 numeric(19, 2),
  105. targettdinc90 numeric(19, 2),
  106. targettdcon integer,
  107. targettdcomedian numeric(19, 2),
  108. targettdcomean numeric(19, 2),
  109. tdincn integer,
  110. tdinc10 numeric(19, 2),
  111. tdinc25 numeric(19, 2),
  112. tdincmedian numeric(19, 2),
  113. tdincmean numeric(19, 2),
  114. tdinc65 numeric(19, 2),
  115. tdinc75 numeric(19, 2),
  116. tdinc90 numeric(19, 2),
  117. tdcon integer,
  118. tdcomedian numeric(19, 2),
  119. tdcomean numeric(19, 2),
  120. ltaddongincn integer,
  121. ltaddonginc10 numeric(19, 2),
  122. ltaddonginc25 numeric(19, 2),
  123. ltaddongincmedian numeric(19, 2),
  124. ltaddongincmean numeric(19, 2),
  125. ltaddonginc65 numeric(19, 2),
  126. ltaddonginc75 numeric(19, 2),
  127. ltaddonginc90 numeric(19, 2),
  128. ltaddongcon integer,
  129. ltaddongcomedian numeric(19, 2),
  130. ltaddongcomean numeric(19, 2),
  131. lpctbasicongincn integer,
  132. lpctbasiconginc10 numeric(6, 3),
  133. lpctbasiconginc25 numeric(6, 3),
  134. lpctbasicongincmedian numeric(6, 3),
  135. lpctbasicongincmean numeric(6, 3),
  136. lpctbasiconginc65 numeric(6, 3),
  137. lpctbasiconginc75 numeric(6, 3),
  138. lpctbasiconginc90 numeric(6, 3),
  139. lpctbasicongcon integer,
  140. lpctbasicongcomedian numeric(6, 3),
  141. lpctbasicongcomean numeric(6, 3),
  142. tdongincn integer,
  143. tdonginc10 numeric(19, 2),
  144. tdonginc25 numeric(19, 2),
  145. tdongincmedian numeric(19, 2),
  146. tdongincmean numeric(19, 2),
  147. tdonginc65 numeric(19, 2),
  148. tdonginc75 numeric(19, 2),
  149. tdonginc90 numeric(19, 2),
  150. tdongcon integer,
  151. tdongcomedian numeric(19, 2),
  152. tdongcomean numeric(19, 2),
  153. revincn integer,
  154. revincmedian numeric(19, 2),
  155. revincmean numeric(19, 2),
  156. revcon integer,
  157. revcomedian numeric(19, 2),
  158. revcomean numeric(19, 2),
  159. nummatchcon integer,
  160. nummatchincn integer,
  161. suptotalcon integer,
  162. suptotalincn integer,
  163. suptotalincmean integer,
  164. ex1incn integer,
  165. ex1incpct numeric(6, 3),
  166. ex2incn integer,
  167. ex2incpct numeric(6, 3),
  168. match1incn integer,
  169. match1incpct numeric(6, 3),
  170. match2incn integer,
  171. match2incpct numeric(6, 3),
  172. match3incn integer,
  173. match3incpct numeric(6, 3),
  174. regcode1incn integer,
  175. regcode1incpct numeric(6, 3),
  176. regcode2incn integer,
  177. regcode2incpct numeric(6, 3),
  178. regcode3incn integer,
  179. regcode3incpct numeric(6, 3),
  180. regcode4incn integer,
  181. regcode4incpct numeric(6, 3),
  182. regcode5incn integer,
  183. regcode5incpct numeric(6, 3),
  184. regcode6incn integer,
  185. regcode6incpct numeric(6, 3),
  186. stelig0con integer,
  187. stelig0copct numeric(6, 3),
  188. stelig1con integer,
  189. stelig1copct numeric(6, 3),
  190. stelig0incn integer,
  191. stelig0incpct numeric(6, 3),
  192. stelig1incn integer,
  193. stelig1incpct numeric(6, 3),
  194. anystrecd0incn integer,
  195. anystrecd0incpct numeric(6, 3),
  196. anystrecd1incn integer,
  197. anystrecd1incpct numeric(6, 3),
  198. havttarget0con integer,
  199. havttarget0copct numeric(6, 3),
  200. havttarget1con integer,
  201. havttarget1copct numeric(6, 3),
  202. tottargetcon integer,
  203. tottargetco25 numeric(19, 2),
  204. tottargetcomedian numeric(19, 2),
  205. tottargetcomean numeric(19, 2),
  206. tottargetco75 numeric(19, 2),
  207. actvtargetcon integer,
  208. actvtargetincn integer,
  209. actvtargetincmean numeric(6, 3),
  210. lelig0con integer,
  211. lelig0copct numeric(6, 3),
  212. lelig1con integer,
  213. lelig1copct numeric(6, 3),
  214. lelig0incn integer,
  215. lelig0incpct numeric(6, 3),
  216. lelig1incn integer,
  217. lelig1incpct numeric(6, 3),
  218. lrecd0incn integer,
  219. lrecd0incpct numeric(6, 3),
  220. lrecd1incn integer,
  221. lrecd1incpct numeric(6, 3),
  222. sls1con integer,
  223. sls1copct numeric(6, 3),
  224. sls200con integer,
  225. sls200copct numeric(6, 3),
  226. sls3000con integer,
  227. sls3000copct numeric(6, 3),
  228. sls99999con integer,
  229. sls99999copct numeric(6, 3),
  230. sls1incn integer,
  231. sls1incpct numeric(6, 3),
  232. sls200incn integer,
  233. sls200incpct numeric(6, 3),
  234. sls3000incn integer,
  235. sls3000incpct numeric(6, 3),
  236. slstarget1con integer,
  237. slstarget1co25 numeric(6, 3),
  238. slstarget1comedian numeric(6, 3),
  239. slstarget1comean numeric(6, 3),
  240. slstarget1co75 numeric(6, 3),
  241. slstarget2con integer,
  242. slstarget2co25 numeric(6, 3),
  243. slstarget2comedian numeric(6, 3),
  244. slstarget2comean numeric(6, 3),
  245. slstarget2co75 numeric(6, 3),
  246. slstarget3con integer,
  247. slstarget3co25 numeric(6, 3),
  248. slstarget3comedian numeric(6, 3),
  249. slstarget3comean numeric(6, 3),
  250. slstarget3co75 numeric(6, 3),
  251. slstarget4con integer,
  252. slstarget4co25 numeric(6, 3),
  253. slstarget4comedian numeric(6, 3),
  254. slstarget4comean numeric(6, 3),
  255. slstarget4co75 numeric(6, 3),
  256. revtargetteamcfyincn integer,
  257. revtargetteamcfyinc10 numeric(19, 2),
  258. revtargetteamcfyinc25 numeric(19, 2),
  259. revtargetteamcfyincmedian numeric(19, 2),
  260. revtargetteamcfyincmean numeric(19, 2),
  261. revtargetteamcfyinc65 numeric(19, 2),
  262. revtargetteamcfyinc75 numeric(19, 2),
  263. revtargetteamcfyinc90 numeric(19, 2),
  264. revtargetteamcfycon integer,
  265. revtargetteamcfycomedian numeric(19, 2),
  266. revtargetteamcfycomean numeric(19, 2),
  267. revtargetindvcfyincn integer,
  268. revtargetindvcfyinc10 numeric(19, 2),
  269. revtargetindvcfyinc25 numeric(19, 2),
  270. revtargetindvcfyincmedian numeric(19, 2),
  271. revtargetindvcfyincmean numeric(19, 2),
  272. revtargetindvcfyinc65 numeric(19, 2),
  273. revtargetindvcfyinc75 numeric(19, 2),
  274. revtargetindvcfyinc90 numeric(19, 2),
  275. revtargetindvcfycon integer,
  276. revtargetindvcfycomedian numeric(19, 2),
  277. revtargetindvcfycomean numeric(19, 2),
  278. CONSTRAINT cdr_rpt_pkey PRIMARY KEY (year, code, cat, cut, currency)
  279. )
  280. WITH (
  281. OIDS = FALSE
  282. )
  283. TABLESPACE pg_default;
  284.  
  285. ALTER TABLE public.cdr_rpt
  286. OWNER to zzz;
  287.  
  288. -- Index: cdr_rpt_category
  289.  
  290. -- DROP INDEX public.cdr_rpt_category;
  291.  
  292. CREATE INDEX cdr_rpt_category
  293. ON public.cdr_rpt USING btree
  294. (category COLLATE pg_catalog."en_US.utf8" bpchar_pattern_ops)
  295. TABLESPACE pg_default;
  296.  
  297. -- Index: cdr_rpt_code
  298.  
  299. -- DROP INDEX public.cdr_rpt_code;
  300.  
  301. CREATE INDEX cdr_rpt_code
  302. ON public.cdr_rpt USING btree
  303. (code)
  304. TABLESPACE pg_default;
  305.  
  306. -- Index: cdr_rpt_cat
  307.  
  308. -- DROP INDEX public.cdr_rpt_cat;
  309.  
  310. CREATE INDEX cdr_rpt_cat
  311. ON public.cdr_rpt USING btree
  312. (cat COLLATE pg_catalog."en_US.utf8" bpchar_pattern_ops)
  313. TABLESPACE pg_default;
  314.  
  315. -- Index: cdr_rpt_cut
  316.  
  317. -- DROP INDEX public.cdr_rpt_cut;
  318.  
  319. CREATE INDEX cdr_rpt_cut
  320. ON public.cdr_rpt USING btree
  321. (cut COLLATE pg_catalog."en_US.utf8" bpchar_pattern_ops)
  322. TABLESPACE pg_default;
  323.  
  324. -- Index: cdr_rpt_year
  325.  
  326. -- DROP INDEX public.cdr_rpt_year;
  327.  
  328. CREATE INDEX cdr_rpt_year
  329. ON public.cdr_rpt USING btree
  330. (year)
  331. TABLESPACE pg_default;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!