pggeodb.nancy.inra.fr/db_woodseer - db_woodseer on pggeodb.nancy.inra.fr |
|
Table: tr_unit_uni
pggeodb.nancy.inra.fr/db_woodseer - db_woodseer on pggeodb.nancy.inra.fr |
|
Table: tr_unit_uni
Schema
Owner
woodseer
Tablespace
(default)
Descriptions
Table of measurement units
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
uni_id |
serial |
|
|
|
nextval('tr_unit_uni_uni_id_seq'::regclass) |
Unique numeric identifier of the unit of measure |
|
|
uni_symbol |
varchar(15) |
|
|
|
|
Symbol used to represent unit of measure (e.g. m for meter) |
|
|
uni_name |
varchar(50) |
|
|
|
|
Common name of the unit of measurement |
|
|
uni_description |
varchar(255) |
|
|
|
|
Description of the unit of measure |
|
|
uni_data_type |
varchar(255) |
|
|
|
|
Current data type in which the data expressed in the measurement unit will be provided. For example numeric for measurements expressed in meters. This optional information is used to implement consistency checks. |
Foreign Keys
There are no foreign keys for table tr_unit_uni
Check Constraints
There are no check constraints for table tr_unit_uni
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
btree |
|
uni_name |
|
|
The name of a unit must be unique |
|
btree |
|
uni_symbol |
|
|
The symbol of a unit must be unique |
|
btree |
|
uni_id |
|
|
|
Triggers
There are no triggers for table tr_unit_uni
Rules
There are no rules for table tr_unit_uni
Policies
There are no policies for table tr_unit_uni
Referenced
Table | Schema | Foreign Key | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|---|---|
macq_uni_id |
uni_id |
No Action |
No Action |
|
Immediate |
a measure can be attached to O or 1 unit |
||||
mdet_uni_id |
uni_id |
No Action |
No Action |
|
Immediate |
a measure can be attached to O or 1 unit |
||||
mobj_uni_id |
uni_id |
No Action |
No Action |
|
Immediate |
a measure can be attached to O or 1 unit |
||||
mzon_uni_id |
uni_id |
No Action |
No Action |
|
Immediate |
a measure can be attached to 0 or 1 unit |
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
23 |
Pages |
1 |
System |
|
Temporary |
|
With OID |
|
Definition
uni_id SERIAL,
uni_symbol VARCHAR(15) NOT NULL,
uni_name VARCHAR(50) NOT NULL,
uni_description VARCHAR(255) NOT NULL,
uni_data_type VARCHAR(255),
CONSTRAINT c_uni_name_uni UNIQUE(uni_name),
CONSTRAINT c_uni_symbol_uni UNIQUE(uni_symbol),
CONSTRAINT tr_unit_uni_pkey PRIMARY KEY(uni_id)
) ;
COMMENT ON TABLE public.tr_unit_uni
IS 'Table of measurement units';
COMMENT ON COLUMN public.tr_unit_uni.uni_id
IS 'Unique numeric identifier of the unit of measure';
COMMENT ON COLUMN public.tr_unit_uni.uni_symbol
IS 'Symbol used to represent unit of measure (e.g. m for meter)';
COMMENT ON COLUMN public.tr_unit_uni.uni_name
IS 'Common name of the unit of measurement';
COMMENT ON COLUMN public.tr_unit_uni.uni_description
IS 'Description of the unit of measure';
COMMENT ON COLUMN public.tr_unit_uni.uni_data_type
IS 'Current data type in which the data expressed in the measurement unit will be provided. For example numeric for measurements expressed in meters. This optional information is used to implement consistency checks.';
COMMENT ON CONSTRAINT c_uni_name_uni ON public.tr_unit_uni
IS 'The name of a unit must be unique';
COMMENT ON CONSTRAINT c_uni_symbol_uni ON public.tr_unit_uni
IS 'The symbol of a unit must be unique';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 07/12/2018 13:23 |
|