db_globoxylo
Previous topic Chapter index Next topic

Table: tj_mzon_mzon_tzon

 

 

Schema

public

 

Owner

postgres

 

Tablespace

(default)

 

Descriptions

Join table associating a measure with another 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

tzon_ref_mzon_id

integer

 

 

 

Automatic numeric identifier of the reference measurement

tzon_meta_mzon_id

integer

 

 

 

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

 

 

tzon_status

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_mzon_tzon

tzon_meta_mzon_id

public.t_measure_mzon

mzon_id

No Action

No Action

 

Immediate

The tzon_meta_mzon_id field necessarily corresponds to an existing measurement

c_fk_ref_mzon_tzon

tzon_ref_mzon_id

public.t_measure_mzon

mzon_id

No Action

No Action

 

Immediate

The tzon_ref_mzon_id field necessarily corresponds to an existing measurement

 

Check Constraints

There are no check constraints for table tj_mzon_mzon_tzon

 

Indices

Name

Type

Function

Columns

Primary Key

Unique

Description

tj_mzon_mzon_tzon_pkey

btree

 

tzon_ref_mzon_id, tzon_meta_mzon_id

 

x_btr_meta_mzon_tzon

btree

 

tzon_meta_mzon_id

 

 

Foreign key index to speed up updates / deletion

x_btr_ref_mzon_tzon

btree

 

tzon_ref_mzon_id

 

 

Foreign key index to speed up updates / deletion

 

Triggers

There are no triggers for table tj_mzon_mzon_tzon

 

Rules

There are no rules for table tj_mzon_mzon_tzon

 

Policies

There are no policies for table tj_mzon_mzon_tzon

 

Referenced

There are no tables referenced by table tj_mzon_mzon_tzon

 

Properties

Property

Value

Inherited From

 

Rows

-1

Pages

0

System

 

Temporary

 

With OID

 

Definition

CREATE TABLE public.tj_mzon_mzon_tzon (
 tzon_ref_mzon_id INTEGER NOT NULL,
 tzon_meta_mzon_id INTEGER NOT NULL,
 tzon_status VARCHAR(32),
 CONSTRAINT tj_mzon_mzon_tzon_pkey PRIMARY KEY(tzon_ref_mzon_id, tzon_meta_mzon_id),
 CONSTRAINT c_fk_meta_mzon_tzon FOREIGN KEY (tzon_meta_mzon_id)
   REFERENCES public.t_measure_mzon(mzon_id)
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE
,
 CONSTRAINT c_fk_ref_mzon_tzon FOREIGN KEY (tzon_ref_mzon_id)
   REFERENCES public.t_measure_mzon(mzon_id)
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE

) ;

COMMENT ON TABLE public.tj_mzon_mzon_tzon
IS 'Join table associating a measure with another measure, the second being complementary (metadata) or necessary for the interpretation of the first.';

COMMENT ON COLUMN public.tj_mzon_mzon_tzon.tzon_ref_mzon_id
IS 'Automatic numeric identifier of the reference measurement';

COMMENT ON COLUMN public.tj_mzon_mzon_tzon.tzon_meta_mzon_id
IS 'Automatic numeric identifier of the measurement considered as metadata of the reference measurement';

COMMENT ON COLUMN public.tj_mzon_mzon_tzon.tzon_status
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_mzon_tzon ON public.tj_mzon_mzon_tzon
IS 'The tzon_meta_mzon_id field necessarily corresponds to an existing measurement';

COMMENT ON CONSTRAINT c_fk_ref_mzon_tzon ON public.tj_mzon_mzon_tzon
IS 'The tzon_ref_mzon_id field necessarily corresponds to an existing measurement';

CREATE INDEX x_btr_meta_mzon_tzon ON public.tj_mzon_mzon_tzon
 USING btree (tzon_meta_mzon_id);

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

CREATE INDEX x_btr_ref_mzon_tzon ON public.tj_mzon_mzon_tzon
 USING btree (tzon_ref_mzon_id);

COMMENT ON INDEX public.x_btr_ref_mzon_tzon
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