Schema
Owner
ychaval
Tablespace
(default)
Descriptions
Table containing the Elisa test experimental conditions used for pathogen detection
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
---|---|---|---|---|---|---|---|---|
|
eli_id |
serial |
|
nextval('para_phy.tr_analysis_elisa_eli_eli_id_seq'::regclass) |
Unique individual ID |
|||
|
|
eli_human_id |
text |
|
|
|
|
Human identifier |
|
eli_exp_id |
integer |
|
|
|
Analysis experimenter id |
||
|
|
eli_year_sampling |
text |
|
|
|
The year when the sample was collected |
|
|
|
eli_year_analysis |
text |
|
|
|
The year when analysis was performed |
|
|
eli_pat_id |
integer |
|
|
|
|
Pathogen ID |
|
|
|
eli_analysis_type |
text |
|
|
|
|
Type of kit used for analysis |
|
|
eli_analysis_kit |
text |
|
|
|
|
Kit used for analysis |
|
|
eli_analysis_trade_name |
text |
|
|
|
|
Trade mark of the kit used for analysis |
|
|
eli_sample_dillution |
text |
|
|
|
|
Experimental conditions: sample dillution |
|
|
eli_well_antigen |
text |
|
|
|
|
Is the antigen present in well |
|
|
eli_cut_off_negative_comparative_sign |
text |
|
|
|
|
Comparative sign for negative cut-off |
|
|
eli_cut_off_negative_value |
text |
|
|
|
|
The cut off negative value |
|
|
eli_cut_off_positive_comparive_sign |
text |
|
|
|
|
Comparative sign for positive cut-off |
|
|
eli_cut_off_positive_value |
text |
|
|
|
|
The cut off positive value |
|
|
eli_analysis_validity |
text |
|
|
|
|
Is the test valid or not |
|
|
eli_optic_density_controlpos_odcpos |
double precision |
|
|
|
|
Optic deviation value of the positive control |
|
|
eli_optic_density_controlneg_odcneg |
double precision |
|
|
|
|
Optic deviation value of the negative control |
|
|
eli_calcul_antibody_reconnaissance_levels_arl |
text |
|
|
|
|
Formula used to calculate the antibody reconnaissance level |
|
|
eli_remark |
text |
|
|
|
|
A remark about the Elisa test |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
---|---|---|---|---|---|---|---|---|
eli_exp_id |
exp_id |
No Action |
No Action |
|
Immediate |
|
||
eli_pat_id |
pat_id |
No Action |
No Action |
|
Immediate |
|
Check Constraints
There are no check constraints for table tr_analysis_elisa_eli
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
---|---|---|---|---|---|---|
btree |
|
eli_id |
|
Triggers
There are no triggers for table tr_analysis_elisa_eli
Rules
There are no rules for table tr_analysis_elisa_eli
Policies
There are no policies for table tr_analysis_elisa_eli
Referenced
Table | Schema | Foreign Key | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
---|---|---|---|---|---|---|---|---|---|---|
para_eli_id |
eli_id |
No Action |
No Action |
|
Immediate |
|
Properties
Property | Value |
---|---|
Inherited From |
|
Rows |
77 |
Pages |
4 |
System |
|
Temporary |
|
With OID |
|
Definition
CREATE TABLE para_phy.tr_analysis_elisa_eli (
eli_id SERIAL,
eli_human_id TEXT,
eli_exp_id INTEGER NOT NULL,
eli_year_sampling TEXT NOT NULL,
eli_year_analysis TEXT NOT NULL,
eli_pat_id INTEGER,
eli_analysis_type TEXT,
eli_analysis_kit TEXT,
eli_analysis_trade_name TEXT,
eli_sample_dillution TEXT,
eli_well_antigen TEXT,
eli_cut_off_negative_comparative_sign TEXT,
eli_cut_off_negative_value TEXT,
eli_cut_off_positive_comparive_sign TEXT,
eli_cut_off_positive_value TEXT,
eli_analysis_validity TEXT,
eli_optic_density_controlpos_odcpos DOUBLE PRECISION,
eli_optic_density_controlneg_odcneg DOUBLE PRECISION,
eli_calcul_antispan_reconnaissance_levels_arl TEXT,
eli_remark TEXT,
CONSTRAINT tr_analysis_elisa_eli_pkey PRIMARY KEY(eli_id),
CONSTRAINT tr_analysis_elisa_eli_fkey1 FOREIGN KEY (eli_exp_id)
REFERENCES para_phy.tr_experimenter_exp(exp_id)
MATCH FULL
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT tr_analysis_elisa_eli_fkey2 FOREIGN KEY (eli_pat_id)
REFERENCES para_phy.tr_pathogen_pat(pat_id)
MATCH FULL
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE
)
WITH (oids = false);
COMMENT ON TABLE para_phy.tr_analysis_elisa_eli
IS 'Table containing the Elisa test experimental conditions used for pathogen detection';
COMMENT ON COLUMN para_phy.tr_analysis_elisa_eli.eli_id
IS 'Unique individual ID';
COMMENT ON COLUMN para_phy.tr_analysis_elisa_eli.eli_human_id
IS 'Human identifier';
COMMENT ON COLUMN para_phy.tr_analysis_elisa_eli.eli_exp_id
IS 'Analysis experimenter id';
COMMENT ON COLUMN para_phy.tr_analysis_elisa_eli.eli_year_sampling
IS 'The year when the sample was collected';
COMMENT ON COLUMN para_phy.tr_analysis_elisa_eli.eli_year_analysis
IS 'The year when analysis was performed';
COMMENT ON COLUMN para_phy.tr_analysis_elisa_eli.eli_pat_id
IS 'Pathogen ID';
COMMENT ON COLUMN para_phy.tr_analysis_elisa_eli.eli_analysis_type
IS 'Type of kit used for analysis';
COMMENT ON COLUMN para_phy.tr_analysis_elisa_eli.eli_analysis_kit
IS 'Kit used for analysis';
COMMENT ON COLUMN para_phy.tr_analysis_elisa_eli.eli_analysis_trade_name
IS 'Trade mark of the kit used for analysis';
COMMENT ON COLUMN para_phy.tr_analysis_elisa_eli.eli_sample_dillution
IS 'Experimental conditions: sample dillution';
COMMENT ON COLUMN para_phy.tr_analysis_elisa_eli.eli_well_antigen
IS 'Is the antigen present in well';
COMMENT ON COLUMN para_phy.tr_analysis_elisa_eli.eli_cut_off_negative_comparative_sign
IS 'Comparative sign for negative cut-off';
COMMENT ON COLUMN para_phy.tr_analysis_elisa_eli.eli_cut_off_negative_value
IS 'The cut off negative value';
COMMENT ON COLUMN para_phy.tr_analysis_elisa_eli.eli_cut_off_positive_comparive_sign
IS 'Comparative sign for positive cut-off';
COMMENT ON COLUMN para_phy.tr_analysis_elisa_eli.eli_cut_off_positive_value
IS 'The cut off positive value';
COMMENT ON COLUMN para_phy.tr_analysis_elisa_eli.eli_analysis_validity
IS 'Is the test valid or not';
COMMENT ON COLUMN para_phy.tr_analysis_elisa_eli.eli_optic_density_controlpos_odcpos
IS 'Optic deviation value of the positive control';
COMMENT ON COLUMN para_phy.tr_analysis_elisa_eli.eli_optic_density_controlneg_odcneg
IS 'Optic deviation value of the negative control';
COMMENT ON COLUMN para_phy.tr_analysis_elisa_eli.eli_calcul_antispan_reconnaissance_levels_arl
IS 'Formula used to calculate the antispan reconnaissance level';
COMMENT ON COLUMN para_phy.tr_analysis_elisa_eli.eli_remark
IS 'A remark about the Elisa test';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 13/03/2014 13:23 |