Guest User

slip table and indexes

a guest
Apr 2nd, 2013
191
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.34 KB | None | 0 0
  1. CREATE TABLE slip
  2. (
  3. id integer NOT NULL,
  4. task_id integer,
  5. user_id integer,
  6. where_id integer,
  7. how_id integer,
  8. rate_multiplier_id integer,
  9. updated_by_id integer,
  10. created_by_id integer,
  11. start timestamp(0) without time zone DEFAULT NULL::timestamp without time zone,
  12. stop timestamp(0) without time zone DEFAULT NULL::timestamp without time zone,
  13. rate numeric(10,2) NOT NULL,
  14. comment text NOT NULL,
  15. group_work boolean NOT NULL,
  16. search tsvector, -- (DC2Type:tsvector)
  17. updated timestamp(0) without time zone DEFAULT NULL::timestamp without time zone,
  18. created timestamp(0) without time zone DEFAULT NULL::timestamp without time zone,
  19. deleted timestamp(0) without time zone DEFAULT NULL::timestamp without time zone,
  20. CONSTRAINT slip_pkey PRIMARY KEY (id ),
  21. CONSTRAINT fk_fd3943f821ef480f FOREIGN KEY (how_id)
  22. REFERENCES slip_how (id) MATCH SIMPLE
  23. ON UPDATE NO ACTION ON DELETE NO ACTION,
  24. CONSTRAINT fk_fd3943f83256e8eb FOREIGN KEY (rate_multiplier_id)
  25. REFERENCES rate_multiplier (id) MATCH SIMPLE
  26. ON UPDATE NO ACTION ON DELETE NO ACTION,
  27. CONSTRAINT fk_fd3943f8353d7337 FOREIGN KEY (where_id)
  28. REFERENCES slip_where (id) MATCH SIMPLE
  29. ON UPDATE NO ACTION ON DELETE NO ACTION,
  30. CONSTRAINT fk_fd3943f8896dbbde FOREIGN KEY (updated_by_id)
  31. REFERENCES fos_user (id) MATCH SIMPLE
  32. ON UPDATE NO ACTION ON DELETE NO ACTION,
  33. CONSTRAINT fk_fd3943f88db60186 FOREIGN KEY (task_id)
  34. REFERENCES task (id) MATCH SIMPLE
  35. ON UPDATE NO ACTION ON DELETE NO ACTION,
  36. CONSTRAINT fk_fd3943f8a76ed395 FOREIGN KEY (user_id)
  37. REFERENCES fos_user (id) MATCH SIMPLE
  38. ON UPDATE NO ACTION ON DELETE NO ACTION,
  39. CONSTRAINT fk_fd3943f8b03a8386 FOREIGN KEY (created_by_id)
  40. REFERENCES fos_user (id) MATCH SIMPLE
  41. ON UPDATE NO ACTION ON DELETE NO ACTION
  42. )
  43. WITH (
  44. OIDS=FALSE
  45. );
  46. ALTER TABLE slip
  47. OWNER TO sd4;
  48. COMMENT ON COLUMN slip.search IS '(DC2Type:tsvector)';
  49.  
  50.  
  51. -- Index: idx_fd3943f821ef480f
  52.  
  53. -- DROP INDEX idx_fd3943f821ef480f;
  54.  
  55. CREATE INDEX idx_fd3943f821ef480f
  56. ON slip
  57. USING btree
  58. (how_id );
  59.  
  60. -- Index: idx_fd3943f83256e8eb
  61.  
  62. -- DROP INDEX idx_fd3943f83256e8eb;
  63.  
  64. CREATE INDEX idx_fd3943f83256e8eb
  65. ON slip
  66. USING btree
  67. (rate_multiplier_id );
  68.  
  69. -- Index: idx_fd3943f8353d7337
  70.  
  71. -- DROP INDEX idx_fd3943f8353d7337;
  72.  
  73. CREATE INDEX idx_fd3943f8353d7337
  74. ON slip
  75. USING btree
  76. (where_id );
  77.  
  78. -- Index: idx_fd3943f8896dbbde
  79.  
  80. -- DROP INDEX idx_fd3943f8896dbbde;
  81.  
  82. CREATE INDEX idx_fd3943f8896dbbde
  83. ON slip
  84. USING btree
  85. (updated_by_id );
  86.  
  87. -- Index: idx_fd3943f88db60186
  88.  
  89. -- DROP INDEX idx_fd3943f88db60186;
  90.  
  91. CREATE INDEX idx_fd3943f88db60186
  92. ON slip
  93. USING btree
  94. (task_id );
  95.  
  96. -- Index: idx_fd3943f89f79558f
  97.  
  98. -- DROP INDEX idx_fd3943f89f79558f;
  99.  
  100. CREATE INDEX idx_fd3943f89f79558f
  101. ON slip
  102. USING btree
  103. (start );
  104.  
  105. -- Index: idx_fd3943f8a76ed395
  106.  
  107. -- DROP INDEX idx_fd3943f8a76ed395;
  108.  
  109. CREATE INDEX idx_fd3943f8a76ed395
  110. ON slip
  111. USING btree
  112. (user_id );
  113.  
  114. -- Index: idx_fd3943f8b03a8386
  115.  
  116. -- DROP INDEX idx_fd3943f8b03a8386;
  117.  
  118. CREATE INDEX idx_fd3943f8b03a8386
  119. ON slip
  120. USING btree
  121. (created_by_id );
  122.  
  123. -- Index: idx_fd3943f8b23db7b8
  124.  
  125. -- DROP INDEX idx_fd3943f8b23db7b8;
  126.  
  127. CREATE INDEX idx_fd3943f8b23db7b8
  128. ON slip
  129. USING btree
  130. (created );
  131.  
  132. -- Index: idx_fd3943f8b95616b6
  133.  
  134. -- DROP INDEX idx_fd3943f8b95616b6;
  135.  
  136. CREATE INDEX idx_fd3943f8b95616b6
  137. ON slip
  138. USING btree
  139. (stop );
  140.  
  141. -- Index: idx_fd3943f8c69b96f7
  142.  
  143. -- DROP INDEX idx_fd3943f8c69b96f7;
  144.  
  145. CREATE INDEX idx_fd3943f8c69b96f7
  146. ON slip
  147. USING btree
  148. (updated );
  149.  
  150. -- Index: idx_fd3943f8eb3b4e33
  151.  
  152. -- DROP INDEX idx_fd3943f8eb3b4e33;
  153.  
  154. CREATE INDEX idx_fd3943f8eb3b4e33
  155. ON slip
  156. USING btree
  157. (deleted );
Advertisement
Add Comment
Please, Sign In to add comment