pggeodb.nancy.inra.fr/db_cefs - db_cefs on pggeodb.nancy.inra.fr |
|
Table: tr_experimenter_exp
pggeodb.nancy.inra.fr/db_cefs - db_cefs on pggeodb.nancy.inra.fr |
|
Table: tr_experimenter_exp
Schema
Owner
ychaval
Tablespace
(default)
Descriptions
Table containing the adress of the laboratories implied in pathogen detection
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
exp_id |
serial |
|
|
|
nextval('para_phy.tr_experimenter_exp_exp_id_seq'::regclass) |
ID of the experimenter |
|
|
exp_name |
text |
|
|
|
|
Names of experimenters |
|
|
exp_task |
text |
|
|
|
|
Task assume by the experimenter |
|
|
exp_email |
text |
|
|
|
|
E-mail of the experimenter |
|
|
exp_phone |
text |
|
|
|
|
Phone number of the experimenter or the lab |
|
|
exp_adress |
text |
|
|
|
|
Postal adress of the experimenter |
|
|
exp_postal_code |
text |
|
|
|
|
Postal-code of the experimenter |
|
|
exp_city |
text |
|
|
|
|
City of the experimenter |
|
|
exp_country |
text |
|
|
|
|
Country of the experimenter |
|
|
exp_lab_id |
integer |
|
|
|
|
Identifier of the hosting laboratory |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
exp_lab_id |
lab_id |
No Action |
No Action |
|
Immediate |
|
Check Constraints
There are no check constraints for table tr_experimenter_exp
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
btree |
|
exp_id |
|
|
|
Triggers
There are no triggers for table tr_experimenter_exp
Rules
There are no rules for table tr_experimenter_exp
Policies
There are no policies for table tr_experimenter_exp
Referenced
Table | Schema | Foreign Key | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|---|---|
para_exp_id |
exp_id |
No Action |
No Action |
|
Immediate |
|
||||
phy_exp_id |
exp_id |
No Action |
No Action |
|
Immediate |
|
||||
eli_exp_id |
exp_id |
No Action |
No Action |
|
Immediate |
|
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
27 |
Pages |
1 |
System |
|
Temporary |
|
With OID |
|
Definition
exp_id SERIAL,
exp_name TEXT,
exp_task TEXT,
exp_email TEXT,
exp_phone TEXT,
exp_adress TEXT,
exp_postal_code TEXT,
exp_city TEXT,
exp_country TEXT,
exp_lab_id INTEGER NOT NULL,
CONSTRAINT tr_experimenter_exp_pkey PRIMARY KEY(exp_id),
CONSTRAINT tr_experimenter_exp_fkey1 FOREIGN KEY (exp_lab_id)
REFERENCES para_phy.tr_laboratory_lab(lab_id)
MATCH FULL
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE
)
WITH (oids = false);
COMMENT ON TABLE para_phy.tr_experimenter_exp
IS 'Table containing the adress of the laboratories implied in pathogen detection';
COMMENT ON COLUMN para_phy.tr_experimenter_exp.exp_id
IS 'ID of the experimenter';
COMMENT ON COLUMN para_phy.tr_experimenter_exp.exp_name
IS 'Names of experimenters';
COMMENT ON COLUMN para_phy.tr_experimenter_exp.exp_task
IS 'Task assume by the experimenter';
COMMENT ON COLUMN para_phy.tr_experimenter_exp.exp_email
IS 'E-mail of the experimenter';
COMMENT ON COLUMN para_phy.tr_experimenter_exp.exp_phone
IS 'Phone number of the experimenter or the lab';
COMMENT ON COLUMN para_phy.tr_experimenter_exp.exp_adress
IS 'Postal adress of the experimenter';
COMMENT ON COLUMN para_phy.tr_experimenter_exp.exp_postal_code
IS 'Postal-code of the experimenter';
COMMENT ON COLUMN para_phy.tr_experimenter_exp.exp_city
IS 'City of the experimenter';
COMMENT ON COLUMN para_phy.tr_experimenter_exp.exp_country
IS 'Country of the experimenter';
COMMENT ON COLUMN para_phy.tr_experimenter_exp.exp_lab_id
IS 'Identifier of the hosting laboratory';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 13/03/2014 13:23 |
|