Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE slip
- (
- id integer NOT NULL,
- task_id integer,
- user_id integer,
- where_id integer,
- how_id integer,
- rate_multiplier_id integer,
- updated_by_id integer,
- created_by_id integer,
- start timestamp(0) without time zone DEFAULT NULL::timestamp without time zone,
- stop timestamp(0) without time zone DEFAULT NULL::timestamp without time zone,
- rate numeric(10,2) NOT NULL,
- comment text NOT NULL,
- group_work boolean NOT NULL,
- search tsvector, -- (DC2Type:tsvector)
- updated timestamp(0) without time zone DEFAULT NULL::timestamp without time zone,
- created timestamp(0) without time zone DEFAULT NULL::timestamp without time zone,
- deleted timestamp(0) without time zone DEFAULT NULL::timestamp without time zone,
- CONSTRAINT slip_pkey PRIMARY KEY (id ),
- CONSTRAINT fk_fd3943f821ef480f FOREIGN KEY (how_id)
- REFERENCES slip_how (id) MATCH SIMPLE
- ON UPDATE NO ACTION ON DELETE NO ACTION,
- CONSTRAINT fk_fd3943f83256e8eb FOREIGN KEY (rate_multiplier_id)
- REFERENCES rate_multiplier (id) MATCH SIMPLE
- ON UPDATE NO ACTION ON DELETE NO ACTION,
- CONSTRAINT fk_fd3943f8353d7337 FOREIGN KEY (where_id)
- REFERENCES slip_where (id) MATCH SIMPLE
- ON UPDATE NO ACTION ON DELETE NO ACTION,
- CONSTRAINT fk_fd3943f8896dbbde FOREIGN KEY (updated_by_id)
- REFERENCES fos_user (id) MATCH SIMPLE
- ON UPDATE NO ACTION ON DELETE NO ACTION,
- CONSTRAINT fk_fd3943f88db60186 FOREIGN KEY (task_id)
- REFERENCES task (id) MATCH SIMPLE
- ON UPDATE NO ACTION ON DELETE NO ACTION,
- CONSTRAINT fk_fd3943f8a76ed395 FOREIGN KEY (user_id)
- REFERENCES fos_user (id) MATCH SIMPLE
- ON UPDATE NO ACTION ON DELETE NO ACTION,
- CONSTRAINT fk_fd3943f8b03a8386 FOREIGN KEY (created_by_id)
- REFERENCES fos_user (id) MATCH SIMPLE
- ON UPDATE NO ACTION ON DELETE NO ACTION
- )
- WITH (
- OIDS=FALSE
- );
- ALTER TABLE slip
- OWNER TO sd4;
- COMMENT ON COLUMN slip.search IS '(DC2Type:tsvector)';
- -- Index: idx_fd3943f821ef480f
- -- DROP INDEX idx_fd3943f821ef480f;
- CREATE INDEX idx_fd3943f821ef480f
- ON slip
- USING btree
- (how_id );
- -- Index: idx_fd3943f83256e8eb
- -- DROP INDEX idx_fd3943f83256e8eb;
- CREATE INDEX idx_fd3943f83256e8eb
- ON slip
- USING btree
- (rate_multiplier_id );
- -- Index: idx_fd3943f8353d7337
- -- DROP INDEX idx_fd3943f8353d7337;
- CREATE INDEX idx_fd3943f8353d7337
- ON slip
- USING btree
- (where_id );
- -- Index: idx_fd3943f8896dbbde
- -- DROP INDEX idx_fd3943f8896dbbde;
- CREATE INDEX idx_fd3943f8896dbbde
- ON slip
- USING btree
- (updated_by_id );
- -- Index: idx_fd3943f88db60186
- -- DROP INDEX idx_fd3943f88db60186;
- CREATE INDEX idx_fd3943f88db60186
- ON slip
- USING btree
- (task_id );
- -- Index: idx_fd3943f89f79558f
- -- DROP INDEX idx_fd3943f89f79558f;
- CREATE INDEX idx_fd3943f89f79558f
- ON slip
- USING btree
- (start );
- -- Index: idx_fd3943f8a76ed395
- -- DROP INDEX idx_fd3943f8a76ed395;
- CREATE INDEX idx_fd3943f8a76ed395
- ON slip
- USING btree
- (user_id );
- -- Index: idx_fd3943f8b03a8386
- -- DROP INDEX idx_fd3943f8b03a8386;
- CREATE INDEX idx_fd3943f8b03a8386
- ON slip
- USING btree
- (created_by_id );
- -- Index: idx_fd3943f8b23db7b8
- -- DROP INDEX idx_fd3943f8b23db7b8;
- CREATE INDEX idx_fd3943f8b23db7b8
- ON slip
- USING btree
- (created );
- -- Index: idx_fd3943f8b95616b6
- -- DROP INDEX idx_fd3943f8b95616b6;
- CREATE INDEX idx_fd3943f8b95616b6
- ON slip
- USING btree
- (stop );
- -- Index: idx_fd3943f8c69b96f7
- -- DROP INDEX idx_fd3943f8c69b96f7;
- CREATE INDEX idx_fd3943f8c69b96f7
- ON slip
- USING btree
- (updated );
- -- Index: idx_fd3943f8eb3b4e33
- -- DROP INDEX idx_fd3943f8eb3b4e33;
- CREATE INDEX idx_fd3943f8eb3b4e33
- ON slip
- USING btree
- (deleted );
Advertisement
Add Comment
Please, Sign In to add comment