db_globoxylo
Previous topic Chapter index Next topic

Table: tj_mtre_mtre_ttre

 

 

Schema

public

 

Owner

postgres

 

Tablespace

(default)

 

Descriptions

Table associating an object measure to another object measure, the second being complementary (metadata) or necessary for the interpretation of the first

 

Columns

PK

FK

Name

Data type

Not null

Unique

Inherited

Default

Description

ttre_ref_mtre_id

integer

 

 

 

Automatic numeric identifier of the reference measure

ttre_meta_mtre_id

integer

 

 

 

Automatic numeric identifier of the measure considered as metadata of the reference measure

 

 

ttre_statut

varchar(32)

 

 

 

 

Indicator specifying the status of the metadata in relation to the reference measure. For example the mandatory or recommended character for interpretation.

 

Foreign Keys

Name

Columns

FK Table

FK Columns

Delete Action

Update Action

Deferrable

Check Time

Description

c_fk_meta_mtre_ttre

ttre_meta_mtre_id

public.t_measure_mtre

mtre_id

No Action

No Action

 

Immediate

The ttre_meta_mtre_id field necessarily corresponds to an existing measure

c_fk_ref_mtre_ttre

ttre_ref_mtre_id

public.t_measure_mtre

mtre_id

No Action

No Action

 

Immediate

The ttre_ref_mtre_id field necessarily corresponds to an existing measure

 

Check Constraints

There are no check constraints for table tj_mtre_mtre_ttre

 

Indices

Name

Type

Function

Columns

Primary Key

Unique

Description

tj_mtre_mtre_ttre_pkey

btree

 

ttre_ref_mtre_id, ttre_meta_mtre_id

 

x_btr_grp_ttre

btree

 

ttre_meta_mtre_id

 

 

Foreign key index to speed up updates / deletion

x_btr_mtre_ttre

btree

 

ttre_ref_mtre_id

 

 

Foreign key index to speed up updates / deletion

 

Triggers

There are no triggers for table tj_mtre_mtre_ttre

 

Rules

There are no rules for table tj_mtre_mtre_ttre

 

Policies

There are no policies for table tj_mtre_mtre_ttre

 

Referenced

There are no tables referenced by table tj_mtre_mtre_ttre

 

Properties

Property

Value

Inherited From

 

Rows

-1

Pages

0

System

 

Temporary

 

With OID

 

Definition

CREATE TABLE public.tj_mtre_mtre_ttre (
 ttre_ref_mtre_id INTEGER NOT NULL,
 ttre_meta_mtre_id INTEGER NOT NULL,
 ttre_statut VARCHAR(32),
 CONSTRAINT tj_mtre_mtre_ttre_pkey PRIMARY KEY(ttre_ref_mtre_id, ttre_meta_mtre_id),
 CONSTRAINT c_fk_meta_mtre_ttre FOREIGN KEY (ttre_meta_mtre_id)
   REFERENCES public.t_measure_mtre(mtre_id)
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE
,
 CONSTRAINT c_fk_ref_mtre_ttre FOREIGN KEY (ttre_ref_mtre_id)
   REFERENCES public.t_measure_mtre(mtre_id)
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE

) ;

COMMENT ON TABLE public.tj_mtre_mtre_ttre
IS 'Table associating an object measure to another object measure, the second being complementary (metadata) or necessary for the interpretation of the first';

COMMENT ON COLUMN public.tj_mtre_mtre_ttre.ttre_ref_mtre_id
IS 'Automatic numeric identifier of the reference measure';

COMMENT ON COLUMN public.tj_mtre_mtre_ttre.ttre_meta_mtre_id
IS 'Automatic numeric identifier of the measure considered as metadata of the reference measure';

COMMENT ON COLUMN public.tj_mtre_mtre_ttre.ttre_statut
IS 'Indicator specifying the status of the metadata in relation to the reference measure. For example the mandatory or recommended character for interpretation.';

COMMENT ON CONSTRAINT c_fk_meta_mtre_ttre ON public.tj_mtre_mtre_ttre
IS 'The ttre_meta_mtre_id field necessarily corresponds to an existing measure';

COMMENT ON CONSTRAINT c_fk_ref_mtre_ttre ON public.tj_mtre_mtre_ttre
IS 'The ttre_ref_mtre_id field necessarily corresponds to an existing measure';

CREATE INDEX x_btr_grp_ttre ON public.tj_mtre_mtre_ttre
 USING btree (ttre_meta_mtre_id);

COMMENT ON INDEX public.x_btr_grp_ttre
IS 'Foreign key index to speed up updates / deletion';

CREATE INDEX x_btr_mtre_ttre ON public.tj_mtre_mtre_ttre
 USING btree (ttre_ref_mtre_id);

COMMENT ON INDEX public.x_btr_mtre_ttre
IS 'Foreign key index to speed up updates / deletion';

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com)
Previous topic Chapter index Next topic