pggeodb.nancy.inra.fr/db_woodseer - db_woodseer on pggeodb.nancy.inra.fr |
|
Table: t_detection_singularity_det
pggeodb.nancy.inra.fr/db_woodseer - db_woodseer on pggeodb.nancy.inra.fr |
|
Table: t_detection_singularity_det
Schema
Owner
woodseer
Tablespace
(default)
Descriptions
Table of singularities detections
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
det_id |
serial |
|
|
|
nextval('t_detection_singularity_det_det_id_seq'::regclass) |
unique identifier of the detection |
|
|
det_tsin_id |
integer |
|
|
|
|
Identifier of the corresponding type of singularity |
|
|
det_acq_id |
integer |
|
|
|
|
Identifier of the acquisition corresponding to the singularity detection |
|
|
det_adm_id |
integer |
|
|
|
|
Identifier of the detection mean used |
|
|
det_fil_id |
integer |
|
|
|
|
Identifier of the file corresponding to the detection of the singularity |
|
|
det_tsin_uncertainty |
varchar(128) |
|
|
|
|
information on the possible uncertainty of the type of singularity detected |
|
|
det_bbox_large |
public.box3d |
|
|
|
|
box encompassing the entire volume of a singularity |
|
|
det_bbox_small |
public.box3d |
|
|
|
|
encompassing box on the main axes of a singularity |
|
|
det_is_reference |
boolean |
|
|
|
|
Boolean indicating whether the singularity detection is considered a reference |
|
|
det_is_complete |
boolean |
|
|
|
|
Boolean indicating whether the detected singularity is considered complete |
|
|
det_observation |
varchar(255) |
|
|
|
|
Additional information about the singularity detection |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
det_acq_id |
acq_id |
No Action |
No Action |
|
Immediate |
a singularity detection is associated to one and only one acquisition |
||
det_adm_id |
adm_id |
No Action |
No Action |
|
Immediate |
a singularity detection is associated to one and only one detection mean |
||
det_fil_id |
fil_id |
No Action |
No Action |
|
Immediate |
a singularity detection is associated to one and only one source file |
||
det_tsin_id |
tsin_id |
No Action |
No Action |
|
Immediate |
a singularity detection is associated to one and only one singularity type |
Check Constraints
There are no check constraints for table t_detection_singularity_det
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
btree |
|
det_id |
|
|
|
|
btree |
|
det_acq_id |
|
|
Foreign key index to speed up updates / deletion |
|
btree |
|
det_adm_id |
|
|
Foreign key index to speed up updates / deletion |
|
btree |
|
det_fil_id |
|
|
Foreign key index to speed up updates / deletion |
|
btree |
|
det_tsin_id |
|
|
Foreign key index to speed up updates / deletion |
Triggers
There are no triggers for table t_detection_singularity_det
Rules
There are no rules for table t_detection_singularity_det
Policies
There are no policies for table t_detection_singularity_det
Referenced
Table | Schema | Foreign Key | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|---|---|
mdet_det_id |
det_id |
No Action |
No Action |
|
Immediate |
a measure must be attached to one and only one singularity detection |
||||
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 |
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
det_id SERIAL,
det_tsin_id INTEGER NOT NULL,
det_acq_id INTEGER NOT NULL,
det_adm_id INTEGER NOT NULL,
det_fil_id INTEGER,
det_tsin_uncertainty VARCHAR(128),
det_bbox_large public.box3d,
det_bbox_small public.box3d,
det_is_reference BOOLEAN,
det_is_complete BOOLEAN,
det_observation VARCHAR(255),
CONSTRAINT t_detection_singularity_det_pkey PRIMARY KEY(det_id),
CONSTRAINT c_fk_acq_det FOREIGN KEY (det_acq_id)
REFERENCES public.t_acquisition_acq(acq_id)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT c_fk_adm_det FOREIGN KEY (det_adm_id)
REFERENCES public.tr_acquisition_detection_mean_adm(adm_id)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT c_fk_fil_det FOREIGN KEY (det_fil_id)
REFERENCES public.tr_file_fil(fil_id)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT c_fk_tsin_det FOREIGN KEY (det_tsin_id)
REFERENCES public.tr_type_singularity_tsin(tsin_id)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.t_detection_singularity_det
IS 'Table of singularities detections';
COMMENT ON COLUMN public.t_detection_singularity_det.det_id
IS 'unique identifier of the detection';
COMMENT ON COLUMN public.t_detection_singularity_det.det_tsin_id
IS 'Identifier of the corresponding type of singularity';
COMMENT ON COLUMN public.t_detection_singularity_det.det_acq_id
IS 'Identifier of the acquisition corresponding to the singularity detection';
COMMENT ON COLUMN public.t_detection_singularity_det.det_adm_id
IS 'Identifier of the detection mean used';
COMMENT ON COLUMN public.t_detection_singularity_det.det_fil_id
IS 'Identifier of the file corresponding to the detection of the singularity';
COMMENT ON COLUMN public.t_detection_singularity_det.det_tsin_uncertainty
IS 'information on the possible uncertainty of the type of singularity detected';
COMMENT ON COLUMN public.t_detection_singularity_det.det_bbox_large
IS 'box encompassing the entire volume of a singularity';
COMMENT ON COLUMN public.t_detection_singularity_det.det_bbox_small
IS 'encompassing box on the main axes of a singularity';
COMMENT ON COLUMN public.t_detection_singularity_det.det_is_reference
IS 'Boolean indicating whether the singularity detection is considered a reference';
COMMENT ON COLUMN public.t_detection_singularity_det.det_is_complete
IS 'Boolean indicating whether the detected singularity is considered complete';
COMMENT ON COLUMN public.t_detection_singularity_det.det_observation
IS 'Additional information about the singularity detection';
COMMENT ON CONSTRAINT c_fk_acq_det ON public.t_detection_singularity_det
IS 'a singularity detection is associated to one and only one acquisition';
COMMENT ON CONSTRAINT c_fk_adm_det ON public.t_detection_singularity_det
IS 'a singularity detection is associated to one and only one detection mean';
COMMENT ON CONSTRAINT c_fk_fil_det ON public.t_detection_singularity_det
IS 'a singularity detection is associated to one and only one source file';
COMMENT ON CONSTRAINT c_fk_tsin_det ON public.t_detection_singularity_det
IS 'a singularity detection is associated to one and only one singularity type';
CREATE INDEX x_btr_fkey_acq_det ON public.t_detection_singularity_det
USING btree (det_acq_id);
COMMENT ON INDEX public.x_btr_fkey_acq_det
IS 'Foreign key index to speed up updates / deletion';
CREATE INDEX x_btr_fkey_adm_det ON public.t_detection_singularity_det
USING btree (det_adm_id);
COMMENT ON INDEX public.x_btr_fkey_adm_det
IS 'Foreign key index to speed up updates / deletion';
CREATE INDEX x_btr_fkey_fil_det ON public.t_detection_singularity_det
USING btree (det_fil_id);
COMMENT ON INDEX public.x_btr_fkey_fil_det
IS 'Foreign key index to speed up updates / deletion';
CREATE INDEX x_btr_fkey_tsin_det ON public.t_detection_singularity_det
USING btree (det_tsin_id);
COMMENT ON INDEX public.x_btr_fkey_tsin_det
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 |
|