db_globoxylo |
|
Table: tj_msam_msam_tsam
db_globoxylo |
|
Table: tj_msam_msam_tsam
Schema
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 |
|---|---|---|---|---|---|---|---|---|
|
|
tsam_ref_msam_id |
integer |
|
|
|
|
Automatic numeric identifier of the reference measure |
|
|
tsam_meta_msam_id |
integer |
|
|
|
|
Automatic numeric identifier of the measure considered as metadata of the reference measure |
|
|
tsam_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 |
|---|---|---|---|---|---|---|---|---|
tsam_meta_msam_id |
msam_id |
No Action |
No Action |
|
Immediate |
The tsam_meta_msam_id field necessarily corresponds to an existing measure |
||
tsam_ref_msam_id |
msam_id |
No Action |
No Action |
|
Immediate |
The tsam_ref_msam_id field necessarily corresponds to an existing measure |
Check Constraints
There are no check constraints for table tj_msam_msam_tsam
Indices
Name | Type | Function | Columns | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
btree |
|
tsam_ref_msam_id, tsam_meta_msam_id |
|
|
|
|
btree |
|
tsam_meta_msam_id |
|
|
Foreign key index to speed up updates / deletion |
|
btree |
|
tsam_ref_msam_id |
|
|
Foreign key index to speed up updates / deletion |
Triggers
There are no triggers for table tj_msam_msam_tsam
Rules
There are no rules for table tj_msam_msam_tsam
Policies
There are no policies for table tj_msam_msam_tsam
Referenced
There are no tables referenced by table tj_msam_msam_tsam
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
-1 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
tsam_ref_msam_id INTEGER NOT NULL,
tsam_meta_msam_id INTEGER NOT NULL,
tsam_statut VARCHAR(32),
CONSTRAINT tj_msam_msam_tsam_pkey PRIMARY KEY(tsam_ref_msam_id, tsam_meta_msam_id),
CONSTRAINT c_fk_meta_msam_tsam FOREIGN KEY (tsam_meta_msam_id)
REFERENCES public.t_measure_msam(msam_id)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT c_fk_ref_msam_tsam FOREIGN KEY (tsam_ref_msam_id)
REFERENCES public.t_measure_msam(msam_id)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tj_msam_msam_tsam
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_msam_msam_tsam.tsam_ref_msam_id
IS 'Automatic numeric identifier of the reference measure';
COMMENT ON COLUMN public.tj_msam_msam_tsam.tsam_meta_msam_id
IS 'Automatic numeric identifier of the measure considered as metadata of the reference measure';
COMMENT ON COLUMN public.tj_msam_msam_tsam.tsam_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_msam_tsam ON public.tj_msam_msam_tsam
IS 'The tsam_meta_msam_id field necessarily corresponds to an existing measure';
COMMENT ON CONSTRAINT c_fk_ref_msam_tsam ON public.tj_msam_msam_tsam
IS 'The tsam_ref_msam_id field necessarily corresponds to an existing measure';
CREATE INDEX x_btr_grp_tsam ON public.tj_msam_msam_tsam
USING btree (tsam_meta_msam_id);
COMMENT ON INDEX public.x_btr_grp_tsam
IS 'Foreign key index to speed up updates / deletion';
CREATE INDEX x_btr_msam_tsam ON public.tj_msam_msam_tsam
USING btree (tsam_ref_msam_id);
COMMENT ON INDEX public.x_btr_msam_tsam
IS 'Foreign key index to speed up updates / deletion';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) |
|