pggeodb.nancy.inra.fr/db_cefs - db_cefs on pggeodb.nancy.inra.fr
Previous topic Chapter index Next topic

Table: tr_laboratory_lab

 

 

Schema

para_phy

 

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

 

lab_id

serial

 

nextval('para_phy.tr_laboratory_lab_lab_id_seq'::regclass)

ID of the lab

 

 

lab_institut

text

 

 

 

 

Institute which hosts the lab

 

 

lab_institut_acronym

text

 

 

 

Acronym of the Institute which hosts the lab

 

 

lab_departement

text

 

 

 

 

Departement which the lab is belonging

 

 

lab_research_unit

text

 

 

 

 

Research unit hosted by the lab

 

 

lab_team

text

 

 

Eperimenter's team

 

 

lab_url

text

 

 

 

 

Link to the lab's web page

 

Foreign Keys

There are no foreign keys for table tr_laboratory_lab

 

Check Constraints

There are no check constraints for table tr_laboratory_lab

 

Indices

Name

Type

Function

Fields

Primary Key

Unique

Description

tr_laboratory_lab_lab_team_key

btree

 

lab_team

 

 

tr_laboratory_lab_pkey

btree

 

lab_id

 

 

Triggers

There are no triggers for table tr_laboratory_lab

 

Rules

There are no rules for table tr_laboratory_lab

 

Policies

There are no policies for table tr_laboratory_lab

 

Referenced

Table

Schema

Foreign Key

Fields

FK Table

FK Fields

Delete Action

Update Action

Deferrable

Check Time

Description

tr_experimenter_exp

para_phy

tr_experimenter_exp_fkey1

exp_lab_id

para_phy.tr_laboratory_lab

lab_id

No Action

No Action

 

Immediate

 

 

Properties

Property

Value

Inherited From

 

Rows

20

Pages

1

System

 

Temporary

 

With OID

 

 

Definition

CREATE TABLE para_phy.tr_laboratory_lab (
 lab_id SERIAL,
 lab_institut TEXT,
 lab_institut_acronym TEXT NOT NULL,
 lab_departement TEXT,
 lab_research_unit TEXT,
 lab_team TEXT NOT NULL,
 lab_url TEXT,
 CONSTRAINT tr_laboratory_lab_lab_team_key UNIQUE(lab_team),
 CONSTRAINT tr_laboratory_lab_pkey PRIMARY KEY(lab_id)
)
WITH (oids = false);

COMMENT ON TABLE para_phy.tr_laboratory_lab
IS 'Table containing the adress of the laboratories implied in pathogen detection';

COMMENT ON COLUMN para_phy.tr_laboratory_lab.lab_id
IS 'ID of the lab';

COMMENT ON COLUMN para_phy.tr_laboratory_lab.lab_institut
IS 'Institute which hosts the lab';

COMMENT ON COLUMN para_phy.tr_laboratory_lab.lab_institut_acronym
IS 'Acronym of the Institute which hosts the lab';

COMMENT ON COLUMN para_phy.tr_laboratory_lab.lab_departement
IS 'Departement which the lab is belonging';

COMMENT ON COLUMN para_phy.tr_laboratory_lab.lab_research_unit
IS 'Research unit hosted by the lab';

COMMENT ON COLUMN para_phy.tr_laboratory_lab.lab_team
IS 'Eperimenter''s team';

COMMENT ON COLUMN para_phy.tr_laboratory_lab.lab_url
IS 'Link to the lab''s web page';

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