pggeodb.nancy.inra.fr/db_woodseer - db_woodseer on pggeodb.nancy.inra.fr |
|
Table: tj_detection_singularity_pairing_dsp
pggeodb.nancy.inra.fr/db_woodseer - db_woodseer on pggeodb.nancy.inra.fr |
|
Table: tj_detection_singularity_pairing_dsp
Schema
Owner
woodseer
Tablespace
(default)
Descriptions
Table of singularities detections pairing
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dsp_det_id_source |
integer |
|
|
|
|
unique identifier of a singularity pairing as source |
|
|
dsp_det_id_target |
integer |
|
|
|
|
unique identifier of a singularity pairing as target |
|
|
dsp_to_complete |
varchar |
|
|
|
|
need to be completed |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
dsp_det_id_source |
det_id |
No Action |
No Action |
|
Immediate |
identifier of the source singularity detection paired is required |
||
dsp_det_id_target |
det_id |
No Action |
No Action |
|
Immediate |
identifier of the target singularity detection paired is required |
Check Constraints
There are no check constraints for table tj_detection_singularity_pairing_dsp
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
btree |
|
dsp_det_id_source, dsp_det_id_target |
|
|
|
|
btree |
|
dsp_det_id_source |
|
|
Foreign key index to speed up updates / deletion |
|
btree |
|
dsp_det_id_target |
|
|
Foreign key index to speed up updates / deletion |
Triggers
There are no triggers for table tj_detection_singularity_pairing_dsp
Rules
There are no rules for table tj_detection_singularity_pairing_dsp
Policies
There are no policies for table tj_detection_singularity_pairing_dsp
Referenced
There are no tables referenced by table tj_detection_singularity_pairing_dsp
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dsp_det_id_source INTEGER NOT NULL,
dsp_det_id_target INTEGER NOT NULL,
dsp_to_complete VARCHAR,
CONSTRAINT tj_detection_singularity_pairing_dsp_pkey PRIMARY KEY(dsp_det_id_source, dsp_det_id_target),
CONSTRAINT c_fk_det_source_dsp FOREIGN KEY (dsp_det_id_source)
REFERENCES public.t_detection_singularity_det(det_id)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT c_fk_det_target_dsp FOREIGN KEY (dsp_det_id_target)
REFERENCES public.t_detection_singularity_det(det_id)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tj_detection_singularity_pairing_dsp
IS 'Table of singularities detections pairing';
COMMENT ON COLUMN public.tj_detection_singularity_pairing_dsp.dsp_det_id_source
IS 'unique identifier of a singularity pairing as source';
COMMENT ON COLUMN public.tj_detection_singularity_pairing_dsp.dsp_det_id_target
IS 'unique identifier of a singularity pairing as target';
COMMENT ON COLUMN public.tj_detection_singularity_pairing_dsp.dsp_to_complete
IS 'need to be completed';
COMMENT ON CONSTRAINT c_fk_det_source_dsp ON public.tj_detection_singularity_pairing_dsp
IS 'identifier of the source singularity detection paired is required';
COMMENT ON CONSTRAINT c_fk_det_target_dsp ON public.tj_detection_singularity_pairing_dsp
IS 'identifier of the target singularity detection paired is required';
CREATE INDEX x_btr_fkey_det_source_dsp ON public.tj_detection_singularity_pairing_dsp
USING btree (dsp_det_id_source);
COMMENT ON INDEX public.x_btr_fkey_det_source_dsp
IS 'Foreign key index to speed up updates / deletion';
CREATE INDEX x_btr_fkey_det_target_dsp ON public.tj_detection_singularity_pairing_dsp
USING btree (dsp_det_id_target);
COMMENT ON INDEX public.x_btr_fkey_det_target_dsp
IS 'Foreign key index to speed up updates / deletion';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 07/12/2018 13:23 |
|