pggeodb.nancy.inra.fr/db_cefs - db_cefs on pggeodb.nancy.inra.fr |
|
Table: tr_variable_measured_var
pggeodb.nancy.inra.fr/db_cefs - db_cefs on pggeodb.nancy.inra.fr |
|
Table: tr_variable_measured_var
Schema
Owner
ychaval
Tablespace
(default)
Descriptions
Table containing details on the measurements units
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
var_id |
serial |
|
|
|
nextval('para_phy.tr_variable_measured_var_var_id_seq'::regclass) |
ID of the variable |
|
|
var_name_long |
text |
|
|
|
|
Detailed name of the trait measured |
|
|
var_name_short |
text |
|
|
|
|
Name of the trait as defined in the laboratories files |
|
|
var_domain |
text |
|
|
|
|
Domain of the trait measured |
|
|
var_unit |
text |
|
|
|
|
Unit of the measurement |
|
|
var_generalremarks |
text |
|
|
|
|
Remark about the variable |
Foreign Keys
There are no foreign keys for table tr_variable_measured_var
Check Constraints
There are no check constraints for table tr_variable_measured_var
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
btree |
|
var_id |
|
|
|
|
btree |
|
var_name_long |
|
|
|
Triggers
There are no triggers for table tr_variable_measured_var
Rules
There are no rules for table tr_variable_measured_var
Policies
There are no policies for table tr_variable_measured_var
Referenced
Table | Schema | Foreign Key | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|---|---|
para_var_id |
var_id |
No Action |
No Action |
|
Immediate |
|
||||
phy_var_id |
var_id |
No Action |
No Action |
|
Immediate |
|
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
170 |
Pages |
3 |
System |
|
Temporary |
|
With OID |
|
Definition
var_id SERIAL,
var_name_long TEXT,
var_name_short TEXT,
var_domain TEXT,
var_unit TEXT,
var_generalremarks TEXT,
CONSTRAINT tr_variable_measured_var_pkey PRIMARY KEY(var_id),
CONSTRAINT tr_variable_measured_var_unique UNIQUE(var_name_long)
)
WITH (oids = false);
COMMENT ON TABLE para_phy.tr_variable_measured_var
IS 'Table containing details on the measurements units';
COMMENT ON COLUMN para_phy.tr_variable_measured_var.var_id
IS 'ID of the variable';
COMMENT ON COLUMN para_phy.tr_variable_measured_var.var_name_long
IS 'Detailed name of the trait measured';
COMMENT ON COLUMN para_phy.tr_variable_measured_var.var_name_short
IS 'Name of the trait as defined in the laboratories files';
COMMENT ON COLUMN para_phy.tr_variable_measured_var.var_domain
IS 'Domain of the trait measured';
COMMENT ON COLUMN para_phy.tr_variable_measured_var.var_unit
IS 'Unit of the measurement';
COMMENT ON COLUMN para_phy.tr_variable_measured_var.var_generalremarks
IS 'Remark about the variable';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 13/03/2014 13:23 |
|