Also bigint instead of varchar on processed_params_id


On Wed, Apr 9, 2014 at 8:50 AM, Daniel McDonald <notifications@github.com>wrote:

> In qiita_db/qiita-db.sql:
>
> > +CREATE TABLE qiita.preprocessed_data (
> > +	preprocessed_data_id bigserial  NOT NULL,
> > +	raw_data_id          integer  ,
> > +	filepath             varchar  NOT NULL,
> > +	preprocessed_params_id bigint  NOT NULL,
> > +	CONSTRAINT pk_preprocessed_data PRIMARY KEY ( preprocessed_data_id ),
> > +	CONSTRAINT fk_preprocessed_data_raw_data FOREIGN KEY ( raw_data_id ) REFERENCES qiita.raw_data( raw_data_id )
> > + );
> > +
> > +CREATE INDEX idx_preprocessed_data ON qiita.preprocessed_data ( raw_data_id );
> > +
> > +CREATE TABLE qiita.processed_data (
> > +	processed_data_id    bigserial  NOT NULL,
> > +	preprocessed_data_id bigint  NOT NULL,
> > +	processed_data_filepath varchar  NOT NULL,
> > +	processed_params_id  varchar  NOT NULL,
>
> should this have a fk?
>
> --
> Reply to this email directly or view it on GitHub<https://github.com/biocore/qiita/pull/32/files#r11439174>
> .
>