db_toff on pggeodb.nancy.inra.fr
Previous topic Chapter index Next topic

Table: t_publi_pub

 

 

Schema

public

 

Owner

postgres

 

Tablespace

(default)

 

Descriptions

Publication table / Table des publications

 

Fields

PK

FK

Name

Data type

Not null

Unique

Inherited

Default

Description

 

pub_id

serial

 

nextval('t_publi_pub_pub_id_seq'::regclass)

Automatic ID of the publication / Identifiant automatique de la publication

 

pub_typ_id

integer

 

 

 

Automatic ID of the publication type / Identifiant automatique du type de publication de rattachement

 

 

pub_name

text

 

 

Publication name / Nom de la publication

 

 

pub_short_name

varchar(50)

 

 

 

Publication short name used as the definition of a particular set of metadata / Nom court de la publication notamment utilisé pour la définition des ensembles de métadonnées

 

 

pub_source

varchar

 

 

 

 

Publication source / Source de la publication

 

Foreign Keys

Name

Fields

FK Table

FK Fields

Delete Action

Update Action

Deferrable

Check Time

Description

c_fk_typ_pub

pub_typ_id

public.tr_type_publication_typ

typ_id

No Action

No Action

 

Immediate

A particular publication is related to only one publication type / Une publication est rattachée à un et un seul type de publication

 

Check Constraints

There are no check constraints for table t_publi_pub

 

Indices

Name

Type

Function

Fields

Primary Key

Unique

Description

c_uni_name_pub

btree

 

pub_name

 

pub_name must be unique / le champ pub_name ne peut contenir de doublons

t_publi_pub_pkey

btree

 

pub_id

 

x_btr_typ_pub

btree

 

pub_typ_id

 

 

Foreign key index linking a publication to a publication type /Index sur la clé étrangère rattachant une publication à un type de publication

 

Triggers

There are no triggers for table t_publi_pub

 

Rules

There are no rules for table t_publi_pub

 

Policies

There are no policies for table t_publi_pub

 

Referenced

Table

Schema

Foreign Key

Fields

FK Table

FK Fields

Delete Action

Update Action

Deferrable

Check Time

Description

t_set_metadata_measure_met

public

c_fk_pub_met

met_pub_id

public.t_publi_pub

pub_id

No Action

No Action

 

Immediate

A measure environment is related to only one publication / Un environnement de mesure est associé à une et une seule publication

 

Properties

Property

Value

Inherited From

 

Rows

0

Pages

0

System

 

Temporary

 

With OID

 

 

Definition

CREATE TABLE public.t_publi_pub (
 pub_id SERIAL,
 pub_typ_id INTEGER NOT NULL,
 pub_name TEXT NOT NULL,
 pub_short_name VARCHAR(50) NOT NULL,
 pub_source VARCHAR,
 CONSTRAINT c_uni_name_pub UNIQUE(pub_name),
 CONSTRAINT t_publi_pub_pkey PRIMARY KEY(pub_id),
 CONSTRAINT c_fk_typ_pub FOREIGN KEY (pub_typ_id)
   REFERENCES public.tr_type_publication_typ(typ_id)
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE

)
WITH (oids = false);

COMMENT ON TABLE public.t_publi_pub
IS 'Publication table / Table des publications';

COMMENT ON COLUMN public.t_publi_pub.pub_id
IS 'Automatic ID of the publication / Identifiant automatique de la publication';

COMMENT ON COLUMN public.t_publi_pub.pub_typ_id
IS 'Automatic ID of the publication type / Identifiant automatique du type de publication de rattachement';

COMMENT ON COLUMN public.t_publi_pub.pub_name
IS 'Publication name / Nom de la publication';

COMMENT ON COLUMN public.t_publi_pub.pub_short_name
IS 'Publication short name used as the definition of a particular set of metadata / Nom court de la publication notamment utilisé pour la définition des ensembles de métadonnées';

COMMENT ON COLUMN public.t_publi_pub.pub_source
IS 'Publication source / Source de la publication';

COMMENT ON CONSTRAINT c_fk_typ_pub ON public.t_publi_pub
IS 'A particular publication is related to only one publication type / Une publication est rattachée à un et un seul type de publication';

COMMENT ON CONSTRAINT c_uni_name_pub ON public.t_publi_pub
IS 'pub_name must be unique / le champ pub_name ne peut contenir de doublons';

CREATE INDEX x_btr_typ_pub ON public.t_publi_pub
 USING btree (pub_typ_id);

COMMENT ON INDEX public.x_btr_typ_pub
IS 'Foreign key index linking a  publication to a publication type /Index sur la clé étrangère rattachant une publication à un type de publication';

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 19/06/2019 10:17
Previous topic Chapter index Next topic