pggeodb.nancy.inra.fr/db_cefs - db_cefs on pggeodb.nancy.inra.fr |
|
Table: t_physiology_phy
pggeodb.nancy.inra.fr/db_cefs - db_cefs on pggeodb.nancy.inra.fr |
|
Table: t_physiology_phy
Schema
Owner
ychaval
Tablespace
(default)
Descriptions
Table containing the physiologic data of the animals
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
phy_id |
serial |
|
|
|
nextval('para_phy.t_physiology_phy_phy_id_seq'::regclass) |
Unique ID for physiological information |
|
|
phy_human_id |
text |
|
|
|
|
Unique human identifier |
|
|
phy_ani_id |
integer |
|
|
|
|
Unique individual automatic ID |
|
|
phy_laboriginid |
text |
|
|
|
|
Sample ID and/or remote laboratory id |
|
|
phy_daysampling |
date |
|
|
|
|
Dsampling date |
|
|
phy_var_id |
integer |
|
|
|
|
Unit of the result |
|
|
phy_exp_id |
integer |
|
|
|
|
Analysis laboratory ID |
|
|
phy_res |
text |
|
|
|
|
Test result |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
phy_var_id |
var_id |
No Action |
No Action |
|
Immediate |
|
||
phy_exp_id |
exp_id |
No Action |
No Action |
|
Immediate |
|
Check Constraints
There are no check constraints for table t_physiology_phy
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
btree |
|
phy_id |
|
|
|
|
btree |
|
phy_ani_id, phy_daysampling, phy_var_id, phy_laboriginid |
|
|
|
Triggers
There are no triggers for table t_physiology_phy
Rules
There are no rules for table t_physiology_phy
Policies
There are no policies for table t_physiology_phy
Referenced
There are no tables referenced by table t_physiology_phy
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
13413 |
Pages |
198 |
System |
|
Temporary |
|
With OID |
|
Definition
phy_id SERIAL,
phy_human_id TEXT,
phy_ani_id INTEGER,
phy_laboriginid TEXT NOT NULL,
phy_daysampling DATE NOT NULL,
phy_var_id INTEGER NOT NULL,
phy_exp_id INTEGER,
phy_res TEXT,
CONSTRAINT t_physiology_phy_pkey PRIMARY KEY(phy_id),
CONSTRAINT t_physiology_phy_unique UNIQUE(phy_ani_id, phy_daysampling, phy_var_id, phy_laboriginid),
CONSTRAINT t_physiology_phy__fkey2 FOREIGN KEY (phy_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_physiology_phy__fkey3 FOREIGN KEY (phy_exp_id)
REFERENCES para_phy.tr_experimenter_exp(exp_id)
MATCH FULL
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE
)
WITH (oids = false);
COMMENT ON TABLE para_phy.t_physiology_phy
IS 'Table containing the physiologic data of the animals';
COMMENT ON COLUMN para_phy.t_physiology_phy.phy_id
IS 'Unique ID for physiological information';
COMMENT ON COLUMN para_phy.t_physiology_phy.phy_human_id
IS 'Unique human identifier';
COMMENT ON COLUMN para_phy.t_physiology_phy.phy_ani_id
IS 'Unique individual automatic ID';
COMMENT ON COLUMN para_phy.t_physiology_phy.phy_laboriginid
IS 'Sample ID and/or remote laboratory id';
COMMENT ON COLUMN para_phy.t_physiology_phy.phy_daysampling
IS 'Dsampling date';
COMMENT ON COLUMN para_phy.t_physiology_phy.phy_var_id
IS 'Unit of the result';
COMMENT ON COLUMN para_phy.t_physiology_phy.phy_exp_id
IS 'Analysis laboratory ID';
COMMENT ON COLUMN para_phy.t_physiology_phy.phy_res
IS 'Test result';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 13/03/2014 13:23 |
|