Schema
Owner
woodseer
Tablespace
(default)
Descriptions
Table of measured, observed or calculated variables
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
---|---|---|---|---|---|---|---|---|
|
var_id |
serial |
|
nextval('tr_variable_var_var_id_seq'::regclass) |
Unique numeric identifier of the variable |
|||
|
|
var_code |
varchar(25) |
|
|
Unique variable code |
||
|
|
var_name |
varchar(50) |
|
|
|
Usual name of the variable |
|
|
|
var_description |
varchar(255) |
|
|
|
Description of the variable |
|
|
|
var_data_type |
varchar(25) |
|
|
|
|
Data type of measurements allowing controls. |
|
|
var_control |
varchar(128) |
|
|
|
|
Regulated character string allowing checks to be carried out on the measurement values in association with the mes_type information. |
Foreign Keys
There are no foreign keys for table tr_variable_var
Check Constraints
There are no check constraints for table tr_variable_var
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
---|---|---|---|---|---|---|
btree |
|
var_code |
|
The code of a variable must be unique |
||
btree |
|
var_id |
|
Triggers
There are no triggers for table tr_variable_var
Rules
There are no rules for table tr_variable_var
Policies
There are no policies for table tr_variable_var
Referenced
Table | Schema | Foreign Key | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
---|---|---|---|---|---|---|---|---|---|---|
macq_var_id |
var_id |
No Action |
No Action |
|
Immediate |
a measure must be attached to one and only one variable |
||||
mdet_var_id |
var_id |
No Action |
No Action |
|
Immediate |
a measure must be attached to one and only one variable |
||||
mobj_var_id |
var_id |
No Action |
No Action |
|
Immediate |
a measure must be attached to one and only one variable |
||||
mzon_var_id |
var_id |
No Action |
No Action |
|
Immediate |
a measure must be linked to one and only one variable |
||||
cvar_var_id |
var_id |
No Action |
No Action |
|
Immediate |
The cvar_var_id field must correspond to an existing variable |
Properties
Property | Value |
---|---|
Inherited From |
|
Rows |
220 |
Pages |
4 |
System |
|
Temporary |
|
With OID |
Definition
CREATE TABLE public.tr_variable_var (
var_id SERIAL,
var_code VARCHAR(25) NOT NULL,
var_name VARCHAR(50) NOT NULL,
var_description VARCHAR(255) NOT NULL,
var_data_type VARCHAR(25),
var_control VARCHAR(128),
CONSTRAINT c_uni_code_var UNIQUE(var_code),
CONSTRAINT tr_variable_var_pkey PRIMARY KEY(var_id)
) ;
COMMENT ON TABLE public.tr_variable_var
IS 'Table of measured, observed or calculated variables';
COMMENT ON COLUMN public.tr_variable_var.var_id
IS 'Unique numeric identifier of the variable';
COMMENT ON COLUMN public.tr_variable_var.var_code
IS 'Unique variable code';
COMMENT ON COLUMN public.tr_variable_var.var_name
IS 'Usual name of the variable';
COMMENT ON COLUMN public.tr_variable_var.var_description
IS 'Description of the variable';
COMMENT ON COLUMN public.tr_variable_var.var_data_type
IS 'Data type of measurements allowing controls.';
COMMENT ON COLUMN public.tr_variable_var.var_control
IS 'Regulated character string allowing checks to be carried out on the measurement values in association with the mes_type information.';
COMMENT ON CONSTRAINT c_uni_code_var ON public.tr_variable_var
IS 'The code of a variable must be unique';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 07/12/2018 13:23 |