pggeodb-preprod.nancy.inra.fr/db_pgd - db_pgd on pggeodb-preprod.nancy.inra.fr
Previous topic Chapter index Next topic

Table: tr_norme_norm

 

 

Schema

public

 

Owner

pgd

 

Tablespace

(default)

 

Descriptions

Table contenant les normes référencées dans la base

 

Fields

PK

FK

Name

Data type

Not null

Unique

Inherited

Default

Description

 

norm_id

serial

 

nextval('tr_norme_norm_norm_id_seq'::regclass)

Identifiant numérique automatique de la norme

 

 

norm_nom

varchar(50)

 

 

 

Nom usuel de la norme

 

 

norm_date

date

 

 

 

 

Date de parution de la norme

 

 

norm_url

varchar(255)

 

 

 

 

Url d'accès au document de la norme

 

 

norm_version

varchar(10)

 

 

 

Information de version de la norme

 

Foreign Keys

There are no foreign keys for table tr_norme_norm

 

Check Constraints

There are no check constraints for table tr_norme_norm

 

Indices

Name

Type

Function

Fields

Primary Key

Unique

Description

c_uni_nom_version_norm

btree

 

norm_nom, norm_version

 

Le couple nom / version d'une norme doit être unique

tr_norme_norm_pkey

btree

 

norm_id

 

 

Triggers

There are no triggers for table tr_norme_norm

 

Rules

There are no rules for table tr_norme_norm

 

Policies

There are no policies for table tr_norme_norm

 

Referenced

There are no tables referenced by table tr_norme_norm

 

Properties

Property

Value

Inherited From

 

Rows

0

Pages

0

System

 

Temporary

 

With OID

 

Definition

CREATE TABLE public.tr_norme_norm (
 norm_id SERIAL,
 norm_nom VARCHAR(50) NOT NULL,
 norm_date DATE,
 norm_url VARCHAR(255),
 norm_version VARCHAR(10) NOT NULL,
 CONSTRAINT c_uni_nom_version_norm UNIQUE(norm_nom, norm_version),
 CONSTRAINT tr_norme_norm_pkey PRIMARY KEY(norm_id)
) ;

COMMENT ON TABLE public.tr_norme_norm
IS 'Table contenant les normes référencées dans la base';

COMMENT ON COLUMN public.tr_norme_norm.norm_id
IS 'Identifiant numérique automatique de la norme';

COMMENT ON COLUMN public.tr_norme_norm.norm_nom
IS 'Nom usuel de la norme';

COMMENT ON COLUMN public.tr_norme_norm.norm_date
IS 'Date de parution de la norme';

COMMENT ON COLUMN public.tr_norme_norm.norm_url
IS 'Url d''accès au document de la norme';

COMMENT ON COLUMN public.tr_norme_norm.norm_version
IS 'Information de version de la norme';

COMMENT ON CONSTRAINT c_uni_nom_version_norm ON public.tr_norme_norm
IS 'Le couple nom / version d''une norme doit être unique';

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 07/12/2018 13:23
Previous topic Chapter index Next topic