pggeodb.nancy.inra.fr/db_woodseer - db_woodseer on pggeodb.nancy.inra.fr |
|
Table: tr_acquisition_detection_mean_adm
pggeodb.nancy.inra.fr/db_woodseer - db_woodseer on pggeodb.nancy.inra.fr |
|
Table: tr_acquisition_detection_mean_adm
Schema
Owner
woodseer
Tablespace
(default)
Descriptions
Table of acquisition or singularities detections means
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
adm_id |
serial |
|
|
|
nextval('tr_acquisition_detection_mean_adm_adm_id_seq'::regclass) |
automatic numeric identifier of the mean |
|
|
adm_code |
varchar(16) |
|
|
|
|
unique code of the mean |
|
|
adm_name |
varchar(64) |
|
|
|
|
name/label of the mean |
|
|
adm_description |
varchar(300) |
|
|
|
|
description of the mean |
Foreign Keys
There are no foreign keys for table tr_acquisition_detection_mean_adm
Check Constraints
There are no check constraints for table tr_acquisition_detection_mean_adm
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
btree |
|
adm_code |
|
|
The code for a mean must be unique |
|
btree |
|
adm_id |
|
|
|
Triggers
There are no triggers for table tr_acquisition_detection_mean_adm
Rules
There are no rules for table tr_acquisition_detection_mean_adm
Policies
There are no policies for table tr_acquisition_detection_mean_adm
Referenced
Table | Schema | Foreign Key | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|---|---|
acq_adm_id |
adm_id |
No Action |
No Action |
|
Immediate |
an acquisition can be associated to one mean of acquisition |
||||
det_adm_id |
adm_id |
No Action |
No Action |
|
Immediate |
a singularity detection is associated to one and only one detection mean |
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
4 |
Pages |
1 |
System |
|
Temporary |
|
With OID |
|
Definition
adm_id SERIAL,
adm_code VARCHAR(16) NOT NULL,
adm_name VARCHAR(64) NOT NULL,
adm_description VARCHAR(300),
CONSTRAINT c_uni_code_adm UNIQUE(adm_code),
CONSTRAINT tr_acquisition_detection_mean_pkey PRIMARY KEY(adm_id)
) ;
COMMENT ON TABLE public.tr_acquisition_detection_mean_adm
IS 'Table of acquisition or singularities detections means';
COMMENT ON COLUMN public.tr_acquisition_detection_mean_adm.adm_id
IS 'automatic numeric identifier of the mean';
COMMENT ON COLUMN public.tr_acquisition_detection_mean_adm.adm_code
IS 'unique code of the mean';
COMMENT ON COLUMN public.tr_acquisition_detection_mean_adm.adm_name
IS 'name/label of the mean';
COMMENT ON COLUMN public.tr_acquisition_detection_mean_adm.adm_description
IS 'description of the mean';
COMMENT ON CONSTRAINT c_uni_code_adm ON public.tr_acquisition_detection_mean_adm
IS 'The code for a mean must be unique';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 07/12/2018 13:23 |
|