pggeodb.nancy.inra.fr/db_cefs - db_cefs on pggeodb.nancy.inra.fr

Table: t_parasitology_para

Schema

para_phy

Owner

ychaval

Tablespace

(default)

Descriptions

Table containing the parasitologic data of the animals

Fields

Foreign Keys

Check Constraints

There are no check constraints for table t_parasitology_para

Indices

Triggers

There are no triggers for table t_parasitology_para

Rules

There are no rules for table t_parasitology_para

Policies

There are no policies for table t_parasitology_para

Referenced

There are no tables referenced by table t_parasitology_para

Properties

Definition

CREATE TABLE para_phy.t_parasitology_para (
 para_id SERIAL,
 para_human_id TEXT,
 para_ani_id INTEGER,
 para_laboriginid TEXT NOT NULL,
 para_daysampling DATE NOT NULL,
 para_exp_id INTEGER,
 para_var_id INTEGER NOT NULL,
 para_pat_id INTEGER NOT NULL,
 para_res TEXT,
 para_eli_id INTEGER,
 para_pcr_id INTEGER,
 para_cnt_id INTEGER,
 CONSTRAINT t_parasitology_para_pkey PRIMARY KEY(para_id),
 CONSTRAINT t_parasitology_para_unique UNIQUE(para_ani_id, para_laboriginid, para_daysampling, para_pat_id, para_var_id, para_eli_id, para_pcr_id, para_cnt_id),
 CONSTRAINT t_parasitology_para_fkey2 FOREIGN KEY (para_exp_id)
   REFERENCES para_phy.tr_experimenter_exp(exp_id)
   MATCH FULL
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT t_parasitology_para_fkey3 FOREIGN KEY (para_var_id)
   REFERENCES para_phy.tr_variable_measured_var(var_id)
   MATCH FULL
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT t_parasitology_para_fkey4 FOREIGN KEY (para_pat_id)
   REFERENCES para_phy.tr_pathogen_pat(pat_id)
   MATCH FULL
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT t_parasitology_para_fkey5 FOREIGN KEY (para_eli_id)
   REFERENCES para_phy.tr_analysis_elisa_eli(eli_id)
   MATCH FULL
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT t_parasitology_para_fkey6 FOREIGN KEY (para_pcr_id)
   REFERENCES para_phy.tr_analysis_pcr_pcr(pcr_id)
   MATCH FULL
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT t_parasitology_para_fkey7 FOREIGN KEY (para_cnt_id)
   REFERENCES para_phy.tr_analysis_counting_cnt(cnt_id)
   MATCH FULL
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE
)
WITH (oids = false);

COMMENT ON TABLE para_phy.t_parasitology_para
IS 'Table containing the parasitologic data of the animals';

COMMENT ON COLUMN para_phy.t_parasitology_para.para_id
IS 'Unique ID for parasitological information';

COMMENT ON COLUMN para_phy.t_parasitology_para.para_human_id
IS 'Unique human identifier';

COMMENT ON COLUMN para_phy.t_parasitology_para.para_ani_id
IS 'Unique individual automatic ID';

COMMENT ON COLUMN para_phy.t_parasitology_para.para_laboriginid
IS 'Sample ID and/or remote laboratory id';

COMMENT ON COLUMN para_phy.t_parasitology_para.para_daysampling
IS 'Sampling date';

COMMENT ON COLUMN para_phy.t_parasitology_para.para_exp_id
IS 'Analysis experimenter ID';

COMMENT ON COLUMN para_phy.t_parasitology_para.para_var_id
IS 'Unit of the result';

COMMENT ON COLUMN para_phy.t_parasitology_para.para_pat_id
IS 'Pathogen ID';

COMMENT ON COLUMN para_phy.t_parasitology_para.para_res
IS 'Test result';

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 13/03/2014 13:23