pggeodb.nancy.inra.fr/db_cefs - db_cefs on pggeodb.nancy.inra.fr |
|
Table: tr_analysis_pcr_pcr
pggeodb.nancy.inra.fr/db_cefs - db_cefs on pggeodb.nancy.inra.fr |
|
Table: tr_analysis_pcr_pcr
Schema
Owner
ychaval
Tablespace
(default)
Descriptions
Table containing the PCR test experimental conditions used for pathogen detection
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
pcr_id |
serial |
|
|
|
nextval('para_phy.tr_analysis_pcr_pcr_pcr_id_seq'::regclass) |
Analysis laboratory id |
|
|
pcr_analysis_type |
text |
|
|
|
|
More explicit description of the PCR test |
|
|
pcr_gene_amplified |
text |
|
|
|
|
Gene concerned by amplification |
|
|
pcr_forward |
text |
|
|
|
|
Nucleotidic sequence of the forward primer |
|
|
pcr_reverse |
text |
|
|
|
|
Nucleotidic sequence of the reverse primer |
|
|
pcr_pre_denaturation_temp |
integer |
|
|
|
|
Pre-denaturation temperature |
|
|
pcr_pre_denaturation_time |
text |
|
|
|
|
Pre-denaturation time |
|
|
pcr_denaturation_temp |
integer |
|
|
|
|
Denaturation temperature |
|
|
pcr_denaturation_time |
text |
|
|
|
|
Denaturation time |
|
|
pcr_annealing_temp |
integer |
|
|
|
|
Annealing temperature |
|
|
pcr_annealing_time |
text |
|
|
|
|
Annealing time |
|
|
pcr_extension_temp |
integer |
|
|
|
|
Extension temperature |
|
|
pcr_extension_time |
text |
|
|
|
|
Extension time |
|
|
pcr_cycles_number |
integer |
|
|
|
|
Number of amplification cycles |
Foreign Keys
There are no foreign keys for table tr_analysis_pcr_pcr
Check Constraints
There are no check constraints for table tr_analysis_pcr_pcr
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
btree |
|
pcr_analysis_type |
|
|
|
|
btree |
|
pcr_id |
|
|
|
Triggers
There are no triggers for table tr_analysis_pcr_pcr
Rules
There are no rules for table tr_analysis_pcr_pcr
Policies
There are no policies for table tr_analysis_pcr_pcr
Referenced
Table | Schema | Foreign Key | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|---|---|
para_pcr_id |
pcr_id |
No Action |
No Action |
|
Immediate |
|
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
14 |
Pages |
1 |
System |
|
Temporary |
|
With OID |
|
Definition
pcr_id SERIAL,
pcr_analysis_type TEXT NOT NULL,
pcr_gene_amplified TEXT,
pcr_forward TEXT,
pcr_reverse TEXT,
pcr_pre_denaturation_temp INTEGER,
pcr_pre_denaturation_time TEXT,
pcr_denaturation_temp INTEGER,
pcr_denaturation_time TEXT,
pcr_annealing_temp INTEGER,
pcr_annealing_time TEXT,
pcr_extension_temp INTEGER,
pcr_extension_time TEXT,
pcr_cycles_number INTEGER,
CONSTRAINT tr_analysis_pcr_pcr_pcr_analysis_type_key UNIQUE(pcr_analysis_type),
CONSTRAINT tr_analysis_pcr_pcr_pkey PRIMARY KEY(pcr_id)
)
WITH (oids = false);
COMMENT ON TABLE para_phy.tr_analysis_pcr_pcr
IS 'Table containing the PCR test experimental conditions used for pathogen detection';
COMMENT ON COLUMN para_phy.tr_analysis_pcr_pcr.pcr_id
IS 'Analysis laboratory id';
COMMENT ON COLUMN para_phy.tr_analysis_pcr_pcr.pcr_analysis_type
IS 'More explicit description of the PCR test';
COMMENT ON COLUMN para_phy.tr_analysis_pcr_pcr.pcr_gene_amplified
IS 'Gene concerned by amplification';
COMMENT ON COLUMN para_phy.tr_analysis_pcr_pcr.pcr_forward
IS 'Nucleotidic sequence of the forward primer';
COMMENT ON COLUMN para_phy.tr_analysis_pcr_pcr.pcr_reverse
IS 'Nucleotidic sequence of the reverse primer';
COMMENT ON COLUMN para_phy.tr_analysis_pcr_pcr.pcr_pre_denaturation_temp
IS 'Pre-denaturation temperature';
COMMENT ON COLUMN para_phy.tr_analysis_pcr_pcr.pcr_pre_denaturation_time
IS 'Pre-denaturation time';
COMMENT ON COLUMN para_phy.tr_analysis_pcr_pcr.pcr_denaturation_temp
IS 'Denaturation temperature';
COMMENT ON COLUMN para_phy.tr_analysis_pcr_pcr.pcr_denaturation_time
IS 'Denaturation time';
COMMENT ON COLUMN para_phy.tr_analysis_pcr_pcr.pcr_annealing_temp
IS 'Annealing temperature';
COMMENT ON COLUMN para_phy.tr_analysis_pcr_pcr.pcr_annealing_time
IS 'Annealing time';
COMMENT ON COLUMN para_phy.tr_analysis_pcr_pcr.pcr_extension_temp
IS 'Extension temperature';
COMMENT ON COLUMN para_phy.tr_analysis_pcr_pcr.pcr_extension_time
IS 'Extension time';
COMMENT ON COLUMN para_phy.tr_analysis_pcr_pcr.pcr_cycles_number
IS 'Number of amplification cycles';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 13/03/2014 13:23 |
|