Also, bigint instead of integer


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

> In qiita_db/qiita-db.sql:
>
> > +
> > +COMMENT ON TABLE qiita.raw_data_prep_columns IS 'Holds the columns available for a given raw data prep';
> > +
> > +CREATE TABLE qiita.relationship_type (
> > +	relationship_type_id bigserial  NOT NULL,
> > +	relationship_type    varchar(128)  ,
> > +	CONSTRAINT pk_relationship_type PRIMARY KEY ( relationship_type_id )
> > + );
> > +
> > +CREATE TABLE qiita.required_prep_info (
> > +	raw_data_id          bigserial  NOT NULL,
> > +	center_name          varchar  NOT NULL,
> > +	center_project_name  varchar  NOT NULL,
> > +	ebi_submission_accession varchar  ,
> > +	ebi_study_accession  varchar  ,
> > +	emp_status_id        integer  ,
>
> shouldn't this be a foreign key?
>
> --
> Reply to this email directly or view it on GitHub<https://github.com/biocore/qiita/pull/32/files#r11438762>
> .
>