pggeodb.nancy.inra.fr/db_woodseer - db_woodseer on pggeodb.nancy.inra.fr |
|
Table: tj_transformation_matrix_tra
pggeodb.nancy.inra.fr/db_woodseer - db_woodseer on pggeodb.nancy.inra.fr |
|
Table: tj_transformation_matrix_tra
Schema
Owner
woodseer
Tablespace
(default)
Descriptions
Table of transformation matrices from an acquiqition to another
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
tra_acq_id_source |
integer |
|
|
|
|
unique identifier of the source acquisition for the transformation matrix |
|
|
tra_acq_id_target |
integer |
|
|
|
|
unique identifier of the target acquisition for the transformation matrix |
|
|
tra_matrix |
integer |
|
|
|
|
transformation matrix |
|
|
tra_observation |
varchar(255) |
|
|
|
|
Additional information about the transformation matrix |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
tra_acq_id_source |
acq_id |
No Action |
No Action |
|
Immediate |
Identifier of the source acquisition of the transformation is required |
||
tra_acq_id_target |
acq_id |
No Action |
No Action |
|
Immediate |
identifier of the target acquisition of the transformation is required |
Check Constraints
There are no check constraints for table tj_transformation_matrix_tra
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
btree |
|
tra_acq_id_source, tra_acq_id_target |
|
|
|
|
btree |
|
tra_acq_id_source |
|
|
Foreign key index to speed up updates / deletion |
|
btree |
|
tra_acq_id_target |
|
|
Foreign key index to speed up updates / deletion |
Triggers
There are no triggers for table tj_transformation_matrix_tra
Rules
There are no rules for table tj_transformation_matrix_tra
Policies
There are no policies for table tj_transformation_matrix_tra
Referenced
There are no tables referenced by table tj_transformation_matrix_tra
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
tra_acq_id_source INTEGER NOT NULL,
tra_acq_id_target INTEGER NOT NULL,
tra_matrix INTEGER NOT NULL,
tra_observation VARCHAR(255),
CONSTRAINT tj_transformation_matrix_tra_pkey PRIMARY KEY(tra_acq_id_source, tra_acq_id_target),
CONSTRAINT c_fk_acq_source_tra FOREIGN KEY (tra_acq_id_source)
REFERENCES public.t_acquisition_acq(acq_id)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT c_fk_acq_target_tra FOREIGN KEY (tra_acq_id_target)
REFERENCES public.t_acquisition_acq(acq_id)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tj_transformation_matrix_tra
IS 'Table of transformation matrices from an acquiqition to another';
COMMENT ON COLUMN public.tj_transformation_matrix_tra.tra_acq_id_source
IS 'unique identifier of the source acquisition for the transformation matrix';
COMMENT ON COLUMN public.tj_transformation_matrix_tra.tra_acq_id_target
IS 'unique identifier of the target acquisition for the transformation matrix';
COMMENT ON COLUMN public.tj_transformation_matrix_tra.tra_matrix
IS 'transformation matrix';
COMMENT ON COLUMN public.tj_transformation_matrix_tra.tra_observation
IS 'Additional information about the transformation matrix';
COMMENT ON CONSTRAINT c_fk_acq_source_tra ON public.tj_transformation_matrix_tra
IS 'Identifier of the source acquisition of the transformation is required';
COMMENT ON CONSTRAINT c_fk_acq_target_tra ON public.tj_transformation_matrix_tra
IS 'identifier of the target acquisition of the transformation is required';
CREATE INDEX x_btr_fkey_acq_source_tra ON public.tj_transformation_matrix_tra
USING btree (tra_acq_id_source);
COMMENT ON INDEX public.x_btr_fkey_acq_source_tra
IS 'Foreign key index to speed up updates / deletion';
CREATE INDEX x_btr_fkey_acq_target_tra ON public.tj_transformation_matrix_tra
USING btree (tra_acq_id_target);
COMMENT ON INDEX public.x_btr_fkey_acq_target_tra
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 |
|